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.CE_STATEMENT_RECONS_PKG dependencies on CE_STATEMENT_RECON_GT_V

Line 32: FROM CE_STATEMENT_RECON_GT_V csr --CE_STATEMENT_RECONCILIATIONS csr

28: X_current_record_flag VARCHAR2,
29: X_row_id VARCHAR2) IS
30: CURSOR chk_duplicates is
31: SELECT 'Duplicate'
32: FROM CE_STATEMENT_RECON_GT_V csr --CE_STATEMENT_RECONCILIATIONS csr
33: WHERE csr.statement_line_id = X_statement_line_id
34: AND csr.reference_type = X_reference_type
35: AND csr.reference_id = X_reference_id
36: AND csr.current_record_flag = X_current_record_flag

Line 89: CURSOR C_ROWID IS SELECT row_id FROM CE_STATEMENT_RECON_GT_V

85: Y_org_id NUMBER(15);
86: X_legal_entity_id_tmp NUMBER(15);
87: Y_legal_entity_id NUMBER(15);
88:
89: CURSOR C_ROWID IS SELECT row_id FROM CE_STATEMENT_RECON_GT_V
90: WHERE statement_line_id = X_Statement_Line_Id
91: AND reference_type = reference_type_tmp
92: AND reference_id = X_Reference_Id
93: AND current_record_flag = x_current_record_flag;

Line 96: FROM CE_STATEMENT_RECON_GT_V

92: AND reference_id = X_Reference_Id
93: AND current_record_flag = x_current_record_flag;
94:
95: CURSOR C_STMT_LOCK IS SELECT row_id, org_id, legal_entity_id
96: FROM CE_STATEMENT_RECON_GT_V
97: WHERE reference_type = reference_type_tmp AND
98: reference_id = X_reference_id AND
99: statement_line_id = X_statement_line_id AND
100: current_record_flag = 'Y'

Line 104: FROM CE_STATEMENT_RECON_GT_V

100: current_record_flag = 'Y'
101: FOR UPDATE of current_record_flag NOWAIT;
102:
103: CURSOR C_LOCK IS SELECT row_id, org_id, legal_entity_id
104: FROM CE_STATEMENT_RECON_GT_V
105: WHERE reference_type = reference_type_tmp AND
106: reference_id = X_reference_id AND
107: current_record_flag = 'Y'
108: FOR UPDATE of current_record_flag NOWAIT;

Line 185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');

181: END IF;
182: END IF;
183:
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');
186: END IF;
187:
188: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
189: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

Line 251: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECON_GT_V');

247: X_program_update_date,
248: NULL));
249:
250: IF l_DEBUG in ('Y', 'C') THEN
251: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECON_GT_V');
252: END IF;
253:
254:
255:

Line 317: CURSOR C_ROWID IS SELECT row_id FROM CE_STATEMENT_RECON_GT_V

313: X_org_id_tmp NUMBER(15);
314: Y_org_id NUMBER(15);
315: X_legal_entity_id_tmp NUMBER(15);
316: Y_legal_entity_id NUMBER(15);
317: CURSOR C_ROWID IS SELECT row_id FROM CE_STATEMENT_RECON_GT_V
318: WHERE statement_line_id = X_Statement_Line_Id
319: AND reference_type = reference_type_tmp
320: AND reference_id = X_Reference_Id
321: AND je_header_id = X_je_header_id

Line 325: FROM CE_STATEMENT_RECON_GT_V

321: AND je_header_id = X_je_header_id
322: AND current_record_flag = x_current_record_flag;
323:
324: CURSOR C_LOCK IS SELECT row_id, org_id, legal_entity_id
325: FROM CE_STATEMENT_RECON_GT_V
326: WHERE reference_type = reference_type_tmp AND
327: reference_id = X_reference_id AND
328: je_header_id = X_je_header_id AND
329: -- statement_line_id = X_Statement_Line_Id AND bug 6888494

Line 493: FROM CE_STATEMENT_RECON_GT_V

489: reference_id,
490: status_flag,
491: current_record_flag,
492: auto_reconciled_flag
493: FROM CE_STATEMENT_RECON_GT_V
494: WHERE statement_line_id = X_statement_line_id AND
495: reference_type = X_reference_type AND
496: reference_id = X_reference_id
497: FOR UPDATE of Statement_Line_Id,reference_type, reference_id NOWAIT;