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 66: CSM_ACC_PKG.Delete_Acc

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

Line 98: l_access_id := CSM_ACC_PKG.Get_Acc_Id

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

Line 106: CSM_ACC_PKG.Update_Acc

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