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 265: , p_sequence_num_tbl IN po_tbl_number

261: PROCEDURE insert_report_autonomous(
262: p_reporting_level IN VARCHAR2
263: , p_message_text IN VARCHAR2
264: , p_user_id IN NUMBER
265: , p_sequence_num_tbl IN po_tbl_number
266: , p_line_num_tbl IN po_tbl_number
267: , p_shipment_num_tbl IN po_tbl_number
268: , p_distribution_num_tbl IN po_tbl_number
269: , p_distribution_id_tbl IN po_tbl_number

Line 266: , p_line_num_tbl IN po_tbl_number

262: p_reporting_level IN VARCHAR2
263: , p_message_text IN VARCHAR2
264: , p_user_id IN NUMBER
265: , p_sequence_num_tbl IN po_tbl_number
266: , p_line_num_tbl IN po_tbl_number
267: , p_shipment_num_tbl IN po_tbl_number
268: , p_distribution_num_tbl IN po_tbl_number
269: , p_distribution_id_tbl IN po_tbl_number
270: , p_result_code_tbl IN po_tbl_varchar5

Line 267: , p_shipment_num_tbl IN po_tbl_number

263: , p_message_text IN VARCHAR2
264: , p_user_id IN NUMBER
265: , p_sequence_num_tbl IN po_tbl_number
266: , p_line_num_tbl IN po_tbl_number
267: , p_shipment_num_tbl IN po_tbl_number
268: , p_distribution_num_tbl IN po_tbl_number
269: , p_distribution_id_tbl IN po_tbl_number
270: , p_result_code_tbl IN po_tbl_varchar5
271: , p_message_type_tbl IN po_tbl_varchar1

Line 268: , p_distribution_num_tbl IN po_tbl_number

264: , p_user_id IN NUMBER
265: , p_sequence_num_tbl IN po_tbl_number
266: , p_line_num_tbl IN po_tbl_number
267: , p_shipment_num_tbl IN po_tbl_number
268: , p_distribution_num_tbl IN po_tbl_number
269: , p_distribution_id_tbl IN po_tbl_number
270: , p_result_code_tbl IN po_tbl_varchar5
271: , p_message_type_tbl IN po_tbl_varchar1
272: , p_text_line_tbl IN po_tbl_varchar2000

Line 269: , p_distribution_id_tbl IN po_tbl_number

265: , p_sequence_num_tbl IN po_tbl_number
266: , p_line_num_tbl IN po_tbl_number
267: , p_shipment_num_tbl IN po_tbl_number
268: , p_distribution_num_tbl IN po_tbl_number
269: , p_distribution_id_tbl IN po_tbl_number
270: , p_result_code_tbl IN po_tbl_varchar5
271: , p_message_type_tbl IN po_tbl_varchar1
272: , p_text_line_tbl IN po_tbl_varchar2000
273: , p_show_in_psa_flag IN po_tbl_varchar1 --

Line 522: l_seq_num_tbl po_tbl_number ;

518: l_transaction_number NUMBER;
519: l_entity_id NUMBER;
520: l_event_id NUMBER;
521: l_current_org_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE;
522: l_seq_num_tbl po_tbl_number ;
523: l_first_dist_set_flag VARCHAR2(1) := 'Y' ;
524: -- Bug 4962155 Begin
525: l_old_event_id NUMBER;
526: l_array_event_info xla_events_pub_pkg.t_array_event_info ;

Line 1343: l_encumbered_amount_change po_tbl_number; -- Bug 4878973

1339: l_update_enc_amt_flag_tbl update_enc_amt_flag_tbl_type;
1340: l_dist_id_tbl dist_id_tbl_type;
1341: l_dist_type_tbl po_tbl_varchar30;
1342: -- bug3543542 END
1343: l_encumbered_amount_change po_tbl_number; -- Bug 4878973
1344: l_reference15_tbl reference15_tbl_type;--bug#5201733
1345: BEGIN
1346:
1347: IF g_debug_stmt THEN

Line 2663: , p_doc_id_tbl IN po_tbl_number

2659: --End of Comments
2660: -------------------------------------------------------------------------------
2661: PROCEDURE create_enc_action_history(
2662: p_doc_type IN VARCHAR2
2663: , p_doc_id_tbl IN po_tbl_number
2664: , p_employee_id IN NUMBER
2665: , p_action IN VARCHAR2
2666: , p_cbc_flag IN VARCHAR2
2667: )

Line 2680: l_orig_doc_id_tbl po_tbl_number;

2676: l_gt_key NUMBER;
2677: l_debug_rowid_tbl po_tbl_varchar2000;
2678: l_debug_column_tbl po_tbl_varchar30;
2679:
2680: l_orig_doc_id_tbl po_tbl_number;
2681: l_orig_rev_num_tbl po_tbl_number;
2682: l_orig_auth_status_tbl po_tbl_varchar30;
2683: l_orig_doc_subtype_tbl po_tbl_varchar30;
2684: l_orig_null_flag_tbl po_tbl_varchar1;

Line 2681: l_orig_rev_num_tbl po_tbl_number;

2677: l_debug_rowid_tbl po_tbl_varchar2000;
2678: l_debug_column_tbl po_tbl_varchar30;
2679:
2680: l_orig_doc_id_tbl po_tbl_number;
2681: l_orig_rev_num_tbl po_tbl_number;
2682: l_orig_auth_status_tbl po_tbl_varchar30;
2683: l_orig_doc_subtype_tbl po_tbl_varchar30;
2684: l_orig_null_flag_tbl po_tbl_varchar1;
2685:

Line 2687: l_update_doc_id_tbl po_tbl_number;

2683: l_orig_doc_subtype_tbl po_tbl_varchar30;
2684: l_orig_null_flag_tbl po_tbl_varchar1;
2685:
2686: l_update_doc_type_tbl po_tbl_varchar30;
2687: l_update_doc_id_tbl po_tbl_number;
2688:
2689: l_insert_doc_type_tbl po_tbl_varchar30;
2690: l_insert_doc_id_tbl po_tbl_number;
2691: l_insert_doc_subtype_tbl po_tbl_varchar30;

Line 2690: l_insert_doc_id_tbl po_tbl_number;

2686: l_update_doc_type_tbl po_tbl_varchar30;
2687: l_update_doc_id_tbl po_tbl_number;
2688:
2689: l_insert_doc_type_tbl po_tbl_varchar30;
2690: l_insert_doc_id_tbl po_tbl_number;
2691: l_insert_doc_subtype_tbl po_tbl_varchar30;
2692: l_insert_action_code_tbl po_tbl_varchar30;
2693: l_insert_rev_num_tbl po_tbl_number;
2694:

Line 2693: l_insert_rev_num_tbl po_tbl_number;

2689: l_insert_doc_type_tbl po_tbl_varchar30;
2690: l_insert_doc_id_tbl po_tbl_number;
2691: l_insert_doc_subtype_tbl po_tbl_varchar30;
2692: l_insert_action_code_tbl po_tbl_varchar30;
2693: l_insert_rev_num_tbl po_tbl_number;
2694:
2695: l_doc_id NUMBER;
2696: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2697: l_rev_num NUMBER;

Line 2897: l_update_doc_id_tbl := po_tbl_number();

2893: l_progress := '210';
2894:
2895: -- Initialize the update / insert tables.
2896:
2897: l_update_doc_id_tbl := po_tbl_number();
2898:
2899: l_insert_doc_id_tbl := po_tbl_number();
2900: l_insert_doc_subtype_tbl := po_tbl_varchar30();
2901: l_insert_action_code_tbl := po_tbl_varchar30();

Line 2899: l_insert_doc_id_tbl := po_tbl_number();

2895: -- Initialize the update / insert tables.
2896:
2897: l_update_doc_id_tbl := po_tbl_number();
2898:
2899: l_insert_doc_id_tbl := po_tbl_number();
2900: l_insert_doc_subtype_tbl := po_tbl_varchar30();
2901: l_insert_action_code_tbl := po_tbl_varchar30();
2902: l_insert_rev_num_tbl := po_tbl_number();
2903:

Line 2902: l_insert_rev_num_tbl := po_tbl_number();

2898:
2899: l_insert_doc_id_tbl := po_tbl_number();
2900: l_insert_doc_subtype_tbl := po_tbl_varchar30();
2901: l_insert_action_code_tbl := po_tbl_varchar30();
2902: l_insert_rev_num_tbl := po_tbl_number();
2903:
2904: l_progress := '220';
2905:
2906: -- Determine which updates and inserts need to occur.

Line 3398: l_sequence_num_tbl PO_TBL_NUMBER;

3394: l_shipment_token FND_NEW_MESSAGES.message_text%TYPE;
3395: l_distribution_token FND_NEW_MESSAGES.message_text%TYPE;
3396: l_warning_rows_flag VARCHAR2(1) := 'N';
3397:
3398: l_sequence_num_tbl PO_TBL_NUMBER;
3399: l_line_num_tbl PO_TBL_NUMBER;
3400: l_shipment_num_tbl PO_TBL_NUMBER;
3401: l_distribution_num_tbl PO_TBL_NUMBER;
3402: l_distribution_id_tbl PO_TBL_NUMBER;

Line 3399: l_line_num_tbl PO_TBL_NUMBER;

3395: l_distribution_token FND_NEW_MESSAGES.message_text%TYPE;
3396: l_warning_rows_flag VARCHAR2(1) := 'N';
3397:
3398: l_sequence_num_tbl PO_TBL_NUMBER;
3399: l_line_num_tbl PO_TBL_NUMBER;
3400: l_shipment_num_tbl PO_TBL_NUMBER;
3401: l_distribution_num_tbl PO_TBL_NUMBER;
3402: l_distribution_id_tbl PO_TBL_NUMBER;
3403: l_result_code_tbl PO_TBL_VARCHAR5;

Line 3400: l_shipment_num_tbl PO_TBL_NUMBER;

3396: l_warning_rows_flag VARCHAR2(1) := 'N';
3397:
3398: l_sequence_num_tbl PO_TBL_NUMBER;
3399: l_line_num_tbl PO_TBL_NUMBER;
3400: l_shipment_num_tbl PO_TBL_NUMBER;
3401: l_distribution_num_tbl PO_TBL_NUMBER;
3402: l_distribution_id_tbl PO_TBL_NUMBER;
3403: l_result_code_tbl PO_TBL_VARCHAR5;
3404: l_message_type_tbl PO_TBL_VARCHAR1;

Line 3401: l_distribution_num_tbl PO_TBL_NUMBER;

3397:
3398: l_sequence_num_tbl PO_TBL_NUMBER;
3399: l_line_num_tbl PO_TBL_NUMBER;
3400: l_shipment_num_tbl PO_TBL_NUMBER;
3401: l_distribution_num_tbl PO_TBL_NUMBER;
3402: l_distribution_id_tbl PO_TBL_NUMBER;
3403: l_result_code_tbl PO_TBL_VARCHAR5;
3404: l_message_type_tbl PO_TBL_VARCHAR1;
3405: l_text_line_tbl PO_TBL_VARCHAR2000;

Line 3402: l_distribution_id_tbl PO_TBL_NUMBER;

3398: l_sequence_num_tbl PO_TBL_NUMBER;
3399: l_line_num_tbl PO_TBL_NUMBER;
3400: l_shipment_num_tbl PO_TBL_NUMBER;
3401: l_distribution_num_tbl PO_TBL_NUMBER;
3402: l_distribution_id_tbl PO_TBL_NUMBER;
3403: l_result_code_tbl PO_TBL_VARCHAR5;
3404: l_message_type_tbl PO_TBL_VARCHAR1;
3405: l_text_line_tbl PO_TBL_VARCHAR2000;
3406: l_show_in_psa_tbl PO_TBL_VARCHAR1; --

Line 3783: , p_sequence_num_tbl IN po_tbl_number

3779: PROCEDURE insert_report_autonomous(
3780: p_reporting_level IN VARCHAR2
3781: , p_message_text IN VARCHAR2
3782: , p_user_id IN NUMBER
3783: , p_sequence_num_tbl IN po_tbl_number
3784: , p_line_num_tbl IN po_tbl_number
3785: , p_shipment_num_tbl IN po_tbl_number
3786: , p_distribution_num_tbl IN po_tbl_number
3787: , p_distribution_id_tbl IN po_tbl_number

Line 3784: , p_line_num_tbl IN po_tbl_number

3780: p_reporting_level IN VARCHAR2
3781: , p_message_text IN VARCHAR2
3782: , p_user_id IN NUMBER
3783: , p_sequence_num_tbl IN po_tbl_number
3784: , p_line_num_tbl IN po_tbl_number
3785: , p_shipment_num_tbl IN po_tbl_number
3786: , p_distribution_num_tbl IN po_tbl_number
3787: , p_distribution_id_tbl IN po_tbl_number
3788: , p_result_code_tbl IN po_tbl_varchar5

Line 3785: , p_shipment_num_tbl IN po_tbl_number

3781: , p_message_text IN VARCHAR2
3782: , p_user_id IN NUMBER
3783: , p_sequence_num_tbl IN po_tbl_number
3784: , p_line_num_tbl IN po_tbl_number
3785: , p_shipment_num_tbl IN po_tbl_number
3786: , p_distribution_num_tbl IN po_tbl_number
3787: , p_distribution_id_tbl IN po_tbl_number
3788: , p_result_code_tbl IN po_tbl_varchar5
3789: , p_message_type_tbl IN po_tbl_varchar1

Line 3786: , p_distribution_num_tbl IN po_tbl_number

3782: , p_user_id IN NUMBER
3783: , p_sequence_num_tbl IN po_tbl_number
3784: , p_line_num_tbl IN po_tbl_number
3785: , p_shipment_num_tbl IN po_tbl_number
3786: , p_distribution_num_tbl IN po_tbl_number
3787: , p_distribution_id_tbl IN po_tbl_number
3788: , p_result_code_tbl IN po_tbl_varchar5
3789: , p_message_type_tbl IN po_tbl_varchar1
3790: , p_text_line_tbl IN po_tbl_varchar2000

Line 3787: , p_distribution_id_tbl IN po_tbl_number

3783: , p_sequence_num_tbl IN po_tbl_number
3784: , p_line_num_tbl IN po_tbl_number
3785: , p_shipment_num_tbl IN po_tbl_number
3786: , p_distribution_num_tbl IN po_tbl_number
3787: , p_distribution_id_tbl IN po_tbl_number
3788: , p_result_code_tbl IN po_tbl_varchar5
3789: , p_message_type_tbl IN po_tbl_varchar1
3790: , p_text_line_tbl IN po_tbl_varchar2000
3791: , p_show_in_psa_flag IN po_tbl_varchar1 --