APPS.CSM_CSP_REQ_HEADERS_EVENT_PKG dependencies on CSM_ACC_PKG

Line 18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_HEADERS';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_HEADERS');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_HEADER_ID';
21:
22: --Bug 16164491

Line 19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_HEADERS');

15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_HEADERS';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_HEADERS');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_HEADER_ID';
21:
22: --Bug 16164491
23: CURSOR c_shipToHZPS(b_rhId NUMBER,b_user_id NUMBER)

Line 46: CSM_ACC_PKG.Insert_Acc

42: BEGIN
43: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_I for requirement_header_id: ' || p_requirement_header_id,
44: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
45:
46: CSM_ACC_PKG.Insert_Acc
47: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
48: ,P_ACC_TABLE_NAME => g_acc_table_name1
49: ,P_SEQ_NAME => g_acc_sequence_name1
50: ,P_PK1_NAME => g_pk1_name1

Line 94: CSM_ACC_PKG.Delete_Acc

90: BEGIN
91: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_D for requirement_header_id: ' || p_requirement_header_id,
92: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
93:
94: CSM_ACC_PKG.Delete_Acc
95: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
96: ,P_ACC_TABLE_NAME => g_acc_table_name1
97: ,P_PK1_NAME => g_pk1_name1
98: ,P_PK1_NUM_VALUE => p_requirement_header_id

Line 127: l_access_id := CSM_ACC_PKG.Get_Acc_Id

123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_U for requirement_header_id: ' || p_requirement_header_id,
125: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
126:
127: l_access_id := CSM_ACC_PKG.Get_Acc_Id
128: ( P_ACC_TABLE_NAME => g_acc_table_name1
129: ,P_PK1_NAME => g_pk1_name1
130: ,P_PK1_NUM_VALUE => p_requirement_header_id
131: ,P_USER_ID => p_user_id

Line 135: CSM_ACC_PKG.Update_Acc

131: ,P_USER_ID => p_user_id
132: );
133:
134: IF l_access_id <> -1 THEN
135: CSM_ACC_PKG.Update_Acc
136: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
137: ,P_ACC_TABLE_NAME => g_acc_table_name1
138: ,P_ACCESS_ID => l_access_id
139: ,P_USER_ID => p_user_id