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 780: l_err_msg_name_tbl po_tbl_varchar30;

776: callDocCheck boolean :=false;
777: accp_flag char(1);
778: v_buyer_id number;
779: x_accp_flag po_headers_all.acceptance_required_flag%type;
780: l_err_msg_name_tbl po_tbl_varchar30;
781: l_err_msg_text_tbl po_tbl_varchar2000;
782: l_last_upd_date po_headers_all.last_update_date%type;
783: l_count_asn NUMBER;
784: l_ret_sts varchar2(1);

Line 827: l_err_msg_name_tbl := po_tbl_varchar30();

823: CLOSE REL_CSR;
824: EXCEPTION
825: WHEN OTHERS THEN
826: if (sqlcode = '-54') then
827: l_err_msg_name_tbl := po_tbl_varchar30();
828: l_err_msg_text_tbl := po_tbl_varchar2000();
829: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
830: x_pos_errors.message_name.extend;
831: x_pos_errors.text_line.extend;

Line 854: l_err_msg_name_tbl := po_tbl_varchar30();

850: CLOSE PO_CSR;
851: EXCEPTION
852: WHEN OTHERS THEN
853: if (sqlcode = '-54') then
854: l_err_msg_name_tbl := po_tbl_varchar30();
855: l_err_msg_text_tbl := po_tbl_varchar2000();
856: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
857: x_pos_errors.message_name.extend;
858: x_pos_errors.text_line.extend;

Line 872: l_err_msg_name_tbl := po_tbl_varchar30();

868: -- Check against last_updated_date to make sure that
869: -- The record that was queried is being updated
870:
871: if (p_last_upd_date <> l_last_upd_date) then
872: l_err_msg_name_tbl := po_tbl_varchar30();
873: l_err_msg_text_tbl := po_tbl_varchar2000();
874: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
875: x_pos_errors.message_name.extend;
876: x_pos_errors.text_line.extend;

Line 918: l_err_msg_name_tbl := po_tbl_varchar30();

914: END IF;
915:
916:
917:
918: l_err_msg_name_tbl := po_tbl_varchar30();
919: l_err_msg_text_tbl := po_tbl_varchar2000();
920: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
921:
922:

Line 947: l_err_msg_name_tbl := po_tbl_varchar30();

943: x_request_group_id => l_request_group_id
944: );
945: x_online_report_id := 0;
946: if (l_return_status <> FND_API.g_ret_sts_success) then
947: l_err_msg_name_tbl := po_tbl_varchar30();
948: l_err_msg_text_tbl := po_tbl_varchar2000();
949: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
950:
951:

Line 1221: l_err_msg_name_tbl := po_tbl_varchar30();

1217: '.invoked', ' All shipments acked/changed ' );
1218: END IF;
1219: END IF;
1220: else
1221: l_err_msg_name_tbl := po_tbl_varchar30();
1222: l_err_msg_text_tbl := po_tbl_varchar2000();
1223: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1224: x_pos_errors.message_name.extend;
1225: x_pos_errors.text_line.extend;

Line 1494: supItemTbl po_tbl_varchar30 := po_tbl_varchar30();

1490:
1491: poLineIdTbl po_tbl_number := po_tbl_number();
1492: unitPriceTbl po_tbl_number := po_tbl_number();
1493: -- VENDOR_PRODUCT_NUM should use varchar30, not varchar40:
1494: supItemTbl po_tbl_varchar30 := po_tbl_varchar30();
1495: startdateTbl po_tbl_date := po_tbl_date();
1496: expirationdateTbl po_tbl_date := po_tbl_date();
1497: amountTbl po_tbl_number := po_tbl_number();
1498: shipamountTbl po_tbl_number := po_tbl_number();

Line 1535: l_err_msg_name_tbl po_tbl_varchar30;

1531: sub_error_flag varchar2(1);
1532: x_cum_flag boolean := FALSE;
1533: x_price number := NULL;
1534: l_error_index number := 0;
1535: l_err_msg_name_tbl po_tbl_varchar30;
1536: l_err_msg_text_tbl po_tbl_varchar2000;
1537: l_total_qty number;
1538: l_ga_ship_qty number;
1539: l_ga_lineLocId number;

Line 1552: progress_type_tbl PO_TBL_VARCHAR30:= PO_TBL_VARCHAR30();

1548: l_price_break_type VARCHAR2(1) := NULL;
1549: l_cumulative_flag BOOLEAN := false;
1550: l_initiator po_change_requests.initiator%type :='SUPPLIER';
1551: --<< Complex work changes for R12 >>
1552: progress_type_tbl PO_TBL_VARCHAR30:= PO_TBL_VARCHAR30();
1553: pay_description_tbl PO_TBL_VARCHAR240:= PO_TBL_VARCHAR240();
1554:
1555: /* 9867085 */
1556: skip_line number := 0;

Line 1905: l_err_msg_name_tbl := po_tbl_varchar30();

1901:
1902:
1903:
1904:
1905: l_err_msg_name_tbl := po_tbl_varchar30();
1906: l_err_msg_text_tbl := po_tbl_varchar2000();
1907: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1908:
1909: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 3546: l_err_msg_name_tbl po_tbl_varchar30;

3542: ) IS
3543:
3544: l_po_change_requests pos_chg_rec_tbl := NULL;
3545: l_count_asn NUMBER;
3546: l_err_msg_name_tbl po_tbl_varchar30;
3547: l_err_msg_text_tbl po_tbl_varchar2000;
3548: l_err_count NUMBER;
3549:
3550: BEGIN

Line 3553: l_err_msg_name_tbl := po_tbl_varchar30();

3549:
3550: BEGIN
3551: l_err_count := 0;
3552: l_po_change_requests := p_po_change_requests ;
3553: l_err_msg_name_tbl := po_tbl_varchar30();
3554: l_err_msg_text_tbl := po_tbl_varchar2000();
3555: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3556: x_ret_sts := 'N';
3557: FOR j in 1..l_po_change_requests.count()

Line 3657: l_err_msg_name_tbl po_tbl_varchar30;

3653: ) IS
3654:
3655: l_po_change_requests pos_chg_rec_tbl := NULL;
3656: l_count_asn NUMBER;
3657: l_err_msg_name_tbl po_tbl_varchar30;
3658: l_err_msg_text_tbl po_tbl_varchar2000;
3659: l_err_count NUMBER;
3660: l_quan_ordered NUMBER;
3661: l_quan_recd NUMBER;

Line 3666: l_err_msg_name_tbl := po_tbl_varchar30();

3662: l_quan_billed NUMBER;
3663: BEGIN
3664: l_err_count := 0;
3665: l_po_change_requests := p_po_change_requests ;
3666: l_err_msg_name_tbl := po_tbl_varchar30();
3667: l_err_msg_text_tbl := po_tbl_varchar2000();
3668: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3669: FOR j in 1..l_po_change_requests.count()
3670: LOOP

Line 3752: l_err_msg_name_tbl PO_TBL_VARCHAR30;

3748: x_ret_sts OUT nocopy VARCHAR2)
3749: IS
3750: l_po_change_requests POS_CHG_REC_TBL := NULL;
3751: l_count_asn NUMBER;
3752: l_err_msg_name_tbl PO_TBL_VARCHAR30;
3753: l_err_msg_text_tbl PO_TBL_VARCHAR2000;
3754: l_err_count NUMBER;
3755: l_api_name VARCHAR2(100) := 'IS_ASN_EXIST';
3756: CURSOR ship_cur(

Line 3764: l_err_msg_name_tbl := Po_tbl_varchar30();

3760: WHERE po_line_id = p_po_line_id;
3761: BEGIN
3762: l_err_count := 0;
3763: l_po_change_requests := p_po_change_requests;
3764: l_err_msg_name_tbl := Po_tbl_varchar30();
3765: l_err_msg_text_tbl := Po_tbl_varchar2000();
3766: x_pos_errors := Pos_err_type(l_err_msg_name_tbl, l_err_msg_text_tbl);
3767: x_ret_sts := 'N';
3768: