[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_selection IN NUMBER
,p_cat_set_id IN NUMBER
,p_catg_struct_id IN NUMBER
,p_Catg_lo IN VARCHAR2
,p_catg_hi IN VARCHAR2
,p_item_lo IN VARCHAR2
,p_item_hi IN VARCHAR2
,p_planner_lo IN VARCHAR2
,p_planner_hi IN VARCHAR2
,p_buyer_lo IN VARCHAR2
,p_buyer_hi IN VARCHAR2
,p_sort IN VARCHAR2
--,p_range IN NUMBER
--,p_low IN VARCHAR2
--,p_high IN VARCHAR2
,p_d_cutoff IN VARCHAR2
,p_d_cutoff_rel IN NUMBER
,p_s_cutoff IN VARCHAR2
,p_s_cutoff_rel IN NUMBER
,p_user_id IN NUMBER
,p_restock IN NUMBER
,p_handle_rep_item IN NUMBER
,p_dd_loc_id IN NUMBER
,p_net_unrsv IN NUMBER
,p_net_rsv IN NUMBER
,p_net_wip IN NUMBER
,p_include_po IN NUMBER
,p_include_mo IN NUMBER
,p_include_wip IN NUMBER
,p_include_if IN NUMBER
,p_include_nonnet IN NUMBER
,p_lot_ctl IN NUMBER
,p_display_mode IN NUMBER
,p_show_desc IN NUMBER
,p_pur_revision IN NUMBER
)IS
l_req_id NUMBER;
SELECT NODE_TYPE,ORGANIZATION_ID,SECONDARY_INVENTORY
FROM CSP_PLANNING_PARAMETERS
WHERE LEVEL_ID LIKE p_level_id||'%'
and node_type = 'ORGANIZATION_WH'
union all
SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY
FROM CSP_PLANNING_PARAMETERS cpp,
mtl_secondary_inventories msi
WHERE LEVEL_ID LIKE p_level_id||'%'
and node_type = 'SUBINVENTORY'
and msi.organization_id = cpp.organization_id
and cpp.condition_type = 'G'
and msi.secondary_inventory_name = cpp.secondary_inventory
and (disable_date is null or trunc(disable_date) > trunc(sysdate));
select max(request_id)
from fnd_concurrent_requests fcr,fnd_concurrent_programs fcp
where fcr.program_application_id = fcp.application_id
and fcr.concurrent_program_id = fcp.concurrent_program_id
and fcp.application_id = 523
and fcp.concurrent_program_name = 'CSPPLMMX'
and fcr.phase_code <> 'C';
select 'x'
from fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp
where fcr.concurrent_program_id = fcp.concurrent_program_id
and fcr.program_application_id = fcp.application_id
and fcp.application_id = 401
and fcp.concurrent_program_name = 'INVISMMX'
and fcr.phase_code <> 'C'
and fcr.request_id between l_lo_request_id and l_hi_request_id
and fcr.parent_request_id = l_parent_request_id;
SELECT pla.location_id inv_loc_id
into l_location_id
from csp_rs_cust_relations rcr,
hz_cust_acct_sites cas,
hz_cust_site_uses csu,
po_location_associations pla,
csp_sec_inventories csi
where rcr.customer_id = cas.cust_account_id
and cas.cust_acct_site_id = csu.cust_acct_site_id
and csu.site_use_code = 'SHIP_TO'
and csu.site_use_id = pla.site_use_id
and rcr.resource_type = csi.owner_resource_type
and rcr.resource_id = csi.owner_resource_id
and csi.organization_id = rec.organization_id
and csi.secondary_inventory_name = rec.secondary_inventory
and csu.primary_flag = 'Y';
fnd_msg_pub.delete_msg;
SELECT LOCATION_ID
INTO L_LOCATION_ID
FROM HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = Rec.ORGANIZATION_ID;
select name
into l_org_name
from hr_all_organization_units
where organization_id = rec.organization_id;
fnd_msg_pub.delete_msg;
,l_org_id,l_level,1,l_subinv,p_selection,p_cat_set_id
,p_catg_struct_id
,p_Catg_lo
,p_catg_hi
,p_item_lo
,p_item_hi
,p_planner_lo
,p_planner_hi
,p_buyer_lo
,p_buyer_hi
,p_sort
-- ,null --p_range
-- ,null --p_low
-- ,null --p_high
,p_d_cutoff
,p_d_cutoff_rel
,p_s_cutoff
,p_s_cutoff_rel
,p_user_id
,p_restock,p_handle_rep_item,L_LOCATION_ID,p_net_unrsv,p_net_rsv
,p_net_wip,p_include_po
,p_include_mo
,p_include_wip,p_include_if
,p_include_nonnet
,p_lot_ctl,p_display_mode,p_show_desc,p_pur_revision,chr(0),
'','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','');