1437: Return TRUE;
1438: else
1439: begin
1440: select 'x' into l_dummy
1441: from mtl_kanban_card_activity
1442: where kanban_card_id = p_kanban_id
1443: and organization_id = p_org_id
1444: and document_header_id = p_wip_entity_id
1445: and source_type = INV_KANBAN_PVT.G_Source_Type_Production
4172: CURSOR mtl_kca IS
4173: SELECT replenishment_cycle_id
4174: , document_header_id
4175: , document_detail_id
4176: FROM mtl_kanban_card_activity
4177: WHERE kanban_card_id = p_kanban_card_id
4178: AND document_header_id IS NOT NULL
4179: ORDER BY kanban_activity_id DESC;
4180:
4208: SELECT document_type
4209: , replenishment_cycle_id
4210: INTO l_doc_type_id
4211: , l_max_rep_id
4212: FROM mtl_kanban_card_activity
4213: WHERE kanban_card_id = p_kanban_card_id
4214: AND document_type IS NOT NULL
4215: AND document_type <> fnd_api.g_miss_num
4216: AND replenishment_cycle_id = (SELECT MAX(replenishment_cycle_id)
4213: WHERE kanban_card_id = p_kanban_card_id
4214: AND document_type IS NOT NULL
4215: AND document_type <> fnd_api.g_miss_num
4216: AND replenishment_cycle_id = (SELECT MAX(replenishment_cycle_id)
4217: FROM mtl_kanban_card_activity
4218: WHERE kanban_card_id = p_kanban_card_id);
4219: EXCEPTION
4220: WHEN TOO_MANY_ROWS THEN
4221: mydebug('Multiple document types and maximum replenishment cycle id returned for kanban card Id ' || p_kanban_card_id||' ;Hence disallowing Supply status update');
4307:
4308: IF ( p_document_detail_Id IS NOT NULL AND p_document_header_id IS NOT NULL) THEN
4309: BEGIN
4310: SELECT 1 INTO l_req
4311: FROM mtl_kanban_card_activity
4312: WHERE kanban_card_id = p_kanban_card_id AND
4313: document_detail_Id = p_document_detail_Id AND
4314: Document_header_id = p_Document_header_id;
4315: EXCEPTION