131: L_Flag VARCHAR2(1) := G_NO;
132:
133: CURSOR c IS
134: SELECT a.reference1, a.action_id, d.project_id
135: FROM oke_deliverable_actions a, oke_deliverables_b d
136: WHERE a.pa_action_id = p_action_id AND action_type = 'REQ'
137: AND d.deliverable_id = a.deliverable_id
138: ;
139:
199: L_Dummy NUMBER;
200:
201: CURSOR c IS
202: SELECT 1
203: FROM oke_deliverables_b
204: WHERE source_code = 'PA'
205: AND source_deliverable_id = p_deliverable_id
206: AND item_id > 0;
207:
354: SELECT NVL(shippable_item_flag, 'N')
355: FROM oke_system_items_v
356: WHERE id1 = (
357: SELECT item_id
358: FROM oke_deliverables_b
359: WHERE source_code = 'PA'
360: AND source_deliverable_id = p_deliverable_id );
361:
362: L_Value VARCHAR2(1);
403: SELECT NVL(invoiceable_item_flag, 'N')
404: FROM oke_system_items_v
405: WHERE id1 = (
406: SELECT item_id
407: FROM oke_deliverables_b
408: WHERE source_code = 'PA'
409: AND source_deliverable_id = p_deliverable_id );
410:
411: L_Value VARCHAR2(1);
451: SELECT NVL(purchasing_enabled_flag, 'N')
452: FROM oke_system_items_v
453: WHERE id1 = (
454: SELECT item_id
455: FROM oke_deliverables_b
456: WHERE source_code = 'PA'
457: AND source_deliverable_id = p_deliverable_id );
458:
459: L_Value VARCHAR2(1);
565: CLOSE c;
566:
567: IF NVL( P_Copy_Item_Details_Flag, 'N' ) = 'Y' THEN
568:
569: INSERT INTO oke_deliverables_b (
570: deliverable_id
571: , creation_date
572: , created_by
573: , last_updated_by
606: , unit_price
607: , uom_code
608: , quantity
609: , unit_number
610: FROM oke_deliverables_b
611: WHERE source_code = 'PA'
612: AND source_header_id = p_source_project_id
613: AND source_deliverable_id = p_source_deliverable_id;
614:
613: AND source_deliverable_id = p_source_deliverable_id;
614:
615: ELSE
616:
617: INSERT INTO oke_deliverables_b (
618: deliverable_id
619: , creation_date
620: , created_by
621: , last_updated_by
640: , null
641: , p_target_deliverable_id
642: , p_target_project_id
643: , delivery_date
644: FROM oke_deliverables_b
645: WHERE source_code = 'PA'
646: AND source_header_id = p_source_project_id
647: AND source_deliverable_id = p_source_deliverable_id;
648: END IF;
736: CURSOR c IS
737: SELECT deliverable_id, currency_code, inventory_org_id,
738: unit_price, uom_code, quantity,
739: PA_DELIVERABLE_UTILS.IS_DLVR_ITEM_BASED(p_target_deliverable_id) Item_Based_YN
740: FROM oke_deliverables_b
741: WHERE source_code = 'PA'
742: AND source_header_id = p_target_project_id
743: AND source_deliverable_id = p_target_deliverable_id;
744:
1111: , X_Msg_Data OUT NOCOPY VARCHAR2 ) IS
1112:
1113: CURSOR c1 IS
1114: SELECT a.action_id
1115: FROM oke_deliverables_b b
1116: , oke_deliverable_actions a
1117: WHERE b.deliverable_id = a.deliverable_id
1118: AND a.reference2 is null
1119: AND b.item_id > 0
1127: c1rec c1%ROWTYPE;
1128:
1129: CURSOR c2 IS
1130: SELECT a.action_id
1131: FROM oke_deliverables_b b
1132: , oke_deliverable_actions a
1133: WHERE b.deliverable_id = a.deliverable_id
1134: AND a.reference2 is null
1135: AND b.project_id = p_project_id
1144: c2rec c1%ROWTYPE;
1145:
1146: CURSOR c3 IS
1147: SELECT a.action_id
1148: FROM oke_deliverables_b b
1149: , oke_deliverable_actions a
1150: WHERE b.deliverable_id = a.deliverable_id
1151: AND a.reference2 is null
1152: AND a.task_id = p_task_id
1268: , X_Msg_Data OUT NOCOPY VARCHAR2 ) IS
1269:
1270: CURSOR c1 IS
1271: SELECT a.action_id
1272: FROM oke_deliverables_b b
1273: , oke_deliverable_actions a
1274: WHERE b.deliverable_id = a.deliverable_id
1275: AND b.source_code = 'PA'
1276: AND ( a.reference1 is null OR EXISTS (
1286: c1rec c1%ROWTYPE;
1287:
1288: CURSOR c2 IS
1289: SELECT a.action_id
1290: FROM oke_deliverables_b b
1291: , oke_deliverable_actions a
1292: WHERE b.deliverable_id = a.deliverable_id
1293: AND b.source_code = 'PA'
1294: AND b.source_header_id = p_project_id
1305: c2rec c1%ROWTYPE;
1306:
1307: CURSOR c3 IS
1308: SELECT a.action_id
1309: FROM oke_deliverables_b b
1310: , oke_deliverable_actions a
1311: WHERE b.deliverable_id = a.deliverable_id
1312: AND b.source_code = 'PA'
1313: AND b.source_header_id = p_project_id
1434:
1435:
1436: CURSOR c1 IS
1437: SELECT a.action_id
1438: FROM oke_deliverables_b b
1439: , oke_deliverable_actions a
1440: WHERE b.deliverable_id = a.deliverable_id
1441: AND b.source_code = 'PA'
1442: AND a.reference1 is null
1447: c1rec c1%ROWTYPE;
1448:
1449: CURSOR c2 IS
1450: SELECT a.action_id
1451: FROM oke_deliverables_b b
1452: , oke_deliverable_actions a
1453: WHERE b.deliverable_id = a.deliverable_id
1454: AND b.source_code = 'PA'
1455: AND b.source_header_id = p_project_id
1461: c2rec c1%ROWTYPE;
1462:
1463: CURSOR c3 IS
1464: SELECT a.action_id
1465: FROM oke_deliverables_b b
1466: , oke_deliverable_actions a
1467: WHERE b.deliverable_id = a.deliverable_id
1468: AND b.source_code = 'PA'
1469: AND b.source_header_id = p_project_id
1581: L_Dummy NUMBER;
1582:
1583: CURSOR c IS
1584: SELECT 1
1585: FROM oke_deliverables_b
1586: WHERE source_code = 'PA'
1587: AND source_deliverable_id = p_deliverable_id
1588: AND item_id > 0;
1589:
1614: L_Deliverable_ID NUMBER;
1615:
1616: CURSOR c IS
1617: SELECT DELIVERABLE_ID
1618: FROM oke_deliverables_b
1619: WHERE SOURCE_CODE = P_SOURCE_CODE
1620: AND SOURCE_DELIVERABLE_ID = P_SOURCE_DELIVERABLE_ID;
1621:
1622: BEGIN