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_VARCHAR30

Line 1341: l_dist_type_tbl po_tbl_varchar30;

1337: l_gl_status_tbl gl_status_tbl_type;
1338: l_gl_result_code_tbl gl_result_code_tbl_type;
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

Line 1626: po_tbl_varchar30('result_text', 'result_type',

1622: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1623: 'PO update of text/message type successful');
1624: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1625: PO_DEBUG.g_all_rows,
1626: po_tbl_varchar30('result_text', 'result_type',
1627: 'prevent_encumbrance_flag')
1628: );
1629: PO_DEBUG.debug_end(l_log_head);
1630: END IF;

Line 1875: po_tbl_varchar30('encumbered_flag',

1871: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1872: 'Updated encumbered_amount_change');
1873: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1874: PO_DEBUG.g_all_rows,
1875: po_tbl_varchar30('encumbered_flag',
1876: 'encumbered_amount_change')
1877: );
1878: END IF;
1879:

Line 2678: l_debug_column_tbl po_tbl_varchar30;

2674: l_record_action PO_ACTION_HISTORY.action_code%TYPE;
2675:
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;

Line 2682: l_orig_auth_status_tbl po_tbl_varchar30;

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:
2686: l_update_doc_type_tbl po_tbl_varchar30;

Line 2683: l_orig_doc_subtype_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:
2686: l_update_doc_type_tbl po_tbl_varchar30;
2687: l_update_doc_id_tbl po_tbl_number;

Line 2686: l_update_doc_type_tbl po_tbl_varchar30;

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:
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;

Line 2689: l_insert_doc_type_tbl po_tbl_varchar30;

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;
2692: l_insert_action_code_tbl po_tbl_varchar30;
2693: l_insert_rev_num_tbl po_tbl_number;

Line 2691: l_insert_doc_subtype_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:
2695: l_doc_id NUMBER;

Line 2692: l_insert_action_code_tbl po_tbl_varchar30;

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:
2695: l_doc_id NUMBER;
2696: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 2861: , po_tbl_varchar30('num1','num2','char1','char2','char3')

2857: l_progress := '160';
2858:
2859: IF g_debug_stmt THEN
2860: PO_DEBUG.debug_session_gt(l_log_head,l_progress,l_gt_key
2861: , po_tbl_varchar30('num1','num2','char1','char2','char3')
2862: );
2863: END IF;
2864:
2865: l_progress := '200';

Line 2900: l_insert_doc_subtype_tbl := po_tbl_varchar30();

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:
2904: l_progress := '220';

Line 2901: l_insert_action_code_tbl := po_tbl_varchar30();

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:
2904: l_progress := '220';
2905:

Line 3002: l_update_doc_type_tbl := po_tbl_varchar30(p_doc_type);

2998: --
2999: -- Update the NULL action records to the action being taken.
3000: --
3001:
3002: l_update_doc_type_tbl := po_tbl_varchar30(p_doc_type);
3003: l_update_doc_type_tbl.EXTEND(l_update_count-1, 1);
3004:
3005: l_progress := '330';
3006:

Line 3028: l_insert_doc_type_tbl := po_tbl_varchar30(p_doc_type);

3024: --
3025: -- Insert action records.
3026: --
3027:
3028: l_insert_doc_type_tbl := po_tbl_varchar30(p_doc_type);
3029: l_insert_doc_type_tbl.EXTEND(l_insert_count-1, 1);
3030:
3031: l_progress := '420';
3032: