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.FV_SLA_PO_PROCESSING_PKG dependencies on PO_BC_DISTRIBUTIONS

Line 127: p_bc_dist_rec IN po_bc_distributions%ROWTYPE,

123:
124: PROCEDURE get_unreserv_data
125: (
126: p_application_id IN NUMBER,
127: p_bc_dist_rec IN po_bc_distributions%ROWTYPE,
128: p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,
129: p_index IN OUT NOCOPY NUMBER,
130: p_error_code OUT NOCOPY NUMBER,
131: p_error_desc OUT NOCOPY VARCHAR2

Line 143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;

139: l_fund_time_frame fv_fund_parameters.fund_time_frame%TYPE;
140: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
141: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
142: l_fund_expired_status VARCHAR2(30);
143: l_unreserv_dist_rec po_bc_distributions%ROWTYPE;
144: l_unreserv_data_exists BOOLEAN := FALSE;
145: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
146: l_sign NUMBER;
147:

Line 161: FROM po_bc_distributions

157: /* Try to get the old unreserve information for the distribution*/
158: BEGIN
159: SELECT *
160: INTO l_unreserv_dist_rec
161: FROM po_bc_distributions
162: WHERE header_id = p_bc_dist_rec.header_id
163: AND distribution_id = p_bc_dist_rec.distribution_id
164: AND ae_event_id = (SELECT max(ae_event_id)
165: FROM po_bc_distributions pbd

Line 165: FROM po_bc_distributions pbd

161: FROM po_bc_distributions
162: WHERE header_id = p_bc_dist_rec.header_id
163: AND distribution_id = p_bc_dist_rec.distribution_id
164: AND ae_event_id = (SELECT max(ae_event_id)
165: FROM po_bc_distributions pbd
166: WHERE pbd.header_id = p_bc_dist_rec.header_id
167: AND pbd.distribution_id = p_bc_dist_rec.distribution_id
168: AND pbd.ae_event_id <> p_bc_dist_rec.ae_event_id
169: AND pbd.distribution_type NOT IN ('REQUISITION', 'AGREEMENT', 'PLANNED')

Line 184: stack_error (l_procedure_name, 'SELECT_po_bc_distributions', p_error_desc);

180: l_unreserv_data_exists := FALSE;
181: WHEN OTHERS THEN
182: p_error_code := c_FAILURE;
183: p_error_desc := SQLERRM;
184: stack_error (l_procedure_name, 'SELECT_po_bc_distributions', p_error_desc);
185: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_bc_distributions:'||p_error_desc);
186: END;
187:
188:

Line 185: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_bc_distributions:'||p_error_desc);

181: WHEN OTHERS THEN
182: p_error_code := c_FAILURE;
183: p_error_desc := SQLERRM;
184: stack_error (l_procedure_name, 'SELECT_po_bc_distributions', p_error_desc);
185: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_bc_distributions:'||p_error_desc);
186: END;
187:
188:
189: IF (p_error_code = C_SUCCESS) THEN

Line 197: -- Get the sign of transaction since po_bc_distributions

193: trace(C_STATE_LEVEL, l_procedure_name, 'event_type_code='||l_unreserv_dist_rec.event_type_code);
194: IF (l_unreserv_data_exists AND (l_unreserv_dist_rec.event_type_code IN ('PO_PA_UNRESERVED', 'RELEASE_UNRESERVED'))) THEN
195: IF (l_unreserv_dist_rec.code_combination_id <> p_bc_dist_rec.code_combination_id) THEN
196: IF (p_error_code = C_SUCCESS) THEN
197: -- Get the sign of transaction since po_bc_distributions
198: -- amount sign is not consistant.
199: trace(C_PROC_LEVEL, l_procedure_name, 'Calling po_encumbrance_postprocessing.get_sign_for_amount');
200: BEGIN
201: l_sign := po_encumbrance_postprocessing.get_sign_for_amount

Line 331: po_bc_distributions pbd

327: fed.ent_anticipated_budget_amount,
328: fed.acc_anticipated_budget_amount,
329: fed.rowid fed_rowid
330: FROM fv_extract_detail_gt fed,
331: po_bc_distributions pbd
332: WHERE fed.event_id = pbd.ae_event_id
333: AND fed.line_number = pbd.line_number
334: AND pbd.main_or_backing_code = 'M') LOOP
335: trace(C_STATE_LEVEL, l_procedure_name, 'gt_rec.event_id='||gt_rec.event_id);

Line 358: po_bc_distributions pbd

354: l_tot_acc_unanticipated_amt,
355: l_tot_ent_anticipated_amt,
356: l_tot_acc_anticipated_amt
357: FROM fv_extract_detail_gt fed,
358: po_bc_distributions pbd
359: WHERE fed.event_id = pbd.ae_event_id
360: AND fed.event_id = gt_rec.event_id
361: AND fed.line_number = pbd.line_number
362: AND NVL(fed.old_ccid, pbd.code_combination_id) = gt_rec.code_combination_id

Line 385: FROM po_bc_distributions pbd

381: ent_anticipated_budget_amount = 0,
382: acc_anticipated_budget_amount = 0
383: WHERE fed.event_id = gt_rec.event_id
384: AND EXISTS (SELECT 1
385: FROM po_bc_distributions pbd
386: WHERE fed.event_id = pbd.ae_event_id
387: AND fed.line_number = pbd.line_number
388: AND fed.event_id = gt_rec.event_id
389: AND NVL(fed.old_ccid, pbd.code_combination_id) = gt_rec.code_combination_id

Line 421: FROM po_bc_distributions pbd,

417: l_procedure_name VARCHAR2(100):='.PO_PROCESS';
418:
419: CURSOR c_po_extract_detail IS
420: SELECT pbd.*
421: FROM po_bc_distributions pbd,
422: xla_events_gt e
423: where pbd.ae_event_id = e.event_id
424: ORDER BY pbd.ae_event_id,
425: pbd.header_id,

Line 436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;

432: l_index NUMBER;
433: l_conversion_rate NUMBER;
434: l_sign NUMBER;
435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;

Line 437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;

433: l_conversion_rate NUMBER;
434: l_sign NUMBER;
435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
441: l_pya_data_exists BOOLEAN := FALSE;

Line 438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;

434: l_sign NUMBER;
435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
441: l_pya_data_exists BOOLEAN := FALSE;
442:

Line 439: l_old_event_type po_bc_distributions.event_type_code%TYPE;

435: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
436: l_old_ccid po_bc_distributions.code_combination_id%TYPE;
437: l_ent_old_trx_amt po_bc_distributions.entered_amt%TYPE;
438: l_acc_old_trx_amt po_bc_distributions.accounted_amt%TYPE;
439: l_old_event_type po_bc_distributions.event_type_code%TYPE;
440: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
441: l_pya_data_exists BOOLEAN := FALSE;
442:
443: BEGIN

Line 481: -- Get the sign of transaction since po_bc_distributions

477: l_conversion_rate := l_po_extract_detail.accounted_amt/l_po_extract_detail.entered_amt;
478: END IF;
479:
480: IF (p_error_code = C_SUCCESS) THEN
481: -- Get the sign of transaction since po_bc_distributions
482: -- amount sign is not consistant.
483: trace(C_PROC_LEVEL, l_procedure_name, 'Calling po_encumbrance_postprocessing.get_sign_for_amount');
484: BEGIN
485: l_sign := po_encumbrance_postprocessing.get_sign_for_amount