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

Line 1150: l_change_status_tbl PO_TBL_VARCHAR30;-- used po_ga_org_assign_draft,po_notification_ctrl_draft

1146: l_draft_id_tbl PO_TBL_NUMBER;
1147: l_delete_flag_tbl PO_TBL_VARCHAR1;
1148: l_record_already_exist_tbl PO_TBL_VARCHAR1;
1149: l_change_status VARCHAR2(30);
1150: l_change_status_tbl PO_TBL_VARCHAR30;-- used po_ga_org_assign_draft,po_notification_ctrl_draft
1151: BEGIN
1152:
1153: l_org_assignment_id_tbl:= Po_Tbl_Number();
1154: l_notification_id_tbl:= Po_Tbl_Number();

Line 1158: l_change_status_tbl :=PO_TBL_VARCHAR30();

1154: l_notification_id_tbl:= Po_Tbl_Number();
1155: l_draft_id_tbl :=po_tbl_number();
1156: l_delete_flag_tbl:=Po_Tbl_Varchar1();
1157: l_record_already_exist_tbl:=Po_Tbl_Varchar1();
1158: l_change_status_tbl :=PO_TBL_VARCHAR30();
1159: d_position := 0;
1160: IF (PO_LOG.d_proc) THEN
1161: PO_LOG.proc_begin(d_module);
1162: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

Line 1562: l_change_status_lines_tbl Po_Tbl_Varchar30; -- chnage_status of po_lines_draft_all

1558: d_api_version CONSTANT NUMBER := 1.0;
1559: l_attribute_values_id_tbl PO_TBL_NUMBER;
1560: l_attribute_values_tlp_id_tbl PO_TBL_NUMBER;
1561: l_price_differential_id_tbl PO_TBL_NUMBER;
1562: l_change_status_lines_tbl Po_Tbl_Varchar30; -- chnage_status of po_lines_draft_all
1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft
1564: --UCA Project - CLM R4 Changes Begin.
1565: l_base_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1;
1566: l_base_CLM_APP_UNDEF_AMT_tbl Po_tbl_number;

Line 1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft

1559: l_attribute_values_id_tbl PO_TBL_NUMBER;
1560: l_attribute_values_tlp_id_tbl PO_TBL_NUMBER;
1561: l_price_differential_id_tbl PO_TBL_NUMBER;
1562: l_change_status_lines_tbl Po_Tbl_Varchar30; -- chnage_status of po_lines_draft_all
1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft
1564: --UCA Project - CLM R4 Changes Begin.
1565: l_base_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1;
1566: l_base_CLM_APP_UNDEF_AMT_tbl Po_tbl_number;
1567: l_draft_CLM_UNDEF_ACTION_CODE po_tbl_varchar30;

Line 1567: l_draft_CLM_UNDEF_ACTION_CODE po_tbl_varchar30;

1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft
1564: --UCA Project - CLM R4 Changes Begin.
1565: l_base_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1;
1566: l_base_CLM_APP_UNDEF_AMT_tbl Po_tbl_number;
1567: l_draft_CLM_UNDEF_ACTION_CODE po_tbl_varchar30;
1568: l_isUcaEnabled varchar2(1);
1569: --UCA Project - CLM R4 Changes End
1570: l_draft_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1; --bug 16451273
1571: l_po_line_s_no_p_lck_tbl PO_TBL_NUMBER; --

Line 1588: l_change_status_tbl :=Po_Tbl_Varchar30();

1584: l_header_base_rev_num:=po_tbl_number();
1585: l_attribute_values_id_tbl := po_tbl_number();
1586: l_attribute_values_tlp_id_tbl := po_tbl_number();
1587: l_price_differential_id_tbl := po_tbl_number();
1588: l_change_status_tbl :=Po_Tbl_Varchar30();
1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();
1590: --UCA Project - CLM R4 Changes Begin.
1591: l_base_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1();
1592: l_base_CLM_APP_UNDEF_AMT_tbl := Po_tbl_number();

Line 1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();

1585: l_attribute_values_id_tbl := po_tbl_number();
1586: l_attribute_values_tlp_id_tbl := po_tbl_number();
1587: l_price_differential_id_tbl := po_tbl_number();
1588: l_change_status_tbl :=Po_Tbl_Varchar30();
1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();
1590: --UCA Project - CLM R4 Changes Begin.
1591: l_base_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1();
1592: l_base_CLM_APP_UNDEF_AMT_tbl := Po_tbl_number();
1593: l_draft_CLM_UNDEF_ACTION_CODE := po_tbl_varchar30();

Line 1593: l_draft_CLM_UNDEF_ACTION_CODE := po_tbl_varchar30();

1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();
1590: --UCA Project - CLM R4 Changes Begin.
1591: l_base_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1();
1592: l_base_CLM_APP_UNDEF_AMT_tbl := Po_tbl_number();
1593: l_draft_CLM_UNDEF_ACTION_CODE := po_tbl_varchar30();
1594: --UCA Project - CLM R4 Changes End
1595: l_draft_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1(); --bug 16451273
1596: l_po_line_s_no_p_lck_tbl := po_tbl_number(); --
1597:

Line 2005: l_change_status_tbl PO_TBL_VARCHAR30;

2001: d_api_name CONSTANT VARCHAR2(30) := 'sync_shipments';
2002: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2003: d_position NUMBER;
2004: d_api_version CONSTANT NUMBER := 1.0;
2005: l_change_status_tbl PO_TBL_VARCHAR30;
2006: BEGIN
2007: l_base_quantity_tbl:=po_tbl_number();
2008: l_base_amount_tbl:=po_tbl_number();
2009: l_draft_quantity_tbl:=po_tbl_number();

Line 2019: l_change_status_tbl :=PO_TBL_VARCHAR30();

2015: l_draft_id_tbl :=po_tbl_number();
2016: l_delete_flag_tbl:=Po_Tbl_Varchar1();
2017: l_record_already_exists:=Po_Tbl_Varchar1();
2018: l_header_base_rev_num:=po_tbl_number();
2019: l_change_status_tbl :=PO_TBL_VARCHAR30();
2020: d_position := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

Line 2226: l_change_status_tbl PO_TBL_VARCHAR30;

2222: d_api_name CONSTANT VARCHAR2(30) := 'sync_distributions';
2223: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2224: d_position NUMBER;
2225: d_api_version CONSTANT NUMBER := 1.0;
2226: l_change_status_tbl PO_TBL_VARCHAR30;
2227: BEGIN
2228: l_base_quantity_tbl:=po_tbl_number();
2229: l_base_amount_tbl:=po_tbl_number();
2230: l_draft_quantity_tbl:=po_tbl_number();

Line 2240: l_change_status_tbl := PO_TBL_VARCHAR30();

2236: l_draft_id_tbl :=po_tbl_number();
2237: l_delete_flag_tbl:=Po_Tbl_Varchar1();
2238: l_record_already_exists:=Po_Tbl_Varchar1();
2239: l_header_base_rev_num :=po_tbl_number();
2240: l_change_status_tbl := PO_TBL_VARCHAR30();
2241: d_position := 0;
2242: IF (PO_LOG.d_proc) THEN
2243: PO_LOG.proc_begin(d_module);
2244: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);