APPS.MSC_SECRULE_PKG dependencies on MSC_X_SECURITY_RULES

Line 53: FROM msc_x_security_rules sr

49:
50: CURSOR c_old_security_rule
51: IS
52: SELECT sr.rule_id
53: FROM msc_x_security_rules sr
54: WHERE decode(p_order_type,null,-1,sr.order_type) = decode(p_order_type,null,-1,p_order_type)
55: AND decode(l_item_id,null,-1,sr.item_id) = decode(l_item_id,null,-1,l_item_id)
56: AND decode(l_customer_id,null,-1,sr.customer_id) = decode(l_customer_id,null,-1,l_customer_id)
57: AND decode(l_supplier_id,null,-1,sr.supplier_id) = decode(l_supplier_id,null,-1,l_supplier_id)

Line 198: insert into msc_x_security_rules(rule_id, order_type,item_id,customer_id,customer_site_id,

194: if p_return_code=0 then
195: if l_lookup_code>ORDER_TYPE_ZERO then
196: -- if l_lookup_code IS NOT NULL then
197:
198: insert into msc_x_security_rules(rule_id, order_type,item_id,customer_id,customer_site_id,
199: supplier_id,supplier_site_id,org_id,order_number,grantee_type,
200: grantee_key,privilege,company_id,effective_from_date,effective_to_date,
201: item_name,creation_date,created_by,last_update_date,last_updated_by)
202: values

Line 208: insert into msc_x_security_rules(rule_id, order_type,item_id,customer_id,customer_site_id,

204: l_supplier_id,l_supplier_site_id,l_org_id,p_order_number,p_grantee_type,
205: l_grantee_key,p_privilege,l_company_id,l_start_date,l_end_date,
206: p_item_name,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);
207: else
208: insert into msc_x_security_rules(rule_id, order_type,item_id,customer_id,customer_site_id,
209: supplier_id,supplier_site_id,org_id,order_number,grantee_type,
210: grantee_key,privilege,company_id,effective_from_date,effective_to_date,
211: item_name,creation_date,created_by,last_update_date,last_updated_by)
212: values

Line 296: FROM msc_x_security_rules sr

292:
293: CURSOR c_old_security_rule
294: IS
295: SELECT sr.rule_id
296: FROM msc_x_security_rules sr
297: WHERE decode(l_lookup_code,null,-1,sr.order_type) = decode(l_lookup_code,null,-1,l_lookup_code)
298: AND decode(l_item_id,null,-1,sr.item_id) = decode(l_item_id,null,-1,l_item_id)
299: AND decode(l_customer_id,null,-1,sr.customer_id) = decode(l_customer_id,null,-1,l_customer_id)
300: AND decode(l_supplier_id,null,-1,sr.supplier_id) = decode(l_supplier_id,null,-1,l_supplier_id)

Line 440: update msc_x_security_rules set

436: if p_return_code=0 then
437: if l_lookup_code>ORDER_TYPE_ZERO then
438:
439:
440: update msc_x_security_rules set
441: order_type = l_lookup_code,
442: item_id = l_item_id,
443: customer_id = l_customer_id,
444: customer_site_id = l_customer_site_id,

Line 463: update msc_x_security_rules set

459: where rule_id = p_rule_id;
460:
461: else
462:
463: update msc_x_security_rules set
464: order_type = null,
465: item_id = l_item_id,
466: customer_id = l_customer_id,
467: customer_site_id = l_customer_site_id,