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.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_TBL_NUMBER

Line 269: , p_sequence_num_tbl IN po_tbl_number

265: PROCEDURE insert_report_autonomous(
266: p_reporting_level IN VARCHAR2
267: , p_message_text IN VARCHAR2
268: , p_user_id IN NUMBER
269: , p_sequence_num_tbl IN po_tbl_number
270: , p_line_num_tbl IN po_tbl_number
271: , p_shipment_num_tbl IN po_tbl_number
272: , p_distribution_num_tbl IN po_tbl_number
273: , p_distribution_id_tbl IN po_tbl_number

Line 270: , p_line_num_tbl IN po_tbl_number

266: p_reporting_level IN VARCHAR2
267: , p_message_text IN VARCHAR2
268: , p_user_id IN NUMBER
269: , p_sequence_num_tbl IN po_tbl_number
270: , p_line_num_tbl IN po_tbl_number
271: , p_shipment_num_tbl IN po_tbl_number
272: , p_distribution_num_tbl IN po_tbl_number
273: , p_distribution_id_tbl IN po_tbl_number
274: , p_result_code_tbl IN po_tbl_varchar5

Line 271: , p_shipment_num_tbl IN po_tbl_number

267: , p_message_text IN VARCHAR2
268: , p_user_id IN NUMBER
269: , p_sequence_num_tbl IN po_tbl_number
270: , p_line_num_tbl IN po_tbl_number
271: , p_shipment_num_tbl IN po_tbl_number
272: , p_distribution_num_tbl IN po_tbl_number
273: , p_distribution_id_tbl IN po_tbl_number
274: , p_result_code_tbl IN po_tbl_varchar5
275: , p_message_type_tbl IN po_tbl_varchar1

Line 272: , p_distribution_num_tbl IN po_tbl_number

268: , p_user_id IN NUMBER
269: , p_sequence_num_tbl IN po_tbl_number
270: , p_line_num_tbl IN po_tbl_number
271: , p_shipment_num_tbl IN po_tbl_number
272: , p_distribution_num_tbl IN po_tbl_number
273: , p_distribution_id_tbl IN po_tbl_number
274: , p_result_code_tbl IN po_tbl_varchar5
275: , p_message_type_tbl IN po_tbl_varchar1
276: , p_text_line_tbl IN po_tbl_varchar2000

Line 273: , p_distribution_id_tbl IN po_tbl_number

269: , p_sequence_num_tbl IN po_tbl_number
270: , p_line_num_tbl IN po_tbl_number
271: , p_shipment_num_tbl IN po_tbl_number
272: , p_distribution_num_tbl IN po_tbl_number
273: , p_distribution_id_tbl IN po_tbl_number
274: , p_result_code_tbl IN po_tbl_varchar5
275: , p_message_type_tbl IN po_tbl_varchar1
276: , p_text_line_tbl IN po_tbl_varchar2000
277: , p_show_in_psa_flag IN po_tbl_varchar1 --

Line 495: l_seq_num_tbl po_tbl_number ;

491: l_transaction_number NUMBER;
492: l_entity_id NUMBER;
493: l_event_id NUMBER;
494: l_current_org_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE;
495: l_seq_num_tbl po_tbl_number ;
496: l_num_of_rows_deleted NUMBER;
497: l_num_of_rows_inserted NUMBER;
498:
499: l_id_tbl po_tbl_number;

Line 499: l_id_tbl po_tbl_number;

495: l_seq_num_tbl po_tbl_number ;
496: l_num_of_rows_deleted NUMBER;
497: l_num_of_rows_inserted NUMBER;
498:
499: l_id_tbl po_tbl_number;
500:
501: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;
502: l_events_Tab Event_tab_type;
503: l_event_count NUMBER;

Line 1421: l_encumbered_amount_change po_tbl_number; -- Bug 4878973

1417: l_update_enc_amt_flag_tbl update_enc_amt_flag_tbl_type;
1418: l_dist_id_tbl dist_id_tbl_type;
1419: l_dist_type_tbl po_tbl_varchar30;
1420: -- bug3543542 END
1421: l_encumbered_amount_change po_tbl_number; -- Bug 4878973
1422: l_reference15_tbl reference15_tbl_type;--bug#5201733
1423: BEGIN
1424:
1425: IF g_debug_stmt THEN

Line 2992: , p_doc_id_tbl IN po_tbl_number

2988: --End of Comments
2989: -------------------------------------------------------------------------------
2990: PROCEDURE create_enc_action_history(
2991: p_doc_type IN VARCHAR2
2992: , p_doc_id_tbl IN po_tbl_number
2993: , p_employee_id IN NUMBER
2994: , p_action IN VARCHAR2
2995: , p_cbc_flag IN VARCHAR2
2996: )

Line 3009: l_orig_doc_id_tbl po_tbl_number;

3005: l_gt_key NUMBER;
3006: l_debug_rowid_tbl po_tbl_varchar2000;
3007: l_debug_column_tbl po_tbl_varchar30;
3008:
3009: l_orig_doc_id_tbl po_tbl_number;
3010: l_orig_rev_num_tbl po_tbl_number;
3011: l_orig_auth_status_tbl po_tbl_varchar30;
3012: l_orig_doc_subtype_tbl po_tbl_varchar30;
3013: l_orig_null_flag_tbl po_tbl_varchar1;

Line 3010: l_orig_rev_num_tbl po_tbl_number;

3006: l_debug_rowid_tbl po_tbl_varchar2000;
3007: l_debug_column_tbl po_tbl_varchar30;
3008:
3009: l_orig_doc_id_tbl po_tbl_number;
3010: l_orig_rev_num_tbl po_tbl_number;
3011: l_orig_auth_status_tbl po_tbl_varchar30;
3012: l_orig_doc_subtype_tbl po_tbl_varchar30;
3013: l_orig_null_flag_tbl po_tbl_varchar1;
3014:

Line 3016: l_update_doc_id_tbl po_tbl_number;

3012: l_orig_doc_subtype_tbl po_tbl_varchar30;
3013: l_orig_null_flag_tbl po_tbl_varchar1;
3014:
3015: l_update_doc_type_tbl po_tbl_varchar30;
3016: l_update_doc_id_tbl po_tbl_number;
3017:
3018: l_insert_doc_type_tbl po_tbl_varchar30;
3019: l_insert_doc_id_tbl po_tbl_number;
3020: l_insert_doc_subtype_tbl po_tbl_varchar30;

Line 3019: l_insert_doc_id_tbl po_tbl_number;

3015: l_update_doc_type_tbl po_tbl_varchar30;
3016: l_update_doc_id_tbl po_tbl_number;
3017:
3018: l_insert_doc_type_tbl po_tbl_varchar30;
3019: l_insert_doc_id_tbl po_tbl_number;
3020: l_insert_doc_subtype_tbl po_tbl_varchar30;
3021: l_insert_action_code_tbl po_tbl_varchar30;
3022: l_insert_rev_num_tbl po_tbl_number;
3023:

Line 3022: l_insert_rev_num_tbl po_tbl_number;

3018: l_insert_doc_type_tbl po_tbl_varchar30;
3019: l_insert_doc_id_tbl po_tbl_number;
3020: l_insert_doc_subtype_tbl po_tbl_varchar30;
3021: l_insert_action_code_tbl po_tbl_varchar30;
3022: l_insert_rev_num_tbl po_tbl_number;
3023:
3024: l_doc_id NUMBER;
3025: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
3026: l_rev_num NUMBER;

Line 3227: l_update_doc_id_tbl := po_tbl_number();

3223: l_progress := '210';
3224:
3225: -- Initialize the update / insert tables.
3226:
3227: l_update_doc_id_tbl := po_tbl_number();
3228:
3229: l_insert_doc_id_tbl := po_tbl_number();
3230: l_insert_doc_subtype_tbl := po_tbl_varchar30();
3231: l_insert_action_code_tbl := po_tbl_varchar30();

Line 3229: l_insert_doc_id_tbl := po_tbl_number();

3225: -- Initialize the update / insert tables.
3226:
3227: l_update_doc_id_tbl := po_tbl_number();
3228:
3229: l_insert_doc_id_tbl := po_tbl_number();
3230: l_insert_doc_subtype_tbl := po_tbl_varchar30();
3231: l_insert_action_code_tbl := po_tbl_varchar30();
3232: l_insert_rev_num_tbl := po_tbl_number();
3233:

Line 3232: l_insert_rev_num_tbl := po_tbl_number();

3228:
3229: l_insert_doc_id_tbl := po_tbl_number();
3230: l_insert_doc_subtype_tbl := po_tbl_varchar30();
3231: l_insert_action_code_tbl := po_tbl_varchar30();
3232: l_insert_rev_num_tbl := po_tbl_number();
3233:
3234: l_progress := '220';
3235:
3236: -- Determine which updates and inserts need to occur.

Line 3728: l_sequence_num_tbl PO_TBL_NUMBER;

3724: l_shipment_token FND_NEW_MESSAGES.message_text%TYPE;
3725: l_distribution_token FND_NEW_MESSAGES.message_text%TYPE;
3726: l_warning_rows_flag VARCHAR2(1) := 'N';
3727:
3728: l_sequence_num_tbl PO_TBL_NUMBER;
3729: l_line_num_tbl PO_TBL_NUMBER;
3730: l_shipment_num_tbl PO_TBL_NUMBER;
3731: l_distribution_num_tbl PO_TBL_NUMBER;
3732: l_distribution_id_tbl PO_TBL_NUMBER;

Line 3729: l_line_num_tbl PO_TBL_NUMBER;

3725: l_distribution_token FND_NEW_MESSAGES.message_text%TYPE;
3726: l_warning_rows_flag VARCHAR2(1) := 'N';
3727:
3728: l_sequence_num_tbl PO_TBL_NUMBER;
3729: l_line_num_tbl PO_TBL_NUMBER;
3730: l_shipment_num_tbl PO_TBL_NUMBER;
3731: l_distribution_num_tbl PO_TBL_NUMBER;
3732: l_distribution_id_tbl PO_TBL_NUMBER;
3733: l_result_code_tbl PO_TBL_VARCHAR5;

Line 3730: l_shipment_num_tbl PO_TBL_NUMBER;

3726: l_warning_rows_flag VARCHAR2(1) := 'N';
3727:
3728: l_sequence_num_tbl PO_TBL_NUMBER;
3729: l_line_num_tbl PO_TBL_NUMBER;
3730: l_shipment_num_tbl PO_TBL_NUMBER;
3731: l_distribution_num_tbl PO_TBL_NUMBER;
3732: l_distribution_id_tbl PO_TBL_NUMBER;
3733: l_result_code_tbl PO_TBL_VARCHAR5;
3734: l_message_type_tbl PO_TBL_VARCHAR1;

Line 3731: l_distribution_num_tbl PO_TBL_NUMBER;

3727:
3728: l_sequence_num_tbl PO_TBL_NUMBER;
3729: l_line_num_tbl PO_TBL_NUMBER;
3730: l_shipment_num_tbl PO_TBL_NUMBER;
3731: l_distribution_num_tbl PO_TBL_NUMBER;
3732: l_distribution_id_tbl PO_TBL_NUMBER;
3733: l_result_code_tbl PO_TBL_VARCHAR5;
3734: l_message_type_tbl PO_TBL_VARCHAR1;
3735: l_text_line_tbl PO_TBL_VARCHAR2000;

Line 3732: l_distribution_id_tbl PO_TBL_NUMBER;

3728: l_sequence_num_tbl PO_TBL_NUMBER;
3729: l_line_num_tbl PO_TBL_NUMBER;
3730: l_shipment_num_tbl PO_TBL_NUMBER;
3731: l_distribution_num_tbl PO_TBL_NUMBER;
3732: l_distribution_id_tbl PO_TBL_NUMBER;
3733: l_result_code_tbl PO_TBL_VARCHAR5;
3734: l_message_type_tbl PO_TBL_VARCHAR1;
3735: l_text_line_tbl PO_TBL_VARCHAR2000;
3736: l_show_in_psa_tbl PO_TBL_VARCHAR1; --

Line 4113: , p_sequence_num_tbl IN po_tbl_number

4109: PROCEDURE insert_report_autonomous(
4110: p_reporting_level IN VARCHAR2
4111: , p_message_text IN VARCHAR2
4112: , p_user_id IN NUMBER
4113: , p_sequence_num_tbl IN po_tbl_number
4114: , p_line_num_tbl IN po_tbl_number
4115: , p_shipment_num_tbl IN po_tbl_number
4116: , p_distribution_num_tbl IN po_tbl_number
4117: , p_distribution_id_tbl IN po_tbl_number

Line 4114: , p_line_num_tbl IN po_tbl_number

4110: p_reporting_level IN VARCHAR2
4111: , p_message_text IN VARCHAR2
4112: , p_user_id IN NUMBER
4113: , p_sequence_num_tbl IN po_tbl_number
4114: , p_line_num_tbl IN po_tbl_number
4115: , p_shipment_num_tbl IN po_tbl_number
4116: , p_distribution_num_tbl IN po_tbl_number
4117: , p_distribution_id_tbl IN po_tbl_number
4118: , p_result_code_tbl IN po_tbl_varchar5

Line 4115: , p_shipment_num_tbl IN po_tbl_number

4111: , p_message_text IN VARCHAR2
4112: , p_user_id IN NUMBER
4113: , p_sequence_num_tbl IN po_tbl_number
4114: , p_line_num_tbl IN po_tbl_number
4115: , p_shipment_num_tbl IN po_tbl_number
4116: , p_distribution_num_tbl IN po_tbl_number
4117: , p_distribution_id_tbl IN po_tbl_number
4118: , p_result_code_tbl IN po_tbl_varchar5
4119: , p_message_type_tbl IN po_tbl_varchar1

Line 4116: , p_distribution_num_tbl IN po_tbl_number

4112: , p_user_id IN NUMBER
4113: , p_sequence_num_tbl IN po_tbl_number
4114: , p_line_num_tbl IN po_tbl_number
4115: , p_shipment_num_tbl IN po_tbl_number
4116: , p_distribution_num_tbl IN po_tbl_number
4117: , p_distribution_id_tbl IN po_tbl_number
4118: , p_result_code_tbl IN po_tbl_varchar5
4119: , p_message_type_tbl IN po_tbl_varchar1
4120: , p_text_line_tbl IN po_tbl_varchar2000

Line 4117: , p_distribution_id_tbl IN po_tbl_number

4113: , p_sequence_num_tbl IN po_tbl_number
4114: , p_line_num_tbl IN po_tbl_number
4115: , p_shipment_num_tbl IN po_tbl_number
4116: , p_distribution_num_tbl IN po_tbl_number
4117: , p_distribution_id_tbl IN po_tbl_number
4118: , p_result_code_tbl IN po_tbl_varchar5
4119: , p_message_type_tbl IN po_tbl_varchar1
4120: , p_text_line_tbl IN po_tbl_varchar2000
4121: , p_show_in_psa_flag IN po_tbl_varchar1 --