DBA Data[Home] [Help]

APPS.CSM_AUTO_SYNC_NFN_PKG dependencies on CSM_ACC_PKG

Line 25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

21: g_auto_sync_nfn_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC';
22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');
27:
28:
29: CURSOR c_auto_sync_nfn_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS

Line 26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');

22: g_auto_sync_nfn_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN';
23: g_auto_sync_nfn_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_NFN_ACC_S';
24: g_auto_sync_nfn_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_nfn_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN');
27:
28:
29: CURSOR c_auto_sync_nfn_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
30: SELECT *

Line 42: CSM_ACC_PKG.Insert_Acc

38: IS
39: l_sysdate DATE;
40: l_count NUMBER;
41: BEGIN
42: CSM_ACC_PKG.Insert_Acc
43: ( P_PUBLICATION_ITEM_NAMES => g_auto_sync_nfn_pubi_name
44: ,P_ACC_TABLE_NAME => g_auto_sync_nfn_acc_table_name
45: ,P_SEQ_NAME => g_auto_sync_nfn_seq_name
46: ,P_PK1_NAME => g_auto_sync_nfn_pk1_name