DBA Data[Home] [Help]

APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on CSM_MTL_PARAMETERS_ACC_S

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_PARAMETERS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_PARAMETERS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_PARAMETERS';

Line 146: SELECT csm_mtl_parameters_acc_s.nextval

142: --get the users with this language
143: l_all_omfs_palm_resource_list := l_null_resource_list;
144: l_all_omfs_palm_resource_list := csm_util_pkg.get_all_omfs_palm_res_list;
145:
146: SELECT csm_mtl_parameters_acc_s.nextval
147: INTO l_access_id
148: FROM dual;
149:
150: --nullify the access list