DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_HEADER_EVENT_PKG dependencies on CSM_ACC_PKG

Line 19: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;

15: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC';
16: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';
17: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC_S';
18: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_HEADER_ID';
19: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;
20:
21: PROCEDURE DEBRIEF_HEADER_INS_INIT(p_debrief_header_id IN NUMBER, p_h_user_id IN NUMBER,
22: p_flow_type IN VARCHAR2)
23: IS

Line 103: CSM_ACC_PKG.Insert_Acc

99: BEGIN
100: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,
101: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
102:
103: CSM_ACC_PKG.Insert_Acc
104: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
105: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
106: ,P_SEQ_NAME => g_debrief_seq_name
107: ,P_PK1_NAME => g_debrief_pk1_name

Line 104: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')

100: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_I for debrief_header_id: ' || p_debrief_header_id,
101: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
102:
103: CSM_ACC_PKG.Insert_Acc
104: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
105: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
106: ,P_SEQ_NAME => g_debrief_seq_name
107: ,P_PK1_NAME => g_debrief_pk1_name
108: ,P_PK1_NUM_VALUE => p_debrief_header_id

Line 199: CSM_ACC_PKG.Delete_Acc

195: BEGIN
196: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,
197: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
198:
199: CSM_ACC_PKG.Delete_Acc
200: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
201: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
202: ,P_PK1_NAME => g_debrief_pk1_name
203: ,P_PK1_NUM_VALUE => p_debrief_header_id

Line 200: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')

196: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_D for debrief_header_id: ' || p_debrief_header_id,
197: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
198:
199: CSM_ACC_PKG.Delete_Acc
200: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
201: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
202: ,P_PK1_NAME => g_debrief_pk1_name
203: ,P_PK1_NUM_VALUE => p_debrief_header_id
204: ,P_USER_ID => p_user_id

Line 231: l_access_id := CSM_ACC_PKG.Get_Acc_Id

227: BEGIN
228: CSM_UTIL_PKG.LOG('Entering DEBRIEF_HEADER_MDIRTY_U for debrief_header_id: ' || p_debrief_header_id,
229: 'CSM_DEBRIEF_HEADER_EVENT_PKG.DEBRIEF_HEADER_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
230:
231: l_access_id := CSM_ACC_PKG.Get_Acc_Id
232: ( P_ACC_TABLE_NAME => g_debrief_acc_table_name
233: ,P_PK1_NAME => g_debrief_pk1_name
234: ,P_PK1_NUM_VALUE => p_debrief_header_id
235: ,P_USER_ID => p_user_id

Line 239: CSM_ACC_PKG.Update_Acc

235: ,P_USER_ID => p_user_id
236: );
237:
238: IF l_access_id <> -1 THEN
239: CSM_ACC_PKG.Update_Acc
240: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
241: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
242: ,P_USER_ID => p_user_id
243: ,p_ACCESS_ID => l_access_id

Line 240: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')

236: );
237:
238: IF l_access_id <> -1 THEN
239: CSM_ACC_PKG.Update_Acc
240: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_DEBRIEF_HEADERS')
241: ,P_ACC_TABLE_NAME => g_debrief_acc_table_name
242: ,P_USER_ID => p_user_id
243: ,p_ACCESS_ID => l_access_id
244: );