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 2197: po_tbl_varchar30('key','num1','num2','num3')

2193: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2194:
2195: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2196: PO_DEBUG.g_rowid_tbl,
2197: po_tbl_varchar30('key','num1','num2','num3')
2198: );
2199: END IF;
2200:
2201: -- Now that we have the correct references in the scratchpad,

Line 2659: l_doc_level_tbl po_tbl_varchar30;

2655: l_enc_on BOOLEAN;
2656:
2657: -- bug 3435714
2658: l_doc_level VARCHAR2(30);
2659: l_doc_level_tbl po_tbl_varchar30;
2660: l_dist_type_tbl po_tbl_varchar30;
2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 2660: l_dist_type_tbl po_tbl_varchar30;

2656:
2657: -- bug 3435714
2658: l_doc_level VARCHAR2(30);
2659: l_doc_level_tbl po_tbl_varchar30;
2660: l_dist_type_tbl po_tbl_varchar30;
2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2664: l_doc_level_id_tbl po_tbl_number;

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

2811: IF g_debug_stmt THEN
2812: PO_DEBUG.debug_stmt(l_log_head,l_progress,'multiple id do action');
2813: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT'
2814: ,PO_DEBUG.g_all_rows
2815: ,po_tbl_varchar30('distribution_type','doc_level','doc_level_id')
2816: );
2817: END IF;
2818:
2819: -- Make sure the doc_level, doc_type are constant.

Line 3735: , p_document_type => po_tbl_varchar30( p_doc_type )

3731: PO_DOCUMENT_CHECKS_GRP.po_status_check(
3732: p_api_version => 1.0
3733: , p_header_id => l_header_id_tbl
3734: , p_release_id => l_release_id_tbl
3735: , p_document_type => po_tbl_varchar30( p_doc_type )
3736: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3737: , p_document_num => po_tbl_varchar30( NULL )
3738: , p_vendor_order_num => po_tbl_varchar30( NULL )
3739: , p_line_id => l_line_id_tbl

Line 3736: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )

3732: p_api_version => 1.0
3733: , p_header_id => l_header_id_tbl
3734: , p_release_id => l_release_id_tbl
3735: , p_document_type => po_tbl_varchar30( p_doc_type )
3736: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3737: , p_document_num => po_tbl_varchar30( NULL )
3738: , p_vendor_order_num => po_tbl_varchar30( NULL )
3739: , p_line_id => l_line_id_tbl
3740: , p_line_location_id => l_line_location_id_tbl

Line 3737: , p_document_num => po_tbl_varchar30( NULL )

3733: , p_header_id => l_header_id_tbl
3734: , p_release_id => l_release_id_tbl
3735: , p_document_type => po_tbl_varchar30( p_doc_type )
3736: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3737: , p_document_num => po_tbl_varchar30( NULL )
3738: , p_vendor_order_num => po_tbl_varchar30( NULL )
3739: , p_line_id => l_line_id_tbl
3740: , p_line_location_id => l_line_location_id_tbl
3741: , p_distribution_id => l_distribution_id_tbl

Line 3738: , p_vendor_order_num => po_tbl_varchar30( NULL )

3734: , p_release_id => l_release_id_tbl
3735: , p_document_type => po_tbl_varchar30( p_doc_type )
3736: , p_document_subtype => po_tbl_varchar30( p_doc_subtype )
3737: , p_document_num => po_tbl_varchar30( NULL )
3738: , p_vendor_order_num => po_tbl_varchar30( NULL )
3739: , p_line_id => l_line_id_tbl
3740: , p_line_location_id => l_line_location_id_tbl
3741: , p_distribution_id => l_distribution_id_tbl
3742: , p_mode => l_mode

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

4709: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
4710: FROM PO_SESSION_GT WHERE key = l_procedure_id
4711: ;
4712:
4713: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4714:
4715: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',PO_DEBUG.g_rowid_tbl,PO_DEBUG.g_column_tbl,'PO');
4716:
4717: END IF;

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

5210:
5211: IF g_debug_stmt THEN
5212: PO_DEBUG.debug_table(
5213: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5214: po_tbl_varchar30( 'amount_based_flag', 'qty_ordered', 'amt_ordered' )
5215: );
5216: END IF;
5217:
5218: -- Based on the amount_ordered and the stored tax amount,

Line 5246: po_tbl_varchar30( 'nonrecoverable_tax_rate')

5242:
5243: IF g_debug_stmt THEN
5244: PO_DEBUG.debug_table(
5245: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5246: po_tbl_varchar30( 'nonrecoverable_tax_rate')
5247: );
5248: PO_DEBUG.debug_end(l_log_head);
5249: END IF;
5250:

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

5574: 'Calculated amount_closed for main document'
5575: );
5576: PO_DEBUG.debug_table(
5577: l_log_head, l_progress,'PO_ENCUMBRANCE_GT', PO_DEBUG.g_all_rows,
5578: po_tbl_varchar30( 'amount_based_flag', 'qty_closed', 'amt_closed')
5579: );
5580: PO_DEBUG.debug_end(l_log_head);
5581: END IF;
5582:

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

5731:
5732: IF g_debug_stmt THEN
5733: PO_DEBUG.debug_stmt(l_log_head,l_progress,'did UoM conversion');
5734: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
5735: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'
5736: ,'distribution_type','uom_conversion_rate','unit_meas_lookup_code'
5737: ,'item_id','sequence_num','origin_sequence_num'
5738: )
5739: );

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

5932: PO_DEBUG.debug_stmt(l_log_head,l_progress,
5933: 'Calculated amount_closed for backing Reqs'
5934: );
5935: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
5936: ,po_tbl_varchar30('prevent_encumbrance_flag','amount_based_flag'
5937: ,'qty_open','qty_ordered','qty_closed','uom_conversion_rate'
5938: ,'quantity_billed','distribution_type','sequence_num','origin_sequence_num'
5939: ,'amt_open','price','amt_ordered','amt_closed','amount_billed'
5940: )

Line 6023: ,po_tbl_varchar30('prevent_encumbrance_flag'

6019: PO_DEBUG.debug_stmt(l_log_head,l_progress,
6020: 'Updated qty_open for backing PPO'
6021: );
6022: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
6023: ,po_tbl_varchar30('prevent_encumbrance_flag'
6024: ,'qty_open','qty_ordered','qty_closed','quantity_billed'
6025: ,'distribution_type','sequence_num','origin_sequence_num')
6026: );
6027: END IF;

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

6286: PO_DEBUG.debug_stmt(l_log_head,l_progress,
6287: 'Updated amt_open for all lines'
6288: );
6289: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
6290: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'amt_open',
6291: 'qty_ordered','qty_closed','quantity_billed', 'quantity_cancelled'
6292: ,'distribution_type','sequence_num','origin_sequence_num')
6293: );
6294: END IF;

Line 6338: po_tbl_varchar30('index_char1','num1','num2')

6334: FROM PO_SESSION_GT WHERE index_char1 = g_column_PO_ENCUMBERED_AMOUNT;
6335:
6336: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
6337: PO_DEBUG.g_rowid_tbl,
6338: po_tbl_varchar30('index_char1','num1','num2')
6339: );
6340: END IF;
6341:
6342: FORALL i IN 1..l_sequence_num_tbl.count

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

6376: PO_DEBUG.debug_stmt(l_log_head,l_progress,
6377: 'Updated pre_round_amt for all lines'
6378: );
6379: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_ENCUMBRANCE_GT',PO_DEBUG.g_all_rows
6380: ,po_tbl_varchar30('prevent_encumbrance_flag' ,'pre_round_amt')
6381: );
6382: END IF;
6383:
6384: