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 1419: l_dist_type_tbl po_tbl_varchar30;

1415: l_gl_status_tbl gl_status_tbl_type;
1416: l_gl_result_code_tbl gl_result_code_tbl_type;
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

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

1781: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1782: 'PO update of text/message type successful');
1783: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1784: PO_DEBUG.g_all_rows,
1785: po_tbl_varchar30('result_text', 'result_type',
1786: 'prevent_encumbrance_flag')
1787: );
1788: PO_DEBUG.debug_end(l_log_head);
1789: END IF;

Line 2034: po_tbl_varchar30('encumbered_flag',

2030: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2031: 'Updated encumbered_amount_change');
2032: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
2033: PO_DEBUG.g_all_rows,
2034: po_tbl_varchar30('encumbered_flag',
2035: 'encumbered_amount_change')
2036: );
2037: END IF;
2038:

Line 3007: l_debug_column_tbl po_tbl_varchar30;

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

Line 3011: l_orig_auth_status_tbl po_tbl_varchar30;

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

Line 3012: l_orig_doc_subtype_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:
3015: l_update_doc_type_tbl po_tbl_varchar30;
3016: l_update_doc_id_tbl po_tbl_number;

Line 3015: l_update_doc_type_tbl po_tbl_varchar30;

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

Line 3018: l_insert_doc_type_tbl po_tbl_varchar30;

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;
3021: l_insert_action_code_tbl po_tbl_varchar30;
3022: l_insert_rev_num_tbl po_tbl_number;

Line 3020: l_insert_doc_subtype_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:
3024: l_doc_id NUMBER;

Line 3021: l_insert_action_code_tbl po_tbl_varchar30;

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

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

3187: l_progress := '160';
3188:
3189: IF g_debug_stmt THEN
3190: PO_DEBUG.debug_session_gt(l_log_head,l_progress,l_gt_key
3191: , po_tbl_varchar30('num1','num2','char1','char2','char3')
3192: );
3193: END IF;
3194:
3195: l_progress := '200';

Line 3230: l_insert_doc_subtype_tbl := po_tbl_varchar30();

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

Line 3231: l_insert_action_code_tbl := po_tbl_varchar30();

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

Line 3332: l_update_doc_type_tbl := po_tbl_varchar30(p_doc_type);

3328: --
3329: -- Update the NULL action records to the action being taken.
3330: --
3331:
3332: l_update_doc_type_tbl := po_tbl_varchar30(p_doc_type);
3333: l_update_doc_type_tbl.EXTEND(l_update_count-1, 1);
3334:
3335: l_progress := '330';
3336:

Line 3358: l_insert_doc_type_tbl := po_tbl_varchar30(p_doc_type);

3354: --
3355: -- Insert action records.
3356: --
3357:
3358: l_insert_doc_type_tbl := po_tbl_varchar30(p_doc_type);
3359: l_insert_doc_type_tbl.EXTEND(l_insert_count-1, 1);
3360:
3361: l_progress := '420';
3362: