eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_DELIVERABLE_UTILS_PUB dependencies on OKE_DELIVERABLE_ACTIONS

Line 32: FROM oke_deliverable_actions

28: RETURN VARCHAR2 IS
29:
30: CURSOR c IS
31: SELECT reference2
32: FROM oke_deliverable_actions
33: WHERE pa_action_id = p_action_id
34: AND action_type = 'WSH';
35:
36: L_Ref_2 NUMBER;

Line 81: FROM oke_deliverable_actions

77: RETURN VARCHAR2 IS
78:
79: CURSOR c IS
80: SELECT reference1
81: FROM oke_deliverable_actions
82: WHERE pa_action_id = p_action_id
83: AND action_type = 'WSH';
84:
85: L_Ref_1 NUMBER;

Line 135: FROM oke_deliverable_actions a, oke_deliverables_b d

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:

Line 245: FROM oke_deliverable_actions

241: RETURN VARCHAR2 IS
242:
243: CURSOR c IS
244: SELECT NVL(ready_flag, 'N')
245: FROM oke_deliverable_actions
246: WHERE pa_action_id = p_action_id
247: AND action_type = 'WSH';
248:
249: L_Value VARCHAR2(1);

Line 289: FROM oke_deliverable_actions

285: FUNCTION Ready_To_Procure_Yn ( P_Action_ID NUMBER)
286: RETURN VARCHAR2 IS
287: CURSOR c IS
288: SELECT NVL(ready_flag, 'N'), reference1
289: FROM oke_deliverable_actions
290: WHERE pa_action_id = p_action_id
291: AND action_type = 'REQ';
292:
293: CURSOR d IS

Line 490: FROM oke_deliverable_actions

486: BEGIN
487:
488: SELECT 1
489: INTO dummy
490: FROM oke_deliverable_actions
491: WHERE pa_action_id = p_action_id
492: AND reference1 > 0
493: AND NOT EXISTS ( SELECT 1
494: FROM po_requisitions_interface_all

Line 776: INSERT INTO oke_deliverable_actions (

772: FETCH c INTO L_Deliverable_ID, l_currency_code, l_inventory_org_id,
773: l_unit_price, l_uom_code, l_quantity, l_Item_Based_YN;
774: CLOSE C;
775:
776: INSERT INTO oke_deliverable_actions (
777: action_id
778: , creation_date
779: , created_by
780: , last_update_date

Line 852: FROM oke_deliverable_actions

848: , Decode( l_Item_Based_YN, 'Y', l_unit_price, unit_price)
849: , Decode( l_Item_Based_YN, 'Y', l_currency_code, currency_code)
850: , Decode( l_Item_Based_YN, 'Y', l_quantity, quantity)
851: , Decode( l_Item_Based_YN, 'Y', l_uom_code, uom_code)
852: FROM oke_deliverable_actions
853: WHERE pa_action_id = p_source_action_id;
854:
855: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
856: , X_Msg_Data => X_Msg_Data );

Line 910: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Action ( P_Action_ID );

906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;
909:
910: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Action ( P_Action_ID );
911:
912: X_Return_Status := L_Return_Status;
913: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
914: , X_Msg_Data => X_Msg_Data );

Line 967: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Row ( P_Action_ID );

963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: END IF;
966:
967: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Row ( P_Action_ID );
968:
969: X_Return_Status := L_Return_Status;
970: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
971: , X_Msg_Data => X_Msg_Data );

Line 1024: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Deliverable ( P_Deliverable_ID );

1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Deliverable ( P_Deliverable_ID );
1025:
1026: X_Return_Status := L_Return_Status;
1027: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
1028: , X_Msg_Data => X_Msg_Data );

Line 1116: , oke_deliverable_actions a

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
1120: AND b.quantity > 0

Line 1132: , oke_deliverable_actions a

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
1136: AND b.item_id > 0

Line 1149: , oke_deliverable_actions a

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
1153: AND b.item_id > 0

Line 1187: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c1rec.action_id

1183:
1184: IF P_Project_ID IS NULL THEN
1185: FOR c1rec IN c1 LOOP
1186:
1187: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c1rec.action_id
1188: , 'F'
1189: , L_ID
1190: , L_Return_Status
1191: , L_Msg_Count

Line 1199: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c2rec.action_id

1195: END IF;
1196: END LOOP;
1197: ELSIF P_Project_ID > 0 AND P_Task_ID IS NULL THEN
1198: FOR c2rec IN c2 LOOP
1199: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c2rec.action_id
1200: , 'F'
1201: , L_ID
1202: , L_Return_Status
1203: , L_Msg_Count

Line 1211: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c3rec.action_id

1207: END IF;
1208: END LOOP;
1209: ELSIF P_Task_ID > 0 THEN
1210: FOR c3rec IN c3 LOOP
1211: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand ( c3rec.action_id
1212: , 'F'
1213: , L_ID
1214: , L_Return_Status
1215: , L_Msg_Count

Line 1273: , oke_deliverable_actions a

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 (
1277: SELECT 1

Line 1291: , oke_deliverable_actions a

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
1295: AND ( a.reference1 is null OR EXISTS (

Line 1310: , oke_deliverable_actions a

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
1314: AND ( a.reference1 is null OR EXISTS (

Line 1351: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c1rec.action_id

1347:
1348: IF P_Project_ID IS NULL THEN
1349: FOR c1rec IN c1 LOOP
1350:
1351: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c1rec.action_id
1352: , 'T'
1353: , L_ID
1354: , L_Return_Status
1355: , L_Msg_Count

Line 1363: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c2rec.action_id

1359: END IF;
1360: END LOOP;
1361: ELSIF P_Project_ID > 0 AND P_Task_ID IS NULL THEN
1362: FOR c2rec IN c2 LOOP
1363: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c2rec.action_id
1364: , 'T'
1365: , L_ID
1366: , L_Return_Status
1367: , L_Msg_Count

Line 1375: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c3rec.action_id

1371: END IF;
1372: END LOOP;
1373: ELSIF P_Task_ID > 0 THEN
1374: FOR c3rec IN c3 LOOP
1375: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition ( c3rec.action_id
1376: , 'T'
1377: , L_ID
1378: , L_Return_Status
1379: , L_Msg_Count

Line 1439: , oke_deliverable_actions a

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
1443: AND NVL ( a.ready_flag, 'N' ) = 'Y'

Line 1452: , oke_deliverable_actions a

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
1456: AND a.reference1 is null

Line 1466: , oke_deliverable_actions a

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
1470: AND a.reference1 is null

Line 1502: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c1rec.action_id

1498:
1499: IF P_Project_ID IS NULL THEN
1500: FOR c1rec IN c1 LOOP
1501:
1502: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c1rec.action_id
1503: , 'F'
1504: , L_ID
1505: , L_Return_Status
1506: , L_Msg_Count

Line 1514: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c2rec.action_id

1510: END IF;
1511: END LOOP;
1512: ELSIF P_Project_ID > 0 AND P_Task_ID IS NULL THEN
1513: FOR c2rec IN c2 LOOP
1514: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c2rec.action_id
1515: , 'F'
1516: , L_ID
1517: , L_Return_Status
1518: , L_Msg_Count

Line 1526: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c3rec.action_id

1522: END IF;
1523: END LOOP;
1524: ELSIF P_Task_ID > 0 THEN
1525: FOR c3rec IN c3 LOOP
1526: OKE_DELIVERABLE_ACTIONS_PKG.Create_Shipment ( c3rec.action_id
1527: , 'F'
1528: , L_ID
1529: , L_Return_Status
1530: , L_Msg_Count

Line 1630: INSERT INTO oke_deliverable_actions (

1626: OPEN c;
1627: FETCH c INTO L_Deliverable_ID;
1628: CLOSE c;
1629:
1630: INSERT INTO oke_deliverable_actions (
1631: ACTION_ID
1632: , CREATION_DATE
1633: , CREATED_BY
1634: , LAST_UPDATE_DATE

Line 1665: FROM oke_deliverable_actions

1661: FUNCTION Task_Used_In_Wsh ( P_Task_ID NUMBER ) RETURN VARCHAR2 IS
1662:
1663: CURSOR C IS
1664: SELECT G_Yes
1665: FROM oke_deliverable_actions
1666: WHERE task_id = p_task_id
1667: AND action_type = 'WSH'
1668: -- AND reference1 > 0 -- bug# 4007769 commented out
1669: ;

Line 1692: FROM oke_deliverable_actions

1688: FUNCTION Task_Used_In_Req ( P_Task_ID NUMBER ) RETURN VARCHAR2 IS
1689:
1690: CURSOR c IS
1691: SELECT G_Yes
1692: FROM oke_deliverable_actions
1693: WHERE task_id = p_task_id
1694: AND action_type = 'REQ'
1695: -- AND reference1 > 0 -- bug# 4007769 commented out
1696: ;