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 FV_SLA_UTL_PROCESSING_PKG

Line 83: fv_sla_utl_processing_pkg.trace

79: )
80: IS
81:
82: BEGIN
83: fv_sla_utl_processing_pkg.trace
84: (
85: p_level => p_level,
86: p_procedure_name => p_procedure_name,
87: p_debug_info => p_debug_info

Line 116: fv_sla_utl_processing_pkg.stack_error

112: p_error_message IN VARCHAR2
113: )
114: IS
115: BEGIN
116: fv_sla_utl_processing_pkg.stack_error
117: (
118: p_program_name => p_program_name,
119: p_location => p_location,
120: p_error_message => p_error_message

Line 128: p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,

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
132: )

Line 219: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_segment_values');

215: trace(C_PROC_LEVEL, l_procedure_name, 'l_sign='||l_sign);
216: END IF;
217:
218: IF (p_error_code = C_SUCCESS) THEN
219: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_segment_values');
220: l_fund_value := NULL;
221: fv_sla_utl_processing_pkg.get_segment_values
222: (
223: p_ledger_id => p_bc_dist_rec.ledger_id,

Line 221: fv_sla_utl_processing_pkg.get_segment_values

217:
218: IF (p_error_code = C_SUCCESS) THEN
219: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_segment_values');
220: l_fund_value := NULL;
221: fv_sla_utl_processing_pkg.get_segment_values
222: (
223: p_ledger_id => p_bc_dist_rec.ledger_id,
224: p_ccid => l_unreserv_dist_rec.code_combination_id,
225: p_fund_value => l_fund_value,

Line 235: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_fund_details');

231: trace(C_STATE_LEVEL, l_procedure_name, 'l_fund_value='||l_fund_value);
232: END IF;
233:
234: IF (p_error_code = C_SUCCESS) THEN
235: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_fund_details');
236: l_treasury_symbol_id := NULL;
237: fv_sla_utl_processing_pkg.get_fund_details
238: (
239: p_application_id => p_application_id,

Line 237: fv_sla_utl_processing_pkg.get_fund_details

233:
234: IF (p_error_code = C_SUCCESS) THEN
235: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.get_fund_details');
236: l_treasury_symbol_id := NULL;
237: fv_sla_utl_processing_pkg.get_fund_details
238: (
239: p_application_id => p_application_id,
240: p_ledger_id => p_bc_dist_rec.ledger_id,
241: p_fund_value => l_fund_value,

Line 410: p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,

406:
407: PROCEDURE po_process
408: (
409: p_application_id IN NUMBER,
410: p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,
411: p_error_code OUT NOCOPY NUMBER,
412: p_error_desc OUT NOCOPY VARCHAR2
413: )
414: IS

Line 429: l_ledger_info fv_sla_utl_processing_pkg.LedgerRecType;

425: pbd.header_id,
426: pbd.distribution_id;
427:
428: l_pya_type VARCHAR2(100);
429: l_ledger_info fv_sla_utl_processing_pkg.LedgerRecType;
430: l_account_value VARCHAR2(30);
431: l_bfy_value VARCHAR2(30);
432: l_index NUMBER;
433: l_conversion_rate NUMBER;

Line 470: fv_sla_utl_processing_pkg.init_extract_record (p_application_id, p_fv_extract_detail(l_index));

466:
467: -- Initialize the Record
468: l_index := l_index + 1;
469: p_fv_extract_detail(l_index).event_id :=l_po_extract_detail.ae_event_id;
470: fv_sla_utl_processing_pkg.init_extract_record (p_application_id, p_fv_extract_detail(l_index));
471: p_fv_extract_detail(l_index).line_number :=l_po_extract_detail.line_number;
472:
473: -- Set Conversion Rate
474: IF (l_po_extract_detail.entered_amt = 0) THEN

Line 507: fv_sla_utl_processing_pkg.get_ledger_info

503: --
504: -- Get the Ledger Information
505: --
506: trace(C_PROC_LEVEL, l_procedure_name, 'Calling get_ledger_info');
507: fv_sla_utl_processing_pkg.get_ledger_info
508: (
509: p_ledger_id => l_po_extract_detail.ledger_id,
510: p_ledger_rec => l_ledger_info,
511: p_error_code => p_error_code,

Line 526: fv_sla_utl_processing_pkg.get_segment_values

522: trace(C_PROC_LEVEL, l_procedure_name, 'p_ccid=' ||l_po_extract_detail.code_combination_id);
523: --
524: -- Get Accouting, fund and BFY Segment Values
525: --
526: fv_sla_utl_processing_pkg.get_segment_values
527: (
528: p_ledger_id => l_ledger_info.ledger_id,
529: p_ccid => l_po_extract_detail.code_combination_id,
530: p_fund_value => p_fv_extract_detail(l_index).fund_value,

Line 549: fv_sla_utl_processing_pkg.get_fund_details

545: trace(C_PROC_LEVEL, l_procedure_name, 'Calling get_fund_details');
546: --
547: -- Get Fund Details
548: --
549: fv_sla_utl_processing_pkg.get_fund_details
550: (
551: p_application_id => p_application_id,
552: p_ledger_id => l_ledger_info.ledger_id,
553: p_fund_value => p_fv_extract_detail(l_index).fund_value,

Line 587: fv_sla_utl_processing_pkg.get_prior_year_status

583: trace(C_PROC_LEVEL, l_procedure_name, 'p_gl_date=' ||l_po_extract_detail.gl_date);
584: --
585: -- Is the Transcation PYA?
586: --
587: fv_sla_utl_processing_pkg.get_prior_year_status
588: (
589: p_application_id => p_application_id,
590: p_ledger_id => l_ledger_info.ledger_id,
591: p_bfy_value => l_bfy_value,

Line 707: fv_sla_utl_processing_pkg.pya_processor

703: -- PYA Processing
704: --
705: IF (p_error_code = C_SUCCESS) THEN
706: IF (l_pya_data_exists) THEN
707: fv_sla_utl_processing_pkg.pya_processor
708: (
709: p_application_id => p_application_id,
710: p_error_code => p_error_code,
711: p_error_desc => p_error_desc

Line 734: l_fv_extract_detail fv_sla_utl_processing_pkg.fv_ref_detail;

730: p_accounting_mode IN VARCHAR2
731: )
732: IS
733: l_procedure_name VARCHAR2(100):='.PO_EXTRACT';
734: l_fv_extract_detail fv_sla_utl_processing_pkg.fv_ref_detail;
735: l_error_code NUMBER;
736: l_gt_error_code NUMBER;
737: l_error_desc VARCHAR2(1024);
738: l_po_code VARCHAR2(1);

Line 760: fv_sla_utl_processing_pkg.check_errors

756: p_error_desc => l_error_desc
757: );
758:
759: IF (l_error_code = C_SUCCESS) THEN
760: fv_sla_utl_processing_pkg.check_errors
761: (
762: p_application_id => p_application_id,
763: p_error_code => l_error_code,
764: p_error_desc => l_error_desc

Line 769: fv_sla_utl_processing_pkg.dump_gt_table

765: );
766: END IF;
767:
768: trace(C_STATE_LEVEL, l_procedure_name, 'Calling dump_gt_table');
769: fv_sla_utl_processing_pkg.dump_gt_table
770: (
771: p_error_code => l_gt_error_code,
772: p_error_desc => l_error_desc
773: );