69:
70: -- if Kanban Card Id exists in the distribution,
71: -- Call INV API to update the Kanban Card Status to 'IN PROCESS'
72:
73: INV_Kanban_PVT.Update_Card_Supply_Status
74: (p_kanban_return_status,
75: l_kanban_card_id,
76: INV_Kanban_PVT.G_Supply_Status_InProcess,
77: INV_Kanban_PVT.G_doc_type_PO,
72:
73: INV_Kanban_PVT.Update_Card_Supply_Status
74: (p_kanban_return_status,
75: l_kanban_card_id,
76: INV_Kanban_PVT.G_Supply_Status_InProcess,
77: INV_Kanban_PVT.G_doc_type_PO,
78: p_document_id,
79: l_distribution_id);
80:
73: INV_Kanban_PVT.Update_Card_Supply_Status
74: (p_kanban_return_status,
75: l_kanban_card_id,
76: INV_Kanban_PVT.G_Supply_Status_InProcess,
77: INV_Kanban_PVT.G_doc_type_PO,
78: p_document_id,
79: l_distribution_id);
80:
81: END LOOP;
99:
100: -- if Kanban Card Id exists in the distribution,
101: -- Call INV API to update the Kanban Card Status to 'IN PROCESS'
102:
103: INV_Kanban_PVT.Update_Card_Supply_Status
104: (p_kanban_return_status,
105: l_kanban_card_id,
106: INV_Kanban_PVT.G_Supply_Status_InProcess,
107: INV_Kanban_PVT.G_doc_type_release,
102:
103: INV_Kanban_PVT.Update_Card_Supply_Status
104: (p_kanban_return_status,
105: l_kanban_card_id,
106: INV_Kanban_PVT.G_Supply_Status_InProcess,
107: INV_Kanban_PVT.G_doc_type_release,
108: p_document_id,
109: l_distribution_id);
110:
103: INV_Kanban_PVT.Update_Card_Supply_Status
104: (p_kanban_return_status,
105: l_kanban_card_id,
106: INV_Kanban_PVT.G_Supply_Status_InProcess,
107: INV_Kanban_PVT.G_doc_type_release,
108: p_document_id,
109: l_distribution_id);
110:
111: END LOOP;
129:
130: -- if Kanban Card Id exists in the internal requisition line,
131: -- Call INV API to update the Kanban Card Status to 'IN PROCESS'
132:
133: INV_Kanban_PVT.Update_Card_Supply_Status
134: (p_kanban_return_status,
135: l_kanban_card_id,
136: INV_Kanban_PVT.G_Supply_Status_InProcess,
137: INV_Kanban_PVT.G_doc_type_Internal_Req,
132:
133: INV_Kanban_PVT.Update_Card_Supply_Status
134: (p_kanban_return_status,
135: l_kanban_card_id,
136: INV_Kanban_PVT.G_Supply_Status_InProcess,
137: INV_Kanban_PVT.G_doc_type_Internal_Req,
138: p_document_id,
139: l_req_line_id);
140:
133: INV_Kanban_PVT.Update_Card_Supply_Status
134: (p_kanban_return_status,
135: l_kanban_card_id,
136: INV_Kanban_PVT.G_Supply_Status_InProcess,
137: INV_Kanban_PVT.G_doc_type_Internal_Req,
138: p_document_id,
139: l_req_line_id);
140:
141: END LOOP;
180: BEGIN
181:
182: dbms_output.put_line ('Start Update_Card_Status_Full ');
183:
184: INV_KANBAN_PVT.UPDATE_CARD_SUPPLY_STATUS
185: (p_kanban_return_status,
186: p_kanban_card_ID,
187: INV_KANBAN_PVT.G_SUPPLY_STATUS_FULL);
188:
183:
184: INV_KANBAN_PVT.UPDATE_CARD_SUPPLY_STATUS
185: (p_kanban_return_status,
186: p_kanban_card_ID,
187: INV_KANBAN_PVT.G_SUPPLY_STATUS_FULL);
188:
189: dbms_output.put_line ('End Update_Card_Status_Full ');
190:
191: EXCEPTION