DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on MTL_SYSTEM_ITEMS

Line 254: p_item_id IN mtl_system_items.inventory_item_id%type,

250: --end bugfix 2001824
251:
252:
253: PROCEDURE CREATE_ATTACHMENT(
254: p_item_id IN mtl_system_items.inventory_item_id%type,
255: p_org_id IN mtl_system_items.organization_id%type,
256: p_text IN Long,
257: p_desc IN varchar2,
258: p_doc_type In Varchar2,

Line 255: p_org_id IN mtl_system_items.organization_id%type,

251:
252:
253: PROCEDURE CREATE_ATTACHMENT(
254: p_item_id IN mtl_system_items.inventory_item_id%type,
255: p_org_id IN mtl_system_items.organization_id%type,
256: p_text IN Long,
257: p_desc IN varchar2,
258: p_doc_type In Varchar2,
259: x_return_status OUT NOCOPY varchar2);

Line 262: PO_VALIDATION_ORG mtl_system_items.organization_id%type;

258: p_doc_type In Varchar2,
259: x_return_status OUT NOCOPY varchar2);
260:
261:
262: PO_VALIDATION_ORG mtl_system_items.organization_id%type;
263:
264:
265:
266: PROCEDURE GENERATE_BOM_ATTACH_TEXT

Line 274: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,

270: );
271:
272:
273: FUNCTION CHECK_CONFIG_ITEM(
274: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
275: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
276: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2;
277:
278: /*---------------------------------------------------------------------------------------------

Line 275: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,

271:
272:
273: FUNCTION CHECK_CONFIG_ITEM(
274: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
275: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
276: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2;
277:
278: /*---------------------------------------------------------------------------------------------
279: Procedure : chk_all_rsv_details --bugfix 2327972

Line 276: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2;

272:
273: FUNCTION CHECK_CONFIG_ITEM(
274: p_parent_item_id IN Mtl_system_items.inventory_item_id%type,
275: p_inventory_item_id IN Mtl_system_items.inventory_item_id%type,
276: p_organization_id IN Mtl_system_items.organization_id%type) RETURN Varchar2;
277:
278: /*---------------------------------------------------------------------------------------------
279: Procedure : chk_all_rsv_details --bugfix 2327972
280: Description: This procedure gets the different types of reservation done on a line_id (item)