DBA Data[Home] [Help]

APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on CSM_PROFILE_PKG

Line 282: l_profile_value := NVL(CSM_PROFILE_PKG.get_task_history_days(NULL),0);

278:
279: L_Current_Date := Sysdate;
280: --This profile is supported only at site level.
281: --So it is not required to be called for each user
282: l_profile_value := NVL(CSM_PROFILE_PKG.get_task_history_days(NULL),0);
283: -- get the last run date
284: OPEN l_last_run_date_csr;
285: FETCH l_last_run_date_csr INTO l_last_run_date;
286: CLOSE l_last_run_date_csr;

Line 454: l_profile_value := NVL(CSM_PROFILE_PKG.get_task_history_days(p_user_id),0);

450:
451: BEGIN
452: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',
453: g_table_name,FND_LOG.LEVEL_PROCEDURE);
454: l_profile_value := NVL(CSM_PROFILE_PKG.get_task_history_days(p_user_id),0);
455:
456: OPEN l_mat_insert_csr(p_user_id, l_profile_value);
457: LOOP
458: IF l_tran_id_lst.COUNT > 0 THEN