DBA Data[Home] [Help]

APPS.CSM_CSP_REQ_LINES_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_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_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_LINES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
21:
22: PROCEDURE CSP_REQ_LINES_MDIRTY_I(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)

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

15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_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_LINES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
21:
22: PROCEDURE CSP_REQ_LINES_MDIRTY_I(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)
23: IS

Line 33: CSM_ACC_PKG.Insert_Acc

29: BEGIN
30: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,
31: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
32:
33: CSM_ACC_PKG.Insert_Acc
34: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
35: ,P_ACC_TABLE_NAME => g_acc_table_name1
36: ,P_SEQ_NAME => g_acc_sequence_name1
37: ,P_PK1_NAME => g_pk1_name1

Line 65: CSM_ACC_PKG.Delete_Acc

61: BEGIN
62: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,
63: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
64:
65: CSM_ACC_PKG.Delete_Acc
66: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
67: ,P_ACC_TABLE_NAME => g_acc_table_name1
68: ,P_PK1_NAME => g_pk1_name1
69: ,P_PK1_NUM_VALUE => p_requirement_line_id

Line 97: l_access_id := CSM_ACC_PKG.Get_Acc_Id

93: BEGIN
94: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,
95: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
96:
97: l_access_id := CSM_ACC_PKG.Get_Acc_Id
98: ( P_ACC_TABLE_NAME => g_acc_table_name1
99: ,P_PK1_NAME => g_pk1_name1
100: ,P_PK1_NUM_VALUE => p_requirement_line_id
101: ,P_USER_ID => p_user_id

Line 105: CSM_ACC_PKG.Update_Acc

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