eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_ACC_PKG

Line 7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

3:
4: /*** Globals ***/
5: -- CSM_CONTR_HEADERS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';
11:

Line 8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');

4: /*** Globals ***/
5: -- CSM_CONTR_HEADERS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';
11:
12: -- CSM_CONTR_BUSS_PROCESSES

Line 14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';
11:
12: -- CSM_CONTR_BUSS_PROCESSES
13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';
14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';

Line 15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');

11:
12: -- CSM_CONTR_BUSS_PROCESSES
13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';
14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';
19:

Line 22: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';
19:
20: -- CSM_CONTR_BUSS_TXN_TYPES
21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';
22: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
26: g_pk3_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';

Line 23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');

19:
20: -- CSM_CONTR_BUSS_TXN_TYPES
21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';
22: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
26: g_pk3_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';

Line 34: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

30: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
31: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
32: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
33: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
34: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
35: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');
36:
37:
38: /* Function will get the Txn types and the related settings of it **

Line 35: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');

31: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
32: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
33: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
34: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
35: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');
36:
37:
38: /* Function will get the Txn types and the related settings of it **
39: ** - Up to amount **

Line 107: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3

103: -- Push record to the Resource (insert in ACC)
104: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
105: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_TXN_TYPES', FND_LOG.LEVEL_STATEMENT);
106:
107: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
108: ,P_ACC_TABLE_NAME => g_acc_table_name3
109: ,P_SEQ_NAME => g_sequence_name3
110: ,P_USER_ID => p_user_id
111: ,P_PK1_NAME => g_pk1_name3

Line 147: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name3

143: CLOSE l_access_id_csr;
144:
145: -- if counter > 1 then pass update to the Pub item as we are updating acc table
146: IF l_counter > 1 THEN
147: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name3
148: ,p_acc_table_name => g_acc_table_name3
149: ,p_user_id => p_user_id
150: ,p_access_id => l_access_id
151: );

Line 258: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

254: -- Push record to the Resource (insert in ACC)
255: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
256: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_BUSS_PROCESSES', FND_LOG.LEVEL_STATEMENT);
257:
258: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
259: ,P_ACC_TABLE_NAME => g_acc_table_name2
260: ,P_SEQ_NAME => g_sequence_name2
261: ,P_PK1_NAME => g_pk1_name2
262: ,P_PK1_CHAR_VALUE => p_contract_service_id

Line 291: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name2

287: CLOSE l_access_id_csr;
288:
289: -- if counter > 1 then pass update to the Pub item as we are updating acc table
290: IF l_counter > 1 THEN
291: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name2
292: ,p_acc_table_name => g_acc_table_name2
293: ,p_user_id => p_user_id
294: ,p_access_id => l_access_id
295: );

Line 384: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

380:
381: CSM_UTIL_PKG.LOG( 'Inserting ACC record for user_id = ' || p_user_id
382: , 'CSM_CONTRACT_EVENT_PKG.INSERT_CONTRACT_HEADER', FND_LOG.LEVEL_STATEMENT);
383:
384: CSM_ACC_PKG.Insert_Acc ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
385: ,P_ACC_TABLE_NAME => g_acc_table_name1
386: ,P_SEQ_NAME => g_sequence_name1
387: ,P_PK1_NAME => g_pk1_name1
388: ,P_PK1_NUM_VALUE => p_incident_id

Line 421: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name1

417: CLOSE l_access_id_csr;
418:
419: -- if counter > 1 then pass update to the Pub item as we are updating acc table
420: IF l_counter > 1 THEN
421: CSM_ACC_PKG.UPDATE_ACC (p_publication_item_names => g_publication_item_name1
422: ,p_acc_table_name => g_acc_table_name1
423: ,p_user_id => p_user_id
424: ,p_access_id => l_access_id
425: );

Line 499: CSM_ACC_PKG.Delete_Acc

495: ', business_process_id = ' || r_contr_buss_txn_types_rec.business_process_id ||
496: ', txn_billing_type_id = ' || r_contr_buss_txn_types_rec.txn_billing_type_id
497: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
498:
499: CSM_ACC_PKG.Delete_Acc
500: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
501: ,P_ACC_TABLE_NAME => g_acc_table_name3
502: ,P_PK1_NAME => g_pk1_name3
503: ,P_PK1_CHAR_VALUE => r_contr_buss_txn_types_rec.contract_service_id

Line 517: CSM_ACC_PKG.Delete_Acc

513: ', contract_service_id = ' || r_contr_buss_processes_rec.contract_service_id ||
514: ', business_process_id = ' || r_contr_buss_processes_rec.business_process_id
515: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
516:
517: CSM_ACC_PKG.Delete_Acc
518: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
519: ,P_ACC_TABLE_NAME => g_acc_table_name2
520: ,P_PK1_NAME => g_pk1_name2
521: ,P_PK1_CHAR_VALUE => r_contr_buss_processes_rec.contract_service_id

Line 533: CSM_ACC_PKG.Delete_Acc

529: CSM_UTIL_PKG.LOG( 'Deleting Contract Header ACC record for user_id = ' || p_user_id ||
530: ', incident_id = ' || p_incident_id
531: , 'CSM_CONTRACT_EVENT_PKG.DELETE_SR_CONTRACT_ACC', FND_LOG.LEVEL_STATEMENT);
532:
533: CSM_ACC_PKG.Delete_Acc
534: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
535: ,P_ACC_TABLE_NAME => g_acc_table_name1
536: ,P_PK1_NAME => g_pk1_name1
537: ,P_PK1_NUM_VALUE => r_contr_headers_rec.incident_id

Line 595: CSM_ACC_PKG.Delete_Acc

591: --delete for the user
592: for l_oks_notes_rec in l_oks_notes_csr(l_sourceobjectcode,
593: l_sourceobjectid,
594: l_user_id) loop
595: CSM_ACC_PKG.Delete_Acc
596: ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
597: ,P_ACC_TABLE_NAME => g_notes_acc_table_name
598: ,P_PK1_NAME => g_notes_pk1_name
599: ,P_PK1_NUM_VALUE => l_oks_notes_rec.jtf_note_id

Line 645: CSM_ACC_PKG.Insert_Acc

641: --delete for the user
642: for l_oks_notes_rec in l_oks_notes_csr(l_sourceobjectcode,
643: l_sourceobjectid) loop
644:
645: CSM_ACC_PKG.Insert_Acc
646: ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
647: ,P_ACC_TABLE_NAME => g_notes_acc_table_name
648: ,P_SEQ_NAME => g_notes_seq_name
649: ,P_PK1_NAME => g_notes_pk1_name