DBA Data[Home] [Help]

APPS.MSC_SECRULE_PKG dependencies on FND_GLOBAL

Line 206: p_item_name,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

202: values
203: (msc_security_rules_s.nextval,l_lookup_code,l_item_id,l_customer_id,l_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,

Line 216: p_item_name,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

212: values
213: (msc_security_rules_s.nextval,NULL,l_item_id,l_customer_id,l_customer_site_id,
214: l_supplier_id,l_supplier_site_id,l_org_id,p_order_number,p_grantee_type,
215: l_grantee_key,p_privilege,l_company_id,l_start_date,l_end_date,
216: p_item_name,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);
217: end if;
218:
219:
220:

Line 458: last_updated_by = fnd_global.user_id

454: effective_to_date = l_end_date,
455: item_name = p_item_name,
456: -- order_type_meaning = p_order_type,
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id
459: where rule_id = p_rule_id;
460:
461: else
462:

Line 481: last_updated_by = fnd_global.user_id

477: effective_to_date = l_end_date,
478: item_name = p_item_name,
479: -- order_type_meaning = p_order_type,
480: last_update_date = sysdate,
481: last_updated_by = fnd_global.user_id
482: where rule_id = p_rule_id;
483:
484: end if;
485: