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.ICX_POR_EXT_TEST dependencies on FND_API

Line 1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,

1035: 'disable_date = DECODE(:disable_date,:miss_date, disable_date, ' ||
1036: ':disable_date), ' ||
1037: 'last_update_date = SYSDATE ' ||
1038: 'WHERE category_id =:category_id '
1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,
1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,

Line 1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,

1036: ':disable_date), ' ||
1037: 'last_update_date = SYSDATE ' ||
1038: 'WHERE category_id =:category_id '
1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,
1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,
1044: p_category_id;

Line 1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,

1037: 'last_update_date = SYSDATE ' ||
1038: 'WHERE category_id =:category_id '
1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,
1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,
1044: p_category_id;
1045:

Line 1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,

1038: 'WHERE category_id =:category_id '
1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,
1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,
1044: p_category_id;
1045:
1046:

Line 1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,

1039: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1040: p_web_status, FND_API.G_MISS_CHAR, p_web_status,
1041: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
1042: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
1043: p_disable_date, FND_API.G_MISS_DATE, p_disable_date,
1044: p_category_id;
1045:
1046:
1047: xErrLoc:= 200;

Line 1055: USING p_description, FND_API.G_MISS_CHAR, p_description,

1051: 'description,:description), ' ||
1052: 'last_update_date = SYSDATE ' ||
1053: 'WHERE category_id =:category_id ' ||
1054: 'AND language =:language '
1055: USING p_description, FND_API.G_MISS_CHAR, p_description,
1056: p_category_id, gBaseLang;
1057:
1058: xErrLoc:= 300;
1059: COMMIT;

Line 1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,

1629: ':miss_char, unit_of_issue,:unit_of_issue), '||
1630: 'last_update_date = SYSDATE ' ||
1631: 'WHERE inventory_item_id =:inventory_item_id ' ||
1632: 'AND organization_id =:organization_id '
1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,

Line 1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,

1630: 'last_update_date = SYSDATE ' ||
1631: 'WHERE inventory_item_id =:inventory_item_id ' ||
1632: 'AND organization_id =:organization_id '
1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,

Line 1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,

1631: 'WHERE inventory_item_id =:inventory_item_id ' ||
1632: 'AND organization_id =:organization_id '
1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,

Line 1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,

1632: 'AND organization_id =:organization_id '
1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,

Line 1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,

1633: USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,

Line 1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,

1634: p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,

Line 1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,

1635: p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,
1643: p_inventory_item_id, p_organization_id;

Line 1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,

1636: p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,
1643: p_inventory_item_id, p_organization_id;
1644:

Line 1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,

1637: p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,
1643: p_inventory_item_id, p_organization_id;
1644:
1645: xErrLoc:= 200;

Line 1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,

1638: p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
1639: p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
1640: p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
1641: p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
1642: p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,
1643: p_inventory_item_id, p_organization_id;
1644:
1645: xErrLoc:= 200;
1646: EXECUTE IMMEDIATE

Line 1653: USING p_description, FND_API.G_MISS_CHAR, p_description,

1649: ':miss_char, description,:description), '||
1650: 'last_update_date = SYSDATE ' ||
1651: 'WHERE inventory_item_id =:inventory_item_id ' ||
1652: 'AND organization_id =:organization_id '
1653: USING p_description, FND_API.G_MISS_CHAR, p_description,
1654: p_inventory_item_id, p_organization_id;
1655:
1656: xErrLoc:= 300;
1657: EXECUTE IMMEDIATE

Line 1664: USING p_category_id, FND_API.G_MISS_NUM, p_category_id,

1660: ':miss_num, category_id,:category_id), '||
1661: 'last_update_date = SYSDATE ' ||
1662: 'WHERE inventory_item_id =:inventory_item_id ' ||
1663: 'AND organization_id =:organization_id '
1664: USING p_category_id, FND_API.G_MISS_NUM, p_category_id,
1665: p_inventory_item_id, p_organization_id;
1666:
1667: xErrLoc:= 400;
1668: COMMIT;

Line 1943: USING p_purchasing_site_flag, FND_API.G_MISS_CHAR, p_purchasing_site_flag,

1939: 'inactive_date = DECODE(:inactive_date, '||
1940: ':miss_date, inactive_date,:inactive_date), '||
1941: 'last_update_date = SYSDATE ' ||
1942: 'WHERE vendor_site_id =:vendor_site_id '
1943: USING p_purchasing_site_flag, FND_API.G_MISS_CHAR, p_purchasing_site_flag,
1944: p_inactive_date, FND_API.G_MISS_DATE, p_inactive_date,
1945: p_vendor_site_id;
1946:
1947: xErrLoc:= 400;

Line 1944: p_inactive_date, FND_API.G_MISS_DATE, p_inactive_date,

1940: ':miss_date, inactive_date,:inactive_date), '||
1941: 'last_update_date = SYSDATE ' ||
1942: 'WHERE vendor_site_id =:vendor_site_id '
1943: USING p_purchasing_site_flag, FND_API.G_MISS_CHAR, p_purchasing_site_flag,
1944: p_inactive_date, FND_API.G_MISS_DATE, p_inactive_date,
1945: p_vendor_site_id;
1946:
1947: xErrLoc:= 400;
1948: COMMIT;

Line 2092: USING p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,

2088: 'disable_flag = DECODE(:disable_flag, '||
2089: ':miss_char, disable_flag,:disable_flag), '||
2090: 'last_update_date = SYSDATE ' ||
2091: 'WHERE asl_id =:asl_id '
2092: USING p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2093: p_primary_vendor_item, FND_API.G_MISS_CHAR, p_primary_vendor_item,
2094: p_disable_flag, FND_API.G_MISS_CHAR, p_disable_flag,
2095: p_asl_id;
2096:

Line 2093: p_primary_vendor_item, FND_API.G_MISS_CHAR, p_primary_vendor_item,

2089: ':miss_char, disable_flag,:disable_flag), '||
2090: 'last_update_date = SYSDATE ' ||
2091: 'WHERE asl_id =:asl_id '
2092: USING p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2093: p_primary_vendor_item, FND_API.G_MISS_CHAR, p_primary_vendor_item,
2094: p_disable_flag, FND_API.G_MISS_CHAR, p_disable_flag,
2095: p_asl_id;
2096:
2097: xErrLoc:= 200;

Line 2094: p_disable_flag, FND_API.G_MISS_CHAR, p_disable_flag,

2090: 'last_update_date = SYSDATE ' ||
2091: 'WHERE asl_id =:asl_id '
2092: USING p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2093: p_primary_vendor_item, FND_API.G_MISS_CHAR, p_primary_vendor_item,
2094: p_disable_flag, FND_API.G_MISS_CHAR, p_disable_flag,
2095: p_asl_id;
2096:
2097: xErrLoc:= 200;
2098: EXECUTE IMMEDIATE

Line 2104: USING p_allow_action_flag, FND_API.G_MISS_CHAR, p_allow_action_flag,

2100: 'allow_action_flag = DECODE(:allow_action_flag, '||
2101: ':miss_char, allow_action_flag,:allow_action_flag), '||
2102: 'last_update_date = SYSDATE ' ||
2103: 'WHERE status_id =:status_id '
2104: USING p_allow_action_flag, FND_API.G_MISS_CHAR, p_allow_action_flag,
2105: p_asl_status_id;
2106:
2107: xErrLoc:= 300;
2108: EXECUTE IMMEDIATE

Line 2114: USING p_purchasing_unit_of_measure, FND_API.G_MISS_CHAR,

2110: 'purchasing_unit_of_measure = DECODE(:purchasing_unit_of_measure, '||
2111: ':miss_char, purchasing_unit_of_measure,:purchasing_unit_of_measure), '||
2112: 'last_update_date = SYSDATE ' ||
2113: 'WHERE asl_id =:asl_id '
2114: USING p_purchasing_unit_of_measure, FND_API.G_MISS_CHAR,
2115: p_purchasing_unit_of_measure, p_asl_id;
2116:
2117: xErrLoc:= 400;
2118: COMMIT;

Line 2383: USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,

2379: 'last_update_date = SYSDATE ' ||
2380: 'WHERE org_id =:org_id ' ||
2381: 'AND express_name =:express_name ' ||
2382: 'AND sequence_num =:sequence_num '
2383: USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,
2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project

Line 2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,

2380: 'WHERE org_id =:org_id ' ||
2381: 'AND express_name =:express_name ' ||
2382: 'AND sequence_num =:sequence_num '
2383: USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,
2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,

Line 2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,

2381: 'AND express_name =:express_name ' ||
2382: 'AND sequence_num =:sequence_num '
2383: USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,
2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,

Line 2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,

2382: 'AND sequence_num =:sequence_num '
2383: USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,
2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,

Line 2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,

2384: p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,
2391: p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,
2392: p_org_id, p_express_name, p_sequence_num;

Line 2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,

2385: p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,
2391: p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,
2392: p_org_id, p_express_name, p_sequence_num;
2393:

Line 2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,

2386: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,
2391: p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,
2392: p_org_id, p_express_name, p_sequence_num;
2393:
2394: xErrLoc:= 400;

Line 2391: p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,

2387: -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
2388: p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
2389: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2390: p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,
2391: p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,
2392: p_org_id, p_express_name, p_sequence_num;
2393:
2394: xErrLoc:= 400;
2395: COMMIT;

Line 2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,

2834: 'global_agreement_flag = DECODE(:global_agreement_flag, '||
2835: ':miss_char, global_agreement_flag,:global_agreement_flag), '||
2836: 'last_update_date = SYSDATE ' ||
2837: 'WHERE po_header_id =:po_header_id '
2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,
2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,

Line 2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,

2835: ':miss_char, global_agreement_flag,:global_agreement_flag), '||
2836: 'last_update_date = SYSDATE ' ||
2837: 'WHERE po_header_id =:po_header_id '
2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,
2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,

Line 2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,

2836: 'last_update_date = SYSDATE ' ||
2837: 'WHERE po_header_id =:po_header_id '
2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,
2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

Line 2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,

2837: 'WHERE po_header_id =:po_header_id '
2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,
2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,

Line 2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,

2838: USING p_rate, FND_API.G_MISS_NUM, p_rate,
2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

Line 2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,

2839: p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,

Line 2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

2840: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,

Line 2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,

2841: p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,
2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,

Line 2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

2842: p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,
2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,
2850: p_po_header_id;

Line 2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,

2843: p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,
2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,
2850: p_po_header_id;
2851:

Line 2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,

2844: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,
2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,
2850: p_po_header_id;
2851:
2852: xErrLoc:= 400;

Line 2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,

2845: p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
2846: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2847: p_start_date, FND_API.G_MISS_DATE, p_start_date,
2848: p_end_date, FND_API.G_MISS_DATE, p_end_date,
2849: p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,
2850: p_po_header_id;
2851:
2852: xErrLoc:= 400;
2853: COMMIT;

Line 2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,

2919: 'expiration_date = DECODE(:expiration_date, '||
2920: ':miss_date, expiration_date,:expiration_date), '||
2921: 'last_update_date = SYSDATE ' ||
2922: 'WHERE po_line_id =:po_line_id '
2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,

Line 2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,

2920: ':miss_date, expiration_date,:expiration_date), '||
2921: 'last_update_date = SYSDATE ' ||
2922: 'WHERE po_line_id =:po_line_id '
2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,

Line 2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,

2921: 'last_update_date = SYSDATE ' ||
2922: 'WHERE po_line_id =:po_line_id '
2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

Line 2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,

2922: 'WHERE po_line_id =:po_line_id '
2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

Line 2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,

2923: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,

Line 2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,

2924: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
2932: p_po_line_id;

Line 2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

2925: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
2932: p_po_line_id;
2933:

Line 2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

2926: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
2932: p_po_line_id;
2933:
2934: xErrLoc:= 200;

Line 2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,

2927: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
2928: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
2929: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
2930: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
2931: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
2932: p_po_line_id;
2933:
2934: xErrLoc:= 200;
2935: EXECUTE IMMEDIATE

Line 2941: USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,

2937: 'outside_operation_flag = DECODE(:outside_operation_flag, '||
2938: ':miss_char, outside_operation_flag,:outside_operation_flag), '||
2939: 'last_update_date = SYSDATE ' ||
2940: 'WHERE line_type_id =:line_type_id '
2941: USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
2942: p_line_type_id;
2943:
2944: xErrLoc:= 400;
2945: COMMIT;

Line 3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,

3025: 'not_to_exceed_price = DECODE(:not_to_exceed_price, '||
3026: ':miss_num, not_to_exceed_price,:not_to_exceed_price), '||
3027: 'last_update_date = SYSDATE ' ||
3028: 'WHERE po_line_id =:po_line_id '
3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,

Line 3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,

3026: ':miss_num, not_to_exceed_price,:not_to_exceed_price), '||
3027: 'last_update_date = SYSDATE ' ||
3028: 'WHERE po_line_id =:po_line_id '
3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,

Line 3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,

3027: 'last_update_date = SYSDATE ' ||
3028: 'WHERE po_line_id =:po_line_id '
3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

Line 3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,

3028: 'WHERE po_line_id =:po_line_id '
3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

Line 3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,

3029: USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,

Line 3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,

3030: p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,

Line 3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,

3031: p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,

Line 3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,

3032: p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,

Line 3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,

3033: p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,
3041: p_po_line_id;

Line 3038: p_amount, FND_API.G_MISS_NUM, p_amount,

3034: p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,
3041: p_po_line_id;
3042:

Line 3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,

3035: p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,
3041: p_po_line_id;
3042:
3043: xErrLoc:= 200;

Line 3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,

3036: p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
3037: p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
3038: p_amount, FND_API.G_MISS_NUM, p_amount,
3039: p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
3040: p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,
3041: p_po_line_id;
3042:
3043: xErrLoc:= 200;
3044: EXECUTE IMMEDIATE

Line 3050: USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,

3046: 'outside_operation_flag = DECODE(:outside_operation_flag, '||
3047: ':miss_char, outside_operation_flag,:outside_operation_flag), '||
3048: 'last_update_date = SYSDATE ' ||
3049: 'WHERE line_type_id =:line_type_id '
3050: USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
3051: p_line_type_id;
3052:
3053: xErrLoc:= 400;
3054: COMMIT;

Line 3164: USING p_start_date, FND_API.G_MISS_DATE, p_start_date,

3160: 'end_date = DECODE(:end_date, '||
3161: ':miss_date, end_date,:end_date), '||
3162: 'last_update_date = SYSDATE ' ||
3163: 'WHERE line_location_id =:line_location_id '
3164: USING p_start_date, FND_API.G_MISS_DATE, p_start_date,
3165: p_end_date, FND_API.G_MISS_DATE, p_end_date,
3166: p_line_location_id;
3167:
3168: xErrLoc:= 200;

Line 3165: p_end_date, FND_API.G_MISS_DATE, p_end_date,

3161: ':miss_date, end_date,:end_date), '||
3162: 'last_update_date = SYSDATE ' ||
3163: 'WHERE line_location_id =:line_location_id '
3164: USING p_start_date, FND_API.G_MISS_DATE, p_start_date,
3165: p_end_date, FND_API.G_MISS_DATE, p_end_date,
3166: p_line_location_id;
3167:
3168: xErrLoc:= 200;
3169: EXECUTE IMMEDIATE

Line 3180: USING p_approval_type, FND_API.G_MISS_CHAR, p_approval_type,

3176: 'end_date_active = DECODE(:end_date_active, '||
3177: ':miss_date, end_date_active,:end_date_active), '||
3178: 'last_update_date = SYSDATE ' ||
3179: 'WHERE line_location_id =:line_location_id '
3180: USING p_approval_type, FND_API.G_MISS_CHAR, p_approval_type,
3181: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
3182: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
3183: p_line_location_id;
3184:

Line 3181: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,

3177: ':miss_date, end_date_active,:end_date_active), '||
3178: 'last_update_date = SYSDATE ' ||
3179: 'WHERE line_location_id =:line_location_id '
3180: USING p_approval_type, FND_API.G_MISS_CHAR, p_approval_type,
3181: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
3182: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
3183: p_line_location_id;
3184:
3185: xErrLoc:= 400;

Line 3182: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,

3178: 'last_update_date = SYSDATE ' ||
3179: 'WHERE line_location_id =:line_location_id '
3180: USING p_approval_type, FND_API.G_MISS_CHAR, p_approval_type,
3181: p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
3182: p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
3183: p_line_location_id;
3184:
3185: xErrLoc:= 400;
3186: COMMIT;

Line 3279: USING p_enabled_flag, FND_API.G_MISS_CHAR, p_enabled_flag,

3275: ':miss_num, purchasing_org_id,:purchasing_org_id), '||
3276: 'last_update_date = SYSDATE ' ||
3277: 'WHERE po_header_id =:po_header_id ' ||
3278: 'AND organization_id =:organization_id '
3279: USING p_enabled_flag, FND_API.G_MISS_CHAR, p_enabled_flag,
3280: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
3281: p_purchasing_org_id, FND_API.G_MISS_NUM, p_purchasing_org_id,
3282: p_po_header_id, p_organization_id;
3283:

Line 3280: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,

3276: 'last_update_date = SYSDATE ' ||
3277: 'WHERE po_header_id =:po_header_id ' ||
3278: 'AND organization_id =:organization_id '
3279: USING p_enabled_flag, FND_API.G_MISS_CHAR, p_enabled_flag,
3280: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
3281: p_purchasing_org_id, FND_API.G_MISS_NUM, p_purchasing_org_id,
3282: p_po_header_id, p_organization_id;
3283:
3284: xErrLoc:= 400;

Line 3281: p_purchasing_org_id, FND_API.G_MISS_NUM, p_purchasing_org_id,

3277: 'WHERE po_header_id =:po_header_id ' ||
3278: 'AND organization_id =:organization_id '
3279: USING p_enabled_flag, FND_API.G_MISS_CHAR, p_enabled_flag,
3280: p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
3281: p_purchasing_org_id, FND_API.G_MISS_NUM, p_purchasing_org_id,
3282: p_po_header_id, p_organization_id;
3283:
3284: xErrLoc:= 400;
3285: COMMIT;