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

Line 677: l_err_msg_name_tbl po_tbl_varchar30;

673: callDocCheck boolean :=false;
674: accp_flag char(1);
675: v_buyer_id number;
676: x_accp_flag po_headers_all.acceptance_required_flag%type;
677: l_err_msg_name_tbl po_tbl_varchar30;
678: l_err_msg_text_tbl po_tbl_varchar2000;
679: l_last_upd_date po_headers_all.last_update_date%type;
680: l_count_asn NUMBER;
681: l_ret_sts varchar2(1);

Line 724: l_err_msg_name_tbl := po_tbl_varchar30();

720: CLOSE REL_CSR;
721: EXCEPTION
722: WHEN OTHERS THEN
723: if (sqlcode = '-54') then
724: l_err_msg_name_tbl := po_tbl_varchar30();
725: l_err_msg_text_tbl := po_tbl_varchar2000();
726: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
727: x_pos_errors.message_name.extend;
728: x_pos_errors.text_line.extend;

Line 751: l_err_msg_name_tbl := po_tbl_varchar30();

747: CLOSE PO_CSR;
748: EXCEPTION
749: WHEN OTHERS THEN
750: if (sqlcode = '-54') then
751: l_err_msg_name_tbl := po_tbl_varchar30();
752: l_err_msg_text_tbl := po_tbl_varchar2000();
753: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
754: x_pos_errors.message_name.extend;
755: x_pos_errors.text_line.extend;

Line 769: l_err_msg_name_tbl := po_tbl_varchar30();

765: -- Check against last_updated_date to make sure that
766: -- The record that was queried is being updated
767:
768: if (p_last_upd_date <> l_last_upd_date) then
769: l_err_msg_name_tbl := po_tbl_varchar30();
770: l_err_msg_text_tbl := po_tbl_varchar2000();
771: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
772: x_pos_errors.message_name.extend;
773: x_pos_errors.text_line.extend;

Line 814: l_err_msg_name_tbl := po_tbl_varchar30();

810: END IF;
811:
812:
813:
814: l_err_msg_name_tbl := po_tbl_varchar30();
815: l_err_msg_text_tbl := po_tbl_varchar2000();
816: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
817:
818:

Line 843: l_err_msg_name_tbl := po_tbl_varchar30();

839: x_request_group_id => l_request_group_id
840: );
841: x_online_report_id := 0;
842: if (l_return_status <> FND_API.g_ret_sts_success) then
843: l_err_msg_name_tbl := po_tbl_varchar30();
844: l_err_msg_text_tbl := po_tbl_varchar2000();
845: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
846:
847:

Line 1108: l_err_msg_name_tbl := po_tbl_varchar30();

1104: '.invoked', ' All shipments acked/changed ' );
1105: END IF;
1106: END IF;
1107: else
1108: l_err_msg_name_tbl := po_tbl_varchar30();
1109: l_err_msg_text_tbl := po_tbl_varchar2000();
1110: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1111: x_pos_errors.message_name.extend;
1112: x_pos_errors.text_line.extend;

Line 1380: supItemTbl po_tbl_varchar30 := po_tbl_varchar30();

1376:
1377: poLineIdTbl po_tbl_number := po_tbl_number();
1378: unitPriceTbl po_tbl_number := po_tbl_number();
1379: -- VENDOR_PRODUCT_NUM should use varchar30, not varchar40:
1380: supItemTbl po_tbl_varchar30 := po_tbl_varchar30();
1381: startdateTbl po_tbl_date := po_tbl_date();
1382: expirationdateTbl po_tbl_date := po_tbl_date();
1383: amountTbl po_tbl_number := po_tbl_number();
1384: shipamountTbl po_tbl_number := po_tbl_number();

Line 1421: l_err_msg_name_tbl po_tbl_varchar30;

1417: sub_error_flag varchar2(1);
1418: x_cum_flag boolean := FALSE;
1419: x_price number := NULL;
1420: l_error_index number := 0;
1421: l_err_msg_name_tbl po_tbl_varchar30;
1422: l_err_msg_text_tbl po_tbl_varchar2000;
1423: l_total_qty number;
1424: l_ga_ship_qty number;
1425: l_ga_lineLocId number;

Line 1438: progress_type_tbl PO_TBL_VARCHAR30:= PO_TBL_VARCHAR30();

1434: l_price_break_type VARCHAR2(1) := NULL;
1435: l_cumulative_flag BOOLEAN := false;
1436: l_initiator po_change_requests.initiator%type :='SUPPLIER';
1437: --<< Complex work changes for R12 >>
1438: progress_type_tbl PO_TBL_VARCHAR30:= PO_TBL_VARCHAR30();
1439: pay_description_tbl PO_TBL_VARCHAR240:= PO_TBL_VARCHAR240();
1440:
1441:
1442: cursor ga_line_csr(p_po_header_id in number) is

Line 1757: l_err_msg_name_tbl := po_tbl_varchar30();

1753:
1754:
1755:
1756:
1757: l_err_msg_name_tbl := po_tbl_varchar30();
1758: l_err_msg_text_tbl := po_tbl_varchar2000();
1759: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1760:
1761: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 3171: l_err_msg_name_tbl po_tbl_varchar30;

3167: ) IS
3168:
3169: l_po_change_requests pos_chg_rec_tbl := NULL;
3170: l_count_asn NUMBER;
3171: l_err_msg_name_tbl po_tbl_varchar30;
3172: l_err_msg_text_tbl po_tbl_varchar2000;
3173: l_err_count NUMBER;
3174:
3175: BEGIN

Line 3178: l_err_msg_name_tbl := po_tbl_varchar30();

3174:
3175: BEGIN
3176: l_err_count := 0;
3177: l_po_change_requests := p_po_change_requests ;
3178: l_err_msg_name_tbl := po_tbl_varchar30();
3179: l_err_msg_text_tbl := po_tbl_varchar2000();
3180: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3181: x_ret_sts := 'N';
3182: FOR j in 1..l_po_change_requests.count()

Line 3256: l_err_msg_name_tbl po_tbl_varchar30;

3252: ) IS
3253:
3254: l_po_change_requests pos_chg_rec_tbl := NULL;
3255: l_count_asn NUMBER;
3256: l_err_msg_name_tbl po_tbl_varchar30;
3257: l_err_msg_text_tbl po_tbl_varchar2000;
3258: l_err_count NUMBER;
3259: l_quan_ordered NUMBER;
3260: l_quan_recd NUMBER;

Line 3265: l_err_msg_name_tbl := po_tbl_varchar30();

3261: l_quan_billed NUMBER;
3262: BEGIN
3263: l_err_count := 0;
3264: l_po_change_requests := p_po_change_requests ;
3265: l_err_msg_name_tbl := po_tbl_varchar30();
3266: l_err_msg_text_tbl := po_tbl_varchar2000();
3267: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3268: FOR j in 1..l_po_change_requests.count()
3269: LOOP