APPS.INV_CONSIGNED_VALIDATIONS dependencies on DBMS_SQL

Line 877: l_cursor := dbms_sql.open_cursor;

873: l_err VARCHAR2(240);
874: l_pos NUMBER;
875: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
876: BEGIN
877: l_cursor := dbms_sql.open_cursor;
878: IF (l_debug = 1) THEN
879: inv_log_util.trace('Inside Build Cursor','CONSIGNED_VALIDATIONS',9);
880: END IF;
881:

Line 900: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);

896: END IF;
897:
898:
899: BEGIN
900: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
901: EXCEPTION
902: WHEN OTHERS THEN
903: l_last_error_pos := dbms_sql.last_error_position();
904: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);

Line 903: l_last_error_pos := dbms_sql.last_error_position();

899: BEGIN
900: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
901: EXCEPTION
902: WHEN OTHERS THEN
903: l_last_error_pos := dbms_sql.last_error_position();
904: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
905: RAISE;
906: END;
907: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);

Line 907: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);

903: l_last_error_pos := dbms_sql.last_error_position();
904: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
905: RAISE;
906: END;
907: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
908: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
909:
910: -- invConv changes begin
911: IF (p_grade_code IS NOT NULL AND p_grade_code <> '')

Line 908: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);

904: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
905: RAISE;
906: END;
907: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
908: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
909:
910: -- invConv changes begin
911: IF (p_grade_code IS NOT NULL AND p_grade_code <> '')
912: THEN

Line 913: dbms_sql.bind_variable(l_cursor, ':grade_code', p_grade_code);

909:
910: -- invConv changes begin
911: IF (p_grade_code IS NOT NULL AND p_grade_code <> '')
912: THEN
913: dbms_sql.bind_variable(l_cursor, ':grade_code', p_grade_code);
914: END IF;
915: -- invConv changes end
916:
917: -- Bug 2824557, Remove the reference to demand_source_line_id

Line 921: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id'

917: -- Bug 2824557, Remove the reference to demand_source_line_id
918: -- Because consign quantity does not care of PJM unit numbers
919: /*IF p_mode IN (g_loose_only_mode) OR
920: g_unit_eff_enabled = 'Y' THEN
921: dbms_sql.bind_variable(l_cursor, ':demand_source_line_id'
922: , p_demand_source_line_id);
923: END IF;*/
924:
925: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN

Line 926: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'

922: , p_demand_source_line_id);
923: END IF;*/
924:
925: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN
926: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'
927: , p_lot_expiration_date);
928: END IF;
929: x_cursor := l_cursor;
930: x_return_status := l_return_status;

Line 1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);

1056: END IF;
1057:
1058:
1059:
1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);
1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);

Line 1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);

1057:
1058:
1059:
1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);
1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);

Line 1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);

1058:
1059:
1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);
1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);

Line 1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);

1059:
1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);
1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);

Line 1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);

1060: dbms_sql.define_column(l_cursor, 1,l_organization_id);
1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);

Line 1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);

1061: dbms_sql.define_column(l_cursor, 2,l_inventory_item_id);
1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change

Line 1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);

1062: dbms_sql.define_column(l_cursor, 3,l_revision,3);
1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number

Line 1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);

1063: dbms_sql.define_column(l_cursor, 4,l_lot_number,30);
1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number

Line 1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);

1064: dbms_sql.define_column(l_cursor, 5,l_lot_expiration_date);
1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number

Line 1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change

1065: dbms_sql.define_column(l_cursor, 6,l_subinventory_code,10);
1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number

Line 1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number

1066: dbms_sql.define_column(l_cursor, 7,l_reservable_type);
1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number

Line 1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number

1067: dbms_sql.define_column(l_cursor, 8,l_locator_id);
1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number

Line 1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number

1068: dbms_sql.define_column(l_cursor, 9,l_primary_quantity);
1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:

Line 1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number

1069: dbms_sql.define_column(l_cursor,10,l_secondary_quantity); -- invConv change
1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:
1077: l_dummy := dbms_sql.execute(l_cursor);

Line 1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number

1070: dbms_sql.define_column(l_cursor,11,l_date_received); -- invConv renamed order number
1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:
1077: l_dummy := dbms_sql.execute(l_cursor);
1078: LOOP

Line 1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number

1071: dbms_sql.define_column(l_cursor,12,l_quantity_type); -- invConv renamed order number
1072: dbms_sql.define_column(l_cursor,13,l_cost_group_id); -- invConv renamed order number
1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:
1077: l_dummy := dbms_sql.execute(l_cursor);
1078: LOOP
1079: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

Line 1077: l_dummy := dbms_sql.execute(l_cursor);

1073: dbms_sql.define_column(l_cursor,14,l_containerized); -- invConv renamed order number
1074: dbms_sql.define_column(l_cursor,15,l_planning_organization_id); -- invConv renamed order number
1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:
1077: l_dummy := dbms_sql.execute(l_cursor);
1078: LOOP
1079: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1080: EXIT;
1081: END IF;

Line 1079: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

1075: dbms_sql.define_column(l_cursor,16,l_owning_organization_id); -- invConv renamed order number
1076:
1077: l_dummy := dbms_sql.execute(l_cursor);
1078: LOOP
1079: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1080: EXIT;
1081: END IF;
1082:
1083: l_count := l_count + 1;

Line 1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);

1083: l_count := l_count + 1;
1084: ll_transactable_vmi:= 0;
1085: ll_transactable_secondary_vmi:= 0; -- invConv change
1086:
1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);
1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);

Line 1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);

1084: ll_transactable_vmi:= 0;
1085: ll_transactable_secondary_vmi:= 0; -- invConv change
1086:
1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);
1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);

Line 1089: dbms_sql.column_value(l_cursor, 3,ll_revision);

1085: ll_transactable_secondary_vmi:= 0; -- invConv change
1086:
1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);
1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);

Line 1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);

1086:
1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);
1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);

Line 1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);

1087: dbms_sql.column_value(l_cursor, 1,ll_organization_id);
1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);

Line 1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);

1088: dbms_sql.column_value(l_cursor, 2,ll_inventory_item_id);
1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change

Line 1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);

1089: dbms_sql.column_value(l_cursor, 3,ll_revision);
1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number

Line 1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);

1090: dbms_sql.column_value(l_cursor, 4,ll_lot_number);
1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number

Line 1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);

1091: dbms_sql.column_value(l_cursor, 5,ll_lot_expiration_date);
1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number

Line 1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change

1092: dbms_sql.column_value(l_cursor, 6,ll_subinventory_code);
1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number

Line 1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number

1093: dbms_sql.column_value(l_cursor, 7,ll_reservable_type);
1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number

Line 1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number

1094: dbms_sql.column_value(l_cursor, 8,ll_locator_id);
1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number
1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number

Line 1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number

1095: dbms_sql.column_value(l_cursor, 9,ll_primary_quantity);
1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number
1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number
1103:

Line 1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number

1096: dbms_sql.column_value(l_cursor,10,ll_secondary_quantity); -- InvConv change
1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number
1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number
1103:
1104: IF (p_qty_tree_att<=ll_primary_quantity)THEN

Line 1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number

1097: dbms_sql.column_value(l_cursor,11,ll_date_received); -- invConv renamed order number
1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number
1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number
1103:
1104: IF (p_qty_tree_att<=ll_primary_quantity)THEN
1105: ll_transactable_vmi:=p_qty_tree_att;

Line 1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number

1098: dbms_sql.column_value(l_cursor,12,ll_quantity_type); -- invConv renamed order number
1099: dbms_sql.column_value(l_cursor,13,ll_cost_group_id); -- invConv renamed order number
1100: dbms_sql.column_value(l_cursor,14,ll_containerized); -- invConv renamed order number
1101: dbms_sql.column_value(l_cursor,15,ll_planning_organization_id); -- invConv renamed order number
1102: dbms_sql.column_value(l_cursor,16,ll_owning_organization_id); -- invConv renamed order number
1103:
1104: IF (p_qty_tree_att<=ll_primary_quantity)THEN
1105: ll_transactable_vmi:=p_qty_tree_att;
1106: ll_transactable_secondary_vmi:=p_qty_tree_satt; -- InvConv change

Line 1153: dbms_sql.close_cursor(l_cursor);

1149: ll_containerized,
1150: ll_planning_organization_id,
1151: ll_owning_organization_id);
1152: END LOOP;
1153: dbms_sql.close_cursor(l_cursor);
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (l_debug = 1) THEN
1157: inv_log_util.trace('When others Ex. in Inserting in temp table','CONSIGNED_VALIDATIONS',9);

Line 3842: l_cursor := dbms_sql.open_cursor;

3838: l_err VARCHAR2(240);
3839: l_pos NUMBER;
3840: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3841: BEGIN
3842: l_cursor := dbms_sql.open_cursor;
3843: IF (l_debug = 1) THEN
3844: inv_log_util.trace('Inside build_lpn_cursor','CONSIGNED_VALIDATIONS',9);
3845: END IF;
3846:

Line 3863: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);

3859: RAISE fnd_api.g_exc_unexpected_error;
3860: END IF;
3861:
3862: BEGIN
3863: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
3864: EXCEPTION
3865: WHEN OTHERS THEN
3866: l_last_error_pos := dbms_sql.last_error_position();
3867: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);

Line 3866: l_last_error_pos := dbms_sql.last_error_position();

3862: BEGIN
3863: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);
3864: EXCEPTION
3865: WHEN OTHERS THEN
3866: l_last_error_pos := dbms_sql.last_error_position();
3867: l_temp_str := Substr(l_sql, l_last_error_pos-5, 30);
3868: RAISE;
3869: END;
3870:

Line 3874: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);

3870:
3871: IF (l_debug = 1) THEN
3872: inv_log_util.trace('p_lpn_id:'||p_lpn_id||',org :'||p_organization_id ||',item:'|| p_inventory_item_id,'CONSIGNED_VALIDATIONS',9);
3873: END IF;
3874: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );
3877:
3878: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN

Line 3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);

3871: IF (l_debug = 1) THEN
3872: inv_log_util.trace('p_lpn_id:'||p_lpn_id||',org :'||p_organization_id ||',item:'|| p_inventory_item_id,'CONSIGNED_VALIDATIONS',9);
3873: END IF;
3874: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );
3877:
3878: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN
3879: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'

Line 3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );

3872: inv_log_util.trace('p_lpn_id:'||p_lpn_id||',org :'||p_organization_id ||',item:'|| p_inventory_item_id,'CONSIGNED_VALIDATIONS',9);
3873: END IF;
3874: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );
3877:
3878: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN
3879: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'
3880: , p_lot_expiration_date);

Line 3879: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'

3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );
3877:
3878: IF p_is_lot_control AND p_lot_expiration_date IS NOT NULL THEN
3879: dbms_sql.bind_variable(l_cursor, ':lot_expiration_date'
3880: , p_lot_expiration_date);
3881: END IF;
3882: x_cursor := l_cursor;
3883: x_return_status := l_return_status;

Line 3981: dbms_sql.define_column(l_cursor,1,l_organization_id);

3977: l_return_status:= fnd_api.g_ret_sts_error;
3978: RAISE fnd_api.g_exc_unexpected_error;
3979: END IF;
3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);

Line 3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);

3978: RAISE fnd_api.g_exc_unexpected_error;
3979: END IF;
3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);

Line 3983: dbms_sql.define_column(l_cursor,3,l_revision,3);

3979: END IF;
3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);

Line 3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);

3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);

Line 3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);

3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);

Line 3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);

3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);
3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);

Line 3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);

3983: dbms_sql.define_column(l_cursor,3,l_revision,3);
3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);

Line 3988: dbms_sql.define_column(l_cursor,8,l_locator_id);

3984: dbms_sql.define_column(l_cursor,4,l_lot_number,30);
3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);

Line 3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);

3985: dbms_sql.define_column(l_cursor,5,l_lot_expiration_date);
3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);

Line 3990: dbms_sql.define_column(l_cursor,10,l_date_received);

3986: dbms_sql.define_column(l_cursor,6,l_subinventory_code,10);
3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);

Line 3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);

3987: dbms_sql.define_column(l_cursor,7,l_reservable_type);
3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);

Line 3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);

3988: dbms_sql.define_column(l_cursor,8,l_locator_id);
3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);
3996:

Line 3993: dbms_sql.define_column(l_cursor,13,l_containerized);

3989: dbms_sql.define_column(l_cursor,9,l_primary_quantity);
3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);
3996:
3997: l_dummy := dbms_sql.execute(l_cursor);

Line 3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);

3990: dbms_sql.define_column(l_cursor,10,l_date_received);
3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);
3996:
3997: l_dummy := dbms_sql.execute(l_cursor);
3998:

Line 3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);

3991: dbms_sql.define_column(l_cursor,11,l_quantity_type);
3992: dbms_sql.define_column(l_cursor,12,l_cost_group_id);
3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);
3996:
3997: l_dummy := dbms_sql.execute(l_cursor);
3998:
3999: LOOP

Line 3997: l_dummy := dbms_sql.execute(l_cursor);

3993: dbms_sql.define_column(l_cursor,13,l_containerized);
3994: dbms_sql.define_column(l_cursor,14,l_planning_organization_id);
3995: dbms_sql.define_column(l_cursor,15,l_owning_organization_id);
3996:
3997: l_dummy := dbms_sql.execute(l_cursor);
3998:
3999: LOOP
4000:
4001: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

Line 4001: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

3997: l_dummy := dbms_sql.execute(l_cursor);
3998:
3999: LOOP
4000:
4001: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
4002: EXIT;
4003: END IF;
4004:
4005: l_count := l_count + 1;

Line 4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);

4004:
4005: l_count := l_count + 1;
4006: ll_transactable_vmi:= 0;
4007:
4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);
4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);

Line 4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);

4005: l_count := l_count + 1;
4006: ll_transactable_vmi:= 0;
4007:
4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);
4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);

Line 4010: dbms_sql.column_value(l_cursor,3,ll_revision);

4006: ll_transactable_vmi:= 0;
4007:
4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);
4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);

Line 4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);

4007:
4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);
4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);

Line 4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);

4008: dbms_sql.column_value(l_cursor,1,ll_organization_id);
4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);

Line 4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);

4009: dbms_sql.column_value(l_cursor,2,ll_inventory_item_id);
4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);

Line 4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);

4010: dbms_sql.column_value(l_cursor,3,ll_revision);
4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);

Line 4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);

4011: dbms_sql.column_value(l_cursor,4,ll_lot_number);
4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);

Line 4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);

4012: dbms_sql.column_value(l_cursor,5,ll_lot_expiration_date);
4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);

Line 4017: dbms_sql.column_value(l_cursor,10,ll_date_received);

4013: dbms_sql.column_value(l_cursor,6,ll_subinventory_code);
4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);

Line 4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);

4014: dbms_sql.column_value(l_cursor,7,ll_reservable_type);
4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);
4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);

Line 4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);

4015: dbms_sql.column_value(l_cursor,8,ll_locator_id);
4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);
4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);
4023:

Line 4020: dbms_sql.column_value(l_cursor,13,ll_containerized);

4016: dbms_sql.column_value(l_cursor,9,ll_primary_quantity);
4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);
4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);
4023:
4024: IF (p_qty_tree_att<=ll_primary_quantity)THEN

Line 4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);

4017: dbms_sql.column_value(l_cursor,10,ll_date_received);
4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);
4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);
4023:
4024: IF (p_qty_tree_att<=ll_primary_quantity)THEN
4025: ll_transactable_vmi:=p_qty_tree_att;

Line 4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);

4018: dbms_sql.column_value(l_cursor,11,ll_quantity_type);
4019: dbms_sql.column_value(l_cursor,12,ll_cost_group_id);
4020: dbms_sql.column_value(l_cursor,13,ll_containerized);
4021: dbms_sql.column_value(l_cursor,14,ll_planning_organization_id);
4022: dbms_sql.column_value(l_cursor,15,ll_owning_organization_id);
4023:
4024: IF (p_qty_tree_att<=ll_primary_quantity)THEN
4025: ll_transactable_vmi:=p_qty_tree_att;
4026: ELSE

Line 4069: dbms_sql.close_cursor(l_cursor);

4065:
4066: IF (l_debug = 1) THEN
4067: inv_log_util.trace('#of records inserted into mtl_consigned_qty_temp :'||l_count,'CONSIGNED_VALIDATIONS',9);
4068: END IF;
4069: dbms_sql.close_cursor(l_cursor);
4070: EXCEPTION
4071: WHEN OTHERS THEN
4072: IF (l_debug = 1) THEN
4073: inv_log_util.trace('When others Ex. in populate_lpn_temp','CONSIGNED_VALIDATIONS',9);