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_VARCHAR1

Line 1147: l_delete_flag_tbl PO_TBL_VARCHAR1;

1143: l_record_already_exists VARCHAR2(1);
1144: l_org_assignment_id_tbl PO_TBL_NUMBER;
1145: l_notification_id_tbl PO_TBL_NUMBER;
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

Line 1148: l_record_already_exist_tbl PO_TBL_VARCHAR1;

1144: l_org_assignment_id_tbl PO_TBL_NUMBER;
1145: l_notification_id_tbl PO_TBL_NUMBER;
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:

Line 1156: l_delete_flag_tbl:=Po_Tbl_Varchar1();

1152:
1153: l_org_assignment_id_tbl:= Po_Tbl_Number();
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

Line 1157: l_record_already_exist_tbl:=Po_Tbl_Varchar1();

1153: l_org_assignment_id_tbl:= Po_Tbl_Number();
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);

Line 1552: l_delete_flag_tbl PO_TBL_VARCHAR1;

1548: l_draft_old_amount_tbl PO_TBL_NUMBER;
1549: l_po_line_id_tbl PO_TBL_NUMBER;
1550: l_po_line_s_no_lck_tbl PO_TBL_NUMBER;
1551: l_draft_id_tbl PO_TBL_NUMBER;
1552: l_delete_flag_tbl PO_TBL_VARCHAR1;
1553: l_record_already_exists PO_TBL_VARCHAR1;
1554: l_header_base_rev_num PO_TBL_NUMBER;
1555: d_api_name CONSTANT VARCHAR2(30) := 'sync_lines';
1556: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 1553: l_record_already_exists PO_TBL_VARCHAR1;

1549: l_po_line_id_tbl PO_TBL_NUMBER;
1550: l_po_line_s_no_lck_tbl PO_TBL_NUMBER;
1551: l_draft_id_tbl PO_TBL_NUMBER;
1552: l_delete_flag_tbl PO_TBL_VARCHAR1;
1553: l_record_already_exists PO_TBL_VARCHAR1;
1554: l_header_base_rev_num PO_TBL_NUMBER;
1555: d_api_name CONSTANT VARCHAR2(30) := 'sync_lines';
1556: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1557: d_position NUMBER;

Line 1565: l_base_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1;

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;
1568: l_isUcaEnabled varchar2(1);
1569: --UCA Project - CLM R4 Changes End

Line 1570: l_draft_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1; --bug 16451273

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; --
1572: BEGIN
1573: l_base_quantity_tbl:=po_tbl_number();
1574: l_base_amount_tbl:=po_tbl_number();

Line 1582: l_delete_flag_tbl:=Po_Tbl_Varchar1();

1578: l_draft_old_amount_tbl:=po_tbl_number();
1579: l_po_line_id_tbl:=po_tbl_number();
1580: l_po_line_s_no_lck_tbl:=po_tbl_number();
1581: l_draft_id_tbl :=po_tbl_number();
1582: l_delete_flag_tbl:=Po_Tbl_Varchar1();
1583: l_record_already_exists:=Po_Tbl_Varchar1();
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();

Line 1583: l_record_already_exists:=Po_Tbl_Varchar1();

1579: l_po_line_id_tbl:=po_tbl_number();
1580: l_po_line_s_no_lck_tbl:=po_tbl_number();
1581: l_draft_id_tbl :=po_tbl_number();
1582: l_delete_flag_tbl:=Po_Tbl_Varchar1();
1583: l_record_already_exists:=Po_Tbl_Varchar1();
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();

Line 1591: l_base_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1();

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();
1594: --UCA Project - CLM R4 Changes End
1595: l_draft_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1(); --bug 16451273

Line 1595: l_draft_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1(); --bug 16451273

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:
1598: d_position := 0;
1599: IF (PO_LOG.d_proc) THEN

Line 1998: l_delete_flag_tbl PO_TBL_VARCHAR1;

1994: l_draft_old_amount_tbl PO_TBL_NUMBER;
1995: l_line_location_tbl PO_TBL_NUMBER;
1996: l_po_line_loc_s_no_lck_tbl PO_TBL_NUMBER;
1997: l_draft_id_tbl PO_TBL_NUMBER;
1998: l_delete_flag_tbl PO_TBL_VARCHAR1;
1999: l_record_already_exists PO_TBL_VARCHAR1;
2000: l_header_base_rev_num PO_TBL_NUMBER;
2001: d_api_name CONSTANT VARCHAR2(30) := 'sync_shipments';
2002: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 1999: l_record_already_exists PO_TBL_VARCHAR1;

1995: l_line_location_tbl PO_TBL_NUMBER;
1996: l_po_line_loc_s_no_lck_tbl PO_TBL_NUMBER;
1997: l_draft_id_tbl PO_TBL_NUMBER;
1998: l_delete_flag_tbl PO_TBL_VARCHAR1;
1999: l_record_already_exists PO_TBL_VARCHAR1;
2000: l_header_base_rev_num PO_TBL_NUMBER;
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;

Line 2016: l_delete_flag_tbl:=Po_Tbl_Varchar1();

2012: l_draft_old_amount_tbl:=po_tbl_number();
2013: l_line_location_tbl:=po_tbl_number();
2014: l_po_line_loc_s_no_lck_tbl:=po_tbl_number();
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;

Line 2017: l_record_already_exists:=Po_Tbl_Varchar1();

2013: l_line_location_tbl:=po_tbl_number();
2014: l_po_line_loc_s_no_lck_tbl:=po_tbl_number();
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

Line 2219: l_delete_flag_tbl PO_TBL_VARCHAR1;

2215: l_draft_old_amount_tbl PO_TBL_NUMBER;
2216: l_po_distribution_tbl PO_TBL_NUMBER;
2217: l_po_dist_s_no_lck_tbl PO_TBL_NUMBER;
2218: l_draft_id_tbl PO_TBL_NUMBER;
2219: l_delete_flag_tbl PO_TBL_VARCHAR1;
2220: l_record_already_exists PO_TBL_VARCHAR1;
2221: l_header_base_rev_num PO_TBL_NUMBER;
2222: d_api_name CONSTANT VARCHAR2(30) := 'sync_distributions';
2223: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 2220: l_record_already_exists PO_TBL_VARCHAR1;

2216: l_po_distribution_tbl PO_TBL_NUMBER;
2217: l_po_dist_s_no_lck_tbl PO_TBL_NUMBER;
2218: l_draft_id_tbl PO_TBL_NUMBER;
2219: l_delete_flag_tbl PO_TBL_VARCHAR1;
2220: l_record_already_exists PO_TBL_VARCHAR1;
2221: l_header_base_rev_num PO_TBL_NUMBER;
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;

Line 2237: l_delete_flag_tbl:=Po_Tbl_Varchar1();

2233: l_draft_old_amount_tbl:=po_tbl_number();
2234: l_po_distribution_tbl:=po_tbl_number();
2235: l_po_dist_s_no_lck_tbl:=po_tbl_number();
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;

Line 2238: l_record_already_exists:=Po_Tbl_Varchar1();

2234: l_po_distribution_tbl:=po_tbl_number();
2235: l_po_dist_s_no_lck_tbl:=po_tbl_number();
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