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_AMG_GRP dependencies on OKE_DELIVERABLE_ACTIONS

Line 986: from oke_deliverable_actions

982: and source_deliverable_id=p_dlv_rec.pa_deliverable_id;
983:
984: cursor c_check_action(b_del_id NUMBER) IS
985: SELECT 'x'
986: from oke_deliverable_actions
987: where deliverable_id= b_del_id
988: and reference1 > 0;
989: BEGIN
990:

Line 1150: update OKE_DELIVERABLE_actions

1146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1147:
1148: If p_item_dlv ='Y' then
1149:
1150: update OKE_DELIVERABLE_actions
1151: set
1152: CURRENCY_CODE = decode(action_type,G_REQ,p_dlv_rec.currency_code,currency_code),
1153: UNIT_PRICE = decode(action_type,G_REQ,p_dlv_rec.unit_price,unit_price),
1154: UOM_CODE = p_dlv_rec.uom_code,

Line 1169: OKE_DELIVERABLE_ACTIONS_PKG.delete_deliverable(p_dlv_rec.pa_deliverable_id);

1165: if p_action = G_DEL then
1166: if p_dlv_rec.pa_deliverable_id is null then
1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1168: end if;
1169: OKE_DELIVERABLE_ACTIONS_PKG.delete_deliverable(p_dlv_rec.pa_deliverable_id);
1170: end if;
1171: If fnd_api.to_boolean( p_commit ) then
1172: commit work;
1173: end if;

Line 1261: from oke_deliverable_actions act , oke_deliverables_b del

1257: cursor c_get_actions_ids(b_pa_action_id number) is
1258: Select act.action_id,
1259: act.deliverable_id,
1260: del.project_id
1261: from oke_deliverable_actions act , oke_deliverables_b del
1262: where act.deliverable_id = del.deliverable_id
1263: and pa_action_id= b_pa_action_id;
1264:
1265:

Line 1273: Select 'x' from oke_deliverable_actions

1269: from oke_deliverables_b
1270: where source_deliverable_id = b_pa_deliverable_id;
1271:
1272: Cursor c_get_action_status(b_action_id number) is
1273: Select 'x' from oke_deliverable_actions
1274: where action_id=b_action_id and reference1>0;
1275:
1276: Cursor c_get_inv_org(b_deliverable_id number) is
1277: select inventory_org_id from oke_deliverables_b where deliverable_id=b_deliverable_id;

Line 1374: OKE_DELIVERABLE_ACTIONS_PKG.Delete_action(l_pa_action_id);

1370: close c_get_action_status;
1371:
1372: If p_action = G_DEL then
1373: If OKE_DELIVERABLE_UTILS_PUB.Action_Deletable_Yn(l_pa_action_id)='Y' then
1374: OKE_DELIVERABLE_ACTIONS_PKG.Delete_action(l_pa_action_id);
1375: else
1376: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',
1377: p_token1 =>'PROJECT_NAME',
1378: p_token1_value =>l_project_name,

Line 1494: Insert into oke_deliverable_actions(ACTION_ID,

1490:
1491: If p_action=G_CRT then
1492:
1493: Select oke_k_deliverables_S.nextval into l_action_id from dual;
1494: Insert into oke_deliverable_actions(ACTION_ID,
1495: CREATION_DATE,
1496: CREATED_BY ,
1497: LAST_UPDATE_DATE,
1498: LAST_UPDATED_BY ,

Line 1569: update oke_deliverable_actions set

1565: l_currency_code);
1566:
1567: end if;
1568: If p_action='UPDATE' then
1569: update oke_deliverable_actions set
1570: LAST_UPDATE_DATE = sysdate,
1571: LAST_UPDATED_BY = fnd_global.user_id ,
1572: LAST_UPDATE_LOGIN = fnd_global.login_id,
1573: ACTION_TYPE = p_dlv_action_type ,

Line 1606: -- Update all columns of oke_deliverable_actions;

1602: currency_code = l_currency_code
1603: where action_id=l_action_id;
1604:
1605:
1606: -- Update all columns of oke_deliverable_actions;
1607: end if;
1608: /*
1609: If p_dlv_action_type=G_REQ and p_item_dlv <> 'Y' then
1610: update oke_deliverables_b set quantity = l_quantity,

Line 1643: update oke_deliverable_actions set

1639: , P_Exchange_Rate => l_exchange_rate
1640: , P_Expenditure_Type_Code => l_expenditure_type
1641: , P_Expenditure_Organization_Id => l_Expenditure_Org_Id
1642: , P_Expenditure_Item_Date => l_expenditure_item_DATE ) ='Y' then
1643: update oke_deliverable_actions set
1644: LAST_UPDATE_DATE = sysdate,
1645: LAST_UPDATED_BY = fnd_global.user_id ,
1646: LAST_UPDATE_LOGIN = fnd_global.login_id,
1647: READY_FLAG = 'Y'

Line 1669: update oke_deliverable_actions set

1665: , P_weight_uom => l_weight_uom
1666: , P_quantity => l_quantity
1667: , P_uom_code => l_uom_code
1668: ) ='Y' then
1669: update oke_deliverable_actions set
1670: LAST_UPDATE_DATE = sysdate,
1671: LAST_UPDATED_BY = fnd_global.user_id ,
1672: LAST_UPDATE_LOGIN = fnd_global.login_id,
1673: READY_FLAG = 'Y'

Line 1783: from oke_deliverable_actions act,oke_deliverables_b dlv

1779: action_name,
1780: dlv.project_id,
1781: act.quantity,
1782: act.uom_code
1783: from oke_deliverable_actions act,oke_deliverables_b dlv
1784: where pa_action_id=b_pa_action_id
1785: and dlv.deliverable_id = act.deliverable_id;
1786:
1787: l_deliverable_id Number;

Line 1864: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand( P_Action_ID => l_action_id,

1860: P_Expected_Date => l_expected_date,
1861: P_quantity => l_quantity,
1862: P_uom_code => l_uom_code)='Y' then
1863:
1864: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand( P_Action_ID => l_action_id,
1865: P_Init_Msg_List => fnd_api.g_false,
1866: X_ID => l_out_id,
1867: X_Return_Status => x_return_status,
1868: X_Msg_Count => x_msg_count,

Line 1882: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition( P_Action_ID => l_action_id,

1878:
1879: end if;
1880: If p_dlv_action_type =G_REQ then
1881: If l_ready_flag='Y' then
1882: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition( P_Action_ID => l_action_id,
1883: P_Init_Msg_List => fnd_api.g_false,
1884: X_ID => l_out_id,
1885: X_Return_Status => x_return_status,
1886: X_Msg_Count => x_msg_count,

Line 1907: OKE_DELIVERABLE_ACTIONS_PKG.create_Shipment( P_Action_ID => l_action_id,

1903: end if;
1904: end if;
1905: If p_dlv_action_type =G_SHIP then
1906: If l_ready_flag='Y' then
1907: OKE_DELIVERABLE_ACTIONS_PKG.create_Shipment( P_Action_ID => l_action_id,
1908: P_Init_Msg_List => fnd_api.g_false,
1909: X_ID => l_out_id,
1910: X_Return_Status => x_return_status,
1911: X_Msg_Count => x_msg_count,