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_NUMBER

Line 50: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --

46: PROCEDURE sync_lines_ext
47: (
48: p_draft_id IN NUMBER
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --
51: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --
52: );
53:
54: PROCEDURE sync_shipments_ext

Line 51: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --

47: (
48: p_draft_id IN NUMBER
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --
51: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --
52: );
53:
54: PROCEDURE sync_shipments_ext
55: (

Line 58: ,p_po_line_loc_s_no_lck_tbl IN PO_TBL_NUMBER --

54: PROCEDURE sync_shipments_ext
55: (
56: p_draft_id IN NUMBER
57: ,x_return_status OUT NOCOPY VARCHAR2
58: ,p_po_line_loc_s_no_lck_tbl IN PO_TBL_NUMBER --
59: );
60:
61: PROCEDURE sync_uda_address
62: (

Line 1144: l_org_assignment_id_tbl PO_TBL_NUMBER;

1140: l_enabled_flag VARCHAR2(5);
1141: l_return_status VARCHAR2(1);
1142: l_delete_flag VARCHAR2(1);
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;

Line 1145: l_notification_id_tbl PO_TBL_NUMBER;

1141: l_return_status VARCHAR2(1);
1142: l_delete_flag VARCHAR2(1);
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);

Line 1146: l_draft_id_tbl PO_TBL_NUMBER;

1142: l_delete_flag VARCHAR2(1);
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

Line 1153: l_org_assignment_id_tbl:= Po_Tbl_Number();

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();
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();

Line 1154: l_notification_id_tbl:= Po_Tbl_Number();

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();
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();

Line 1155: l_draft_id_tbl :=po_tbl_number();

1151: BEGIN
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;

Line 1543: l_base_quantity_tbl PO_TBL_NUMBER;

1539: p_uda_enabled_flag IN VARCHAR2
1540: ,x_return_status OUT NOCOPY VARCHAR2
1541: ) IS
1542:
1543: l_base_quantity_tbl PO_TBL_NUMBER;
1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;

Line 1544: l_base_amount_tbl PO_TBL_NUMBER;

1540: ,x_return_status OUT NOCOPY VARCHAR2
1541: ) IS
1542:
1543: l_base_quantity_tbl PO_TBL_NUMBER;
1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
1548: l_draft_old_amount_tbl PO_TBL_NUMBER;

Line 1545: l_draft_quantity_tbl PO_TBL_NUMBER;

1541: ) IS
1542:
1543: l_base_quantity_tbl PO_TBL_NUMBER;
1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
1548: l_draft_old_amount_tbl PO_TBL_NUMBER;
1549: l_po_line_id_tbl PO_TBL_NUMBER;

Line 1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;

1542:
1543: l_base_quantity_tbl PO_TBL_NUMBER;
1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1547: l_draft_amount_tbl PO_TBL_NUMBER;

1543: l_base_quantity_tbl PO_TBL_NUMBER;
1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1548: l_draft_old_amount_tbl PO_TBL_NUMBER;

1544: l_base_amount_tbl PO_TBL_NUMBER;
1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1549: l_po_line_id_tbl PO_TBL_NUMBER;

1545: l_draft_quantity_tbl PO_TBL_NUMBER;
1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1550: l_po_line_s_no_lck_tbl PO_TBL_NUMBER;

1546: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1547: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1551: l_draft_id_tbl PO_TBL_NUMBER;

1547: l_draft_amount_tbl PO_TBL_NUMBER;
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';

Line 1554: l_header_base_rev_num 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;
1558: d_api_version CONSTANT NUMBER := 1.0;

Line 1559: l_attribute_values_id_tbl 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;
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

Line 1560: l_attribute_values_tlp_id_tbl PO_TBL_NUMBER;

1556: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1557: d_position NUMBER;
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.

Line 1561: l_price_differential_id_tbl PO_TBL_NUMBER;

1557: d_position NUMBER;
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;

Line 1566: l_base_CLM_APP_UNDEF_AMT_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
1570: l_draft_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1; --bug 16451273

Line 1571: l_po_line_s_no_p_lck_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();
1575: l_draft_quantity_tbl:=po_tbl_number();

Line 1573: l_base_quantity_tbl:=po_tbl_number();

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();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();

Line 1574: l_base_amount_tbl:=po_tbl_number();

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();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
1578: l_draft_old_amount_tbl:=po_tbl_number();

Line 1575: l_draft_quantity_tbl:=po_tbl_number();

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();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
1578: l_draft_old_amount_tbl:=po_tbl_number();
1579: l_po_line_id_tbl:=po_tbl_number();

Line 1576: l_draft_old_quantity_tbl:=po_tbl_number();

1572: BEGIN
1573: l_base_quantity_tbl:=po_tbl_number();
1574: l_base_amount_tbl:=po_tbl_number();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1577: l_draft_amount_tbl:=po_tbl_number();

1573: l_base_quantity_tbl:=po_tbl_number();
1574: l_base_amount_tbl:=po_tbl_number();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1578: l_draft_old_amount_tbl:=po_tbl_number();

1574: l_base_amount_tbl:=po_tbl_number();
1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1579: l_po_line_id_tbl:=po_tbl_number();

1575: l_draft_quantity_tbl:=po_tbl_number();
1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1580: l_po_line_s_no_lck_tbl:=po_tbl_number();

1576: l_draft_old_quantity_tbl:=po_tbl_number();
1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1581: l_draft_id_tbl :=po_tbl_number();

1577: l_draft_amount_tbl:=po_tbl_number();
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();

Line 1584: l_header_base_rev_num:=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();
1588: l_change_status_tbl :=Po_Tbl_Varchar30();

Line 1585: l_attribute_values_id_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();
1588: l_change_status_tbl :=Po_Tbl_Varchar30();
1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();

Line 1586: l_attribute_values_tlp_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();
1588: l_change_status_tbl :=Po_Tbl_Varchar30();
1589: l_change_status_lines_tbl:=Po_Tbl_Varchar30();
1590: --UCA Project - CLM R4 Changes Begin.

Line 1587: l_price_differential_id_tbl := po_tbl_number();

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();
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();

Line 1592: l_base_CLM_APP_UNDEF_AMT_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
1596: l_po_line_s_no_p_lck_tbl := po_tbl_number(); --

Line 1596: l_po_line_s_no_p_lck_tbl := po_tbl_number(); --

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
1600: PO_LOG.proc_begin(d_module);

Line 1989: l_base_quantity_tbl PO_TBL_NUMBER;

1985: p_draft_id IN NUMBER
1986: ,p_uda_enabled_flag VARCHAR2
1987: ,x_return_status OUT NOCOPY VARCHAR2
1988: ) IS
1989: l_base_quantity_tbl PO_TBL_NUMBER;
1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;

Line 1990: l_base_amount_tbl PO_TBL_NUMBER;

1986: ,p_uda_enabled_flag VARCHAR2
1987: ,x_return_status OUT NOCOPY VARCHAR2
1988: ) IS
1989: l_base_quantity_tbl PO_TBL_NUMBER;
1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
1994: l_draft_old_amount_tbl PO_TBL_NUMBER;

Line 1991: l_draft_quantity_tbl PO_TBL_NUMBER;

1987: ,x_return_status OUT NOCOPY VARCHAR2
1988: ) IS
1989: l_base_quantity_tbl PO_TBL_NUMBER;
1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
1994: l_draft_old_amount_tbl PO_TBL_NUMBER;
1995: l_line_location_tbl PO_TBL_NUMBER;

Line 1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;

1988: ) IS
1989: l_base_quantity_tbl PO_TBL_NUMBER;
1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1993: l_draft_amount_tbl PO_TBL_NUMBER;

1989: l_base_quantity_tbl PO_TBL_NUMBER;
1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1994: l_draft_old_amount_tbl PO_TBL_NUMBER;

1990: l_base_amount_tbl PO_TBL_NUMBER;
1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1995: l_line_location_tbl PO_TBL_NUMBER;

1991: l_draft_quantity_tbl PO_TBL_NUMBER;
1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1996: l_po_line_loc_s_no_lck_tbl PO_TBL_NUMBER;

1992: l_draft_old_quantity_tbl PO_TBL_NUMBER;
1993: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 1997: l_draft_id_tbl PO_TBL_NUMBER;

1993: l_draft_amount_tbl PO_TBL_NUMBER;
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';

Line 2000: l_header_base_rev_num 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;
2004: d_api_version CONSTANT NUMBER := 1.0;

Line 2007: l_base_quantity_tbl:=po_tbl_number();

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();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();

Line 2008: l_base_amount_tbl:=po_tbl_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();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
2012: l_draft_old_amount_tbl:=po_tbl_number();

Line 2009: l_draft_quantity_tbl:=po_tbl_number();

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();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
2012: l_draft_old_amount_tbl:=po_tbl_number();
2013: l_line_location_tbl:=po_tbl_number();

Line 2010: l_draft_old_quantity_tbl:=po_tbl_number();

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();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2011: l_draft_amount_tbl:=po_tbl_number();

2007: l_base_quantity_tbl:=po_tbl_number();
2008: l_base_amount_tbl:=po_tbl_number();
2009: l_draft_quantity_tbl:=po_tbl_number();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2012: l_draft_old_amount_tbl:=po_tbl_number();

2008: l_base_amount_tbl:=po_tbl_number();
2009: l_draft_quantity_tbl:=po_tbl_number();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2013: l_line_location_tbl:=po_tbl_number();

2009: l_draft_quantity_tbl:=po_tbl_number();
2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2014: l_po_line_loc_s_no_lck_tbl:=po_tbl_number();

2010: l_draft_old_quantity_tbl:=po_tbl_number();
2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2015: l_draft_id_tbl :=po_tbl_number();

2011: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2018: l_header_base_rev_num:=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
2022: PO_LOG.proc_begin(d_module);

Line 2210: l_base_quantity_tbl PO_TBL_NUMBER;

2206: p_draft_id IN NUMBER
2207: ,x_return_status OUT NOCOPY VARCHAR2
2208: ) IS
2209:
2210: l_base_quantity_tbl PO_TBL_NUMBER;
2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;

Line 2211: l_base_amount_tbl PO_TBL_NUMBER;

2207: ,x_return_status OUT NOCOPY VARCHAR2
2208: ) IS
2209:
2210: l_base_quantity_tbl PO_TBL_NUMBER;
2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
2215: l_draft_old_amount_tbl PO_TBL_NUMBER;

Line 2212: l_draft_quantity_tbl PO_TBL_NUMBER;

2208: ) IS
2209:
2210: l_base_quantity_tbl PO_TBL_NUMBER;
2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
2215: l_draft_old_amount_tbl PO_TBL_NUMBER;
2216: l_po_distribution_tbl PO_TBL_NUMBER;

Line 2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;

2209:
2210: l_base_quantity_tbl PO_TBL_NUMBER;
2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 2214: l_draft_amount_tbl PO_TBL_NUMBER;

2210: l_base_quantity_tbl PO_TBL_NUMBER;
2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 2215: l_draft_old_amount_tbl PO_TBL_NUMBER;

2211: l_base_amount_tbl PO_TBL_NUMBER;
2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 2216: l_po_distribution_tbl PO_TBL_NUMBER;

2212: l_draft_quantity_tbl PO_TBL_NUMBER;
2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 2217: l_po_dist_s_no_lck_tbl PO_TBL_NUMBER;

2213: l_draft_old_quantity_tbl PO_TBL_NUMBER;
2214: l_draft_amount_tbl PO_TBL_NUMBER;
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;

Line 2218: l_draft_id_tbl PO_TBL_NUMBER;

2214: l_draft_amount_tbl PO_TBL_NUMBER;
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';

Line 2221: l_header_base_rev_num 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;
2225: d_api_version CONSTANT NUMBER := 1.0;

Line 2228: l_base_quantity_tbl:=po_tbl_number();

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();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();

Line 2229: l_base_amount_tbl:=po_tbl_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();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
2233: l_draft_old_amount_tbl:=po_tbl_number();

Line 2230: l_draft_quantity_tbl:=po_tbl_number();

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();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
2233: l_draft_old_amount_tbl:=po_tbl_number();
2234: l_po_distribution_tbl:=po_tbl_number();

Line 2231: l_draft_old_quantity_tbl:=po_tbl_number();

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();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2232: l_draft_amount_tbl:=po_tbl_number();

2228: l_base_quantity_tbl:=po_tbl_number();
2229: l_base_amount_tbl:=po_tbl_number();
2230: l_draft_quantity_tbl:=po_tbl_number();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2233: l_draft_old_amount_tbl:=po_tbl_number();

2229: l_base_amount_tbl:=po_tbl_number();
2230: l_draft_quantity_tbl:=po_tbl_number();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2234: l_po_distribution_tbl:=po_tbl_number();

2230: l_draft_quantity_tbl:=po_tbl_number();
2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2235: l_po_dist_s_no_lck_tbl:=po_tbl_number();

2231: l_draft_old_quantity_tbl:=po_tbl_number();
2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2236: l_draft_id_tbl :=po_tbl_number();

2232: l_draft_amount_tbl:=po_tbl_number();
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();

Line 2239: l_header_base_rev_num :=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
2243: PO_LOG.proc_begin(d_module);

Line 2405: l_entension_id_tbl PO_TBL_NUMBER;

2401: IS
2402:
2403: l_po_header_id NUMBER;
2404: l_base_lang VARCHAR2(30);
2405: l_entension_id_tbl PO_TBL_NUMBER;
2406: d_api_name CONSTANT VARCHAR2(30) := 'sync_headers_ext';
2407: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2408: d_position NUMBER;
2409: d_api_version CONSTANT NUMBER := 1.0;

Line 2418: l_entension_id_tbl:=po_tbl_number();

2414: PO_LOG.proc_begin(d_module);
2415: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2416: END IF;
2417:
2418: l_entension_id_tbl:=po_tbl_number();
2419: SELECT document_id
2420: INTO l_po_header_id
2421: FROM po_drafts
2422: WHERE draft_id = p_draft_id;

Line 3269: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --

3265:
3266: PROCEDURE sync_lines_ext(
3267: p_draft_id IN NUMBER
3268: ,x_return_status OUT NOCOPY VARCHAR2
3269: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --
3270: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --
3271: ) IS
3272:
3273: d_api_name CONSTANT VARCHAR2(30) := 'sync_lines_ext';

Line 3270: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --

3266: PROCEDURE sync_lines_ext(
3267: p_draft_id IN NUMBER
3268: ,x_return_status OUT NOCOPY VARCHAR2
3269: ,p_po_line_s_no_lck_tbl IN PO_TBL_NUMBER --
3270: ,p_po_line_s_no_p_lck_tbl IN PO_TBL_NUMBER --
3271: ) IS
3272:
3273: d_api_name CONSTANT VARCHAR2(30) := 'sync_lines_ext';
3274: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 4096: ,p_po_line_loc_s_no_lck_tbl IN PO_TBL_NUMBER --

4092: --------------------------------------------------------------------------------
4093: PROCEDURE sync_shipments_ext(
4094: p_draft_id IN NUMBER
4095: ,x_return_status OUT NOCOPY VARCHAR2
4096: ,p_po_line_loc_s_no_lck_tbl IN PO_TBL_NUMBER --
4097: ) IS
4098: d_api_name CONSTANT VARCHAR2(30) := 'sync_shipments_ext';
4099: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
4100: d_position NUMBER;