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.PA_DELIVERABLE_PUB dependencies on OKE_DELIVERABLES_B

Line 170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;

166:
167: l_project_number Pa_Projects_All.Segment1%TYPE;
168: l_task_number Pa_Proj_Elements.Name%TYPE;
169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);

Line 171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;

167: l_project_number Pa_Projects_All.Segment1%TYPE;
168: l_task_number Pa_Proj_Elements.Name%TYPE;
169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;

Line 172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;

168: l_task_number Pa_Proj_Elements.Name%TYPE;
169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;

Line 173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;

169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;
177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;

Line 175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;

171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;
177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;
178: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
179: l_master_inv_org_id PA_PLAN_RES_DEFAULTS.item_master_id%TYPE;

Line 176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;

172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;
173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;
177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;
178: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
179: l_master_inv_org_id PA_PLAN_RES_DEFAULTS.item_master_id%TYPE;
180:

Line 177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;

173: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE;
174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;
177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;
178: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
179: l_master_inv_org_id PA_PLAN_RES_DEFAULTS.item_master_id%TYPE;
180:
181: BEGIN

Line 940: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE ;

936: l_element_structure_id NUMBER;
937: is_dlvr_number_unique VARCHAR2(1) := 'N';
938: l_carrying_out_org NUMBER;
939:
940: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE ;
941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;
942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;

Line 941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;

937: is_dlvr_number_unique VARCHAR2(1) := 'N';
938: l_carrying_out_org NUMBER;
939:
940: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE ;
941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;
942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;

Line 942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;

938: l_carrying_out_org NUMBER;
939:
940: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE ;
941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;
942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;
946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;

Line 943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;

939:
940: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE ;
941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;
942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;
946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;
947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;

Line 945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;

941: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE ;
942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;
946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;
947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;
948: l_item_dlv VARCHAR2(1) ;
949:

Line 946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;

942: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE ;
943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;
946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;
947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;
948: l_item_dlv VARCHAR2(1) ;
949:
950: Cursor C_dlvr IS SELECT

Line 947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;

943: l_uom_code OKE_DELIVERABLES_B.UOM_CODE%TYPE ;
944: l_item_description OKE_DELIVERABLES_TL.DESCRIPTION%TYPE ;
945: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE ;
946: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE ;
947: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE ;
948: l_item_dlv VARCHAR2(1) ;
949:
950: Cursor C_dlvr IS SELECT
951: decode( p_dlvr_name , PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, element_name, p_dlvr_name) element_name

Line 1336: FROM OKE_DELIVERABLES_B

1332:
1333: ELSE
1334: BEGIN
1335: SELECT 'N' INTO l_manage_dlv_flag
1336: FROM OKE_DELIVERABLES_B
1337: WHERE project_id = p_project_id
1338: AND source_deliverable_id = l_dlv_elem_ver_id
1339: AND CURRENCY_CODE = l_currency_code
1340: AND nvl(unit_number,-99) = nvl(l_unit_number,-99)