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_PREPROCESSING dependencies on PO_TBL_VARCHAR30

Line 2159: po_tbl_varchar30('key','num1','num2','num3')

2155: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2156:
2157: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2158: PO_DEBUG.g_rowid_tbl,
2159: po_tbl_varchar30('key','num1','num2','num3')
2160: );
2161: END IF;
2162:
2163: -- Now that we have the correct references in the scratchpad,

Line 2621: l_doc_level_tbl po_tbl_varchar30;

2617: l_enc_on BOOLEAN;
2618:
2619: -- bug 3435714
2620: l_doc_level VARCHAR2(30);
2621: l_doc_level_tbl po_tbl_varchar30;
2622: l_dist_type_tbl po_tbl_varchar30;
2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 2622: l_dist_type_tbl po_tbl_varchar30;

2618:
2619: -- bug 3435714
2620: l_doc_level VARCHAR2(30);
2621: l_doc_level_tbl po_tbl_varchar30;
2622: l_dist_type_tbl po_tbl_varchar30;
2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2626: l_doc_level_id_tbl po_tbl_number;

Line 2777: ,po_tbl_varchar30('distribution_type','doc_level','doc_level_id')

2773: IF g_debug_stmt THEN
2774: PO_DEBUG.debug_stmt(l_log_head,l_progress,'multiple id do action');
2775: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT'
2776: ,PO_DEBUG.g_all_rows
2777: ,po_tbl_varchar30('distribution_type','doc_level','doc_level_id')
2778: );
2779: END IF;
2780:
2781: -- Make sure the doc_level, doc_type are constant.

Line 3693: , p_document_type => po_tbl_varchar30( p_doc_type )

3689: PO_DOCUMENT_CHECKS_GRP.po_status_check(
3690: p_api_version => 1.0
3691: , p_header_id => l_header_id_tbl
3692: , p_release_id => l_release_id_tbl
3693: , p_document_type => po_tbl_varchar30( p_doc_type )
3694: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3695: , p_document_num => po_tbl_varchar30( NULL )
3696: , p_vendor_order_num => po_tbl_varchar30( NULL )
3697: , p_line_id => l_line_id_tbl

Line 3694: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )

3690: p_api_version => 1.0
3691: , p_header_id => l_header_id_tbl
3692: , p_release_id => l_release_id_tbl
3693: , p_document_type => po_tbl_varchar30( p_doc_type )
3694: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3695: , p_document_num => po_tbl_varchar30( NULL )
3696: , p_vendor_order_num => po_tbl_varchar30( NULL )
3697: , p_line_id => l_line_id_tbl
3698: , p_line_location_id => l_line_location_id_tbl

Line 3695: , p_document_num => po_tbl_varchar30( NULL )

3691: , p_header_id => l_header_id_tbl
3692: , p_release_id => l_release_id_tbl
3693: , p_document_type => po_tbl_varchar30( p_doc_type )
3694: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3695: , p_document_num => po_tbl_varchar30( NULL )
3696: , p_vendor_order_num => po_tbl_varchar30( NULL )
3697: , p_line_id => l_line_id_tbl
3698: , p_line_location_id => l_line_location_id_tbl
3699: , p_distribution_id => l_distribution_id_tbl

Line 3696: , p_vendor_order_num => po_tbl_varchar30( NULL )

3692: , p_release_id => l_release_id_tbl
3693: , p_document_type => po_tbl_varchar30( p_doc_type )
3694: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3695: , p_document_num => po_tbl_varchar30( NULL )
3696: , p_vendor_order_num => po_tbl_varchar30( NULL )
3697: , p_line_id => l_line_id_tbl
3698: , p_line_location_id => l_line_location_id_tbl
3699: , p_distribution_id => l_distribution_id_tbl
3700: , p_mode => l_mode

Line 4562: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542

4558: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
4559: FROM PO_SESSION_GT WHERE key = l_procedure_id
4560: ;
4561:
4562: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4563:
4564: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',PO_DEBUG.g_rowid_tbl,PO_DEBUG.g_column_tbl,'PO');
4565:
4566: END IF;

Line 5060: po_tbl_varchar30( 'amount_based_flag', 'qty_ordered', 'amt_ordered' )

5056:
5057: IF g_debug_stmt THEN
5058: PO_DEBUG.debug_table(
5059: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5060: po_tbl_varchar30( 'amount_based_flag', 'qty_ordered', 'amt_ordered' )
5061: );
5062: END IF;
5063:
5064: -- Based on the amount_ordered and the stored tax amount,

Line 5092: po_tbl_varchar30( 'nonrecoverable_tax_rate')

5088:
5089: IF g_debug_stmt THEN
5090: PO_DEBUG.debug_table(
5091: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5092: po_tbl_varchar30( 'nonrecoverable_tax_rate')
5093: );
5094: PO_DEBUG.debug_end(l_log_head);
5095: END IF;
5096:

Line 5386: po_tbl_varchar30( 'amount_based_flag', 'qty_closed', 'amt_closed')

5382: 'Calculated amount_closed for main document'
5383: );
5384: PO_DEBUG.debug_table(
5385: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5386: po_tbl_varchar30( 'amount_based_flag', 'qty_closed', 'amt_closed')
5387: );
5388: PO_DEBUG.debug_end(l_log_head);
5389: END IF;
5390:

Line 5541: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'

5537:
5538: IF g_debug_stmt THEN
5539: PO_DEBUG.debug_stmt(l_log_head,l_progress,'did UoM conversion');
5540: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
5541: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'
5542: ,'distribution_type','uom_conversion_rate','unit_meas_lookup_code'
5543: ,'item_id','sequence_num','origin_sequence_num'
5544: )
5545: );

Line 5701: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'

5697: PO_DEBUG.debug_stmt(l_log_head,l_progress,
5698: 'Calculated amount_closed for backing Reqs'
5699: );
5700: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
5701: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'
5702: ,'qty_open','qty_ordered','qty_closed','uom_conversion_rate'
5703: ,'quantity_billed','distribution_type','sequence_num','origin_sequence_num'
5704: ,'amt_open','price','amt_ordered','amt_closed','amount_billed'
5705: )

Line 5788: ,po_tbl_varchar30('prevent_encumbrance_flag'

5784: PO_DEBUG.debug_stmt(l_log_head,l_progress,
5785: 'Updated qty_open for backing PPO'
5786: );
5787: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
5788: ,po_tbl_varchar30('prevent_encumbrance_flag'
5789: ,'qty_open','qty_ordered','qty_closed','quantity_billed'
5790: ,'distribution_type','sequence_num','origin_sequence_num')
5791: );
5792: END IF;

Line 6007: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'amt_open',

6003: PO_DEBUG.debug_stmt(l_log_head,l_progress,
6004: 'Updated amt_open for all lines'
6005: );
6006: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
6007: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'amt_open',
6008: 'qty_ordered','qty_closed','quantity_billed', 'quantity_cancelled'
6009: ,'distribution_type','sequence_num','origin_sequence_num')
6010: );
6011: END IF;

Line 6027: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'pre_round_amt')

6023: PO_DEBUG.debug_stmt(l_log_head,l_progress,
6024: 'Updated pre_round_amt for all lines'
6025: );
6026: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
6027: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'pre_round_amt')
6028: );
6029: END IF;
6030:
6031: