DBA Data[Home] [Help]

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: PROCEDURE CSP_REQ_HEADERS_MDIRTY_I(p_requirement_header_id IN NUMBER,

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: PROCEDURE CSP_REQ_HEADERS_MDIRTY_I(p_requirement_header_id IN NUMBER,
23: p_user_id IN NUMBER)

Line 34: CSM_ACC_PKG.Insert_Acc

30: BEGIN
31: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_I for requirement_header_id: ' || p_requirement_header_id,
32: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
33:
34: CSM_ACC_PKG.Insert_Acc
35: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
36: ,P_ACC_TABLE_NAME => g_acc_table_name1
37: ,P_SEQ_NAME => g_acc_sequence_name1
38: ,P_PK1_NAME => g_pk1_name1

Line 67: CSM_ACC_PKG.Delete_Acc

63: BEGIN
64: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_D for requirement_header_id: ' || p_requirement_header_id,
65: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
66:
67: CSM_ACC_PKG.Delete_Acc
68: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
69: ,P_ACC_TABLE_NAME => g_acc_table_name1
70: ,P_PK1_NAME => g_pk1_name1
71: ,P_PK1_NUM_VALUE => p_requirement_header_id

Line 100: l_access_id := CSM_ACC_PKG.Get_Acc_Id

96: BEGIN
97: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_U for requirement_header_id: ' || p_requirement_header_id,
98: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
99:
100: l_access_id := CSM_ACC_PKG.Get_Acc_Id
101: ( P_ACC_TABLE_NAME => g_acc_table_name1
102: ,P_PK1_NAME => g_pk1_name1
103: ,P_PK1_NUM_VALUE => p_requirement_header_id
104: ,P_USER_ID => p_user_id

Line 108: CSM_ACC_PKG.Update_Acc

104: ,P_USER_ID => p_user_id
105: );
106:
107: IF l_access_id <> -1 THEN
108: CSM_ACC_PKG.Update_Acc
109: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
110: ,P_ACC_TABLE_NAME => g_acc_table_name1
111: ,P_ACCESS_ID => l_access_id
112: ,P_USER_ID => p_user_id