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.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

1259: /* pricing attribute specific tab types */
1260:
1261:
1262:
1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

Line 1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;

1260:
1261:
1262:
1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

1261:
1262:
1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

1262:
1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

1263: type attr_creation_date_tab is table of QP_PRICING_ATTRIBUTES.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

1264: type attr_created_by_tab is table of QP_PRICING_ATTRIBUTES.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;

1265: type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

1266: type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;

1267: type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

Line 1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

1268: type attr_program_appl_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

Line 1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;

1269: type attr_program_id_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;

1270: type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

1271: type attr_request_id_tab is table of QP_PRICING_ATTRIBUTES.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

1272: type attr_list_line_id_tab is table of QP_PRICING_ATTRIBUTES.LIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

Line 1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;

1273: type attr_excluder_flag_tab is table of QP_PRICING_ATTRIBUTES.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

Line 1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

1274: type attr_accumulate_flag_tab is table of QP_PRICING_ATTRIBUTES.ACCUMULATE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;

1275: type attr_product_attr_context_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

Line 1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

1276: type attr_product_attribute_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

Line 1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

1277: type attr_product_attr_value_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
1285: type agr_prc_list_tab is table of NUMBER index by binary_integer;

Line 1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

1278: type attr_product_uom_code_tab is table of QP_PRICING_ATTRIBUTES.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
1285: type agr_prc_list_tab is table of NUMBER index by binary_integer;
1286: type agr_list_header_tab is table of NUMBER index by binary_integer;

Line 1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

1279: type attr_comparison_operator_tab is table of QP_PRICING_ATTRIBUTES.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
1285: type agr_prc_list_tab is table of NUMBER index by binary_integer;
1286: type agr_list_header_tab is table of NUMBER index by binary_integer;
1287: type agr_type_tab is table of VARCHAR2(3) index by binary_integer;

Line 1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

1280: type attr_pricing_context_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
1281: type attr_pricing_attr_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
1282: type attr_pricing_attr_val_from_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
1283: type attr_pricing_attr_val_to_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
1284: type attr_prc_datatype_tab is table of QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
1285: type agr_prc_list_tab is table of NUMBER index by binary_integer;
1286: type agr_list_header_tab is table of NUMBER index by binary_integer;
1287: type agr_type_tab is table of VARCHAR2(3) index by binary_integer;
1288: TYPE qualification_ind_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2058: /* added attr_count := attr_count + 1 to create an extra record containing only product in qp_pricing_attributes. This is because of Honeywell Bug # 1731134 - vgulati */

2054: l_pricing_context := 'Upgrade Context';
2055:
2056: end if;
2057:
2058: /* added attr_count := attr_count + 1 to create an extra record containing only product in qp_pricing_attributes. This is because of Honeywell Bug # 1731134 - vgulati */
2059:
2060: If pricing_attribute1s(K) is not null then
2061: attr_count := attr_count + 1;
2062: attr_creation_dates(attr_count) := creation_dates(K);

Line 2838: INSERT INTO QP_PRICING_ATTRIBUTES

2834:
2835: BEGIN
2836:
2837: FORALL J IN 1..attr_count
2838: INSERT INTO QP_PRICING_ATTRIBUTES
2839: (PRICING_ATTRIBUTE_ID,
2840: CREATION_DATE,
2841: CREATED_BY,
2842: LAST_UPDATE_DATE,

Line 2870: QP_PRICING_ATTRIBUTES_S.nextval,

2866: ,ORIG_SYS_LINE_REF
2867: ,ORIG_SYS_HEADER_REF)
2868: VALUES
2869: (
2870: QP_PRICING_ATTRIBUTES_S.nextval,
2871: attr_creation_dates(J),
2872: attr_created_bys(J),
2873: attr_last_update_dates(J),
2874: attr_last_updated_bys(J),

Line 2896: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)

2892: attr_comparison_operator_codes(J),
2893: prc_datatypes(J),
2894: l_prod_datatype
2895: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2896: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
2897: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2898: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2899: );
2900: