APPS.WIP_FLOW_COMPLETION_FILTER dependencies on DBMS_SQL

Line 65: l_cursor_id := dbms_sql.open_cursor;

61: l_stmt := l_stmt || ' AND ' || i_where ;
62: l_stmt := l_stmt || ' order by build_sequence, schedule_number ';
63:
64:
65: l_cursor_id := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);

Line 66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);

62: l_stmt := l_stmt || ' order by build_sequence, schedule_number ';
63:
64:
65: l_cursor_id := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);

Line 67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);

63:
64:
65: l_cursor_id := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);

Line 68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);

64:
65: l_cursor_id := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);

Line 69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);

65: l_cursor_id := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);

Line 70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);

66: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.v7);
67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);

Line 71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);

67: dbms_sql.define_column(l_cursor_id, 1, l_primary_item_id);
68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);

Line 72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);

68: dbms_sql.define_column(l_cursor_id, 2, l_wip_entity_id);
69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);
76: l_dummy := dbms_sql.execute(l_cursor_id);

Line 73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);

69: dbms_sql.define_column(l_cursor_id, 3, l_org_id);
70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);
76: l_dummy := dbms_sql.execute(l_cursor_id);
77:

Line 74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);

70: dbms_sql.define_column(l_cursor_id, 4, l_completion_subinventory, 10);
71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);
76: l_dummy := dbms_sql.execute(l_cursor_id);
77:
78: -- This will be set to true if the item has resricted subinventory/locator,

Line 75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);

71: dbms_sql.define_column(l_cursor_id, 5, l_completion_locator);
72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);
76: l_dummy := dbms_sql.execute(l_cursor_id);
77:
78: -- This will be set to true if the item has resricted subinventory/locator,
79: -- and the subinventory/locator given from the default or routing

Line 76: l_dummy := dbms_sql.execute(l_cursor_id);

72: dbms_sql.define_column(l_cursor_id, 6, l_alt_routing_designator, 10);
73: dbms_sql.define_column(l_cursor_id, 7, l_project_id);
74: dbms_sql.define_column(l_cursor_id, 8, l_task_id);
75: dbms_sql.define_column(l_cursor_id, 9, l_cur_qty);
76: l_dummy := dbms_sql.execute(l_cursor_id);
77:
78: -- This will be set to true if the item has resricted subinventory/locator,
79: -- and the subinventory/locator given from the default or routing
80: -- doesn't match. That record will not be returned in the result table.

Line 93: WHILE dbms_sql.fetch_rows(l_cursor_id) > 0 LOOP

89:
90: -- Total quantity eligible to be completed.
91: l_tot_qty := 0;
92:
93: WHILE dbms_sql.fetch_rows(l_cursor_id) > 0 LOOP
94: -- This is to indicate resricted subinventory/locator error for
95: -- the current record.
96: l_cur_restrict_error := false;
97:

Line 101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);

97:
98: -- This is to indicate lot/serial control error for the current record.
99: l_cur_lot_serial_error := false;
100:
101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);
102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);

Line 102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);

98: -- This is to indicate lot/serial control error for the current record.
99: l_cur_lot_serial_error := false;
100:
101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);
102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);

Line 103: dbms_sql.column_value(l_cursor_id,3, l_org_id);

99: l_cur_lot_serial_error := false;
100:
101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);
102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);

Line 104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);

100:
101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);
102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);

Line 105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);

101: dbms_sql.column_value(l_cursor_id,1, l_primary_item_id);
102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);
109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);

Line 106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);

102: dbms_sql.column_value(l_cursor_id,2, l_wip_entity_id);
103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);
109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);
110:

Line 107: dbms_sql.column_value(l_cursor_id,7, l_project_id);

103: dbms_sql.column_value(l_cursor_id,3, l_org_id);
104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);
109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);
110:
111:

Line 108: dbms_sql.column_value(l_cursor_id,8, l_task_id);

104: dbms_sql.column_value(l_cursor_id,4, l_completion_subinventory);
105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);
109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);
110:
111:
112: -- Derive the sub/loc from the routing if none is specified in

Line 109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);

105: dbms_sql.column_value(l_cursor_id,5, l_completion_locator);
106: dbms_sql.column_value(l_cursor_id,6, l_alt_routing_designator);
107: dbms_sql.column_value(l_cursor_id,7, l_project_id);
108: dbms_sql.column_value(l_cursor_id,8, l_task_id);
109: dbms_sql.column_value(l_cursor_id,9, l_cur_qty);
110:
111:
112: -- Derive the sub/loc from the routing if none is specified in
113: -- the flow schedule.