Browsing articles tagged with "PAY_COST_ALLOCATION_API.CREATE_COST_ALLOCATION - orasistem | Oracle E-Business Suite Paylaşım Platformu"
Oca
25
2016

HR – Kişi Masraf Merkezi Atama (CREATE_COST_ALLOCATION API)

Merhaba, Aşağıda kişi görev kartına ait masraf merkezi oluşturma için örnek script bulunmaktadır.   CREATE OR REPLACE PROCEDURE APPS.CREATE_COST (   p_id IN NUMBER ) IS CURSOR C_COST_ALLOC IS SELECT * FROM xx_hr_detail_T WHERE id = p_id;   — SELECT ‘0101001’ G_MASRAF_MERKEZI FROM DUAL;   LC_C_COST_ALLOC C_COST_ALLOC%ROWTYPE; L_COMBINATION_NAME VARCHAR2 (240); L_COST_ALLOCATION_ID NUMBER; L_EFFECTIVE_START_DATE DATE; L_EFFECTIVE_END_DATE […]