DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on OZF_ACTIVITY_CUSTOMERS_S

Line 246: values(ozf_activity_customers_s.nextval,

242: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
243: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,
244: qualifier_attribute,qualifier_context,prod_indicator,
245: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
246: values(ozf_activity_customers_s.nextval,
247: i.campaign_id,
248: i.campaign_name,
249: i.campaign_class,
250: i.campaign_status,

Line 280: values(ozf_activity_customers_s.nextval,

276: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
277: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,
278: qualifier_attribute,qualifier_context,prod_indicator,
279: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
280: values(ozf_activity_customers_s.nextval,
281: i.campaign_id, i.campaign_name,i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
282: i.schedule_id,i.object_class,i.schedule_name,i.status_code,i.source_code,i.start_date_time,i.end_date_time,
283: i.owner_user_id, i.activity_type_code,i.activity_id,i.marketing_medium_id,i.custom_setup_id,
284: i.party_id,i.cust_account_id,i.cust_acct_site_id,i.site_use_id,i.site_use_code,

Line 299: values(ozf_activity_customers_s.nextval,

295: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
296: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,
297: qualifier_attribute,qualifier_context,prod_indicator,
298: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
299: values(ozf_activity_customers_s.nextval,
300: i.campaign_id, i.campaign_name,i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
301: i.schedule_id,i.object_class,i.schedule_name,i.status_code,i.source_code,i.start_date_time,i.end_date_time,
302: i.owner_user_id, i.activity_type_code,i.activity_id,i.marketing_medium_id,i.custom_setup_id,
303: i.party_id,i.cust_account_id,i.cust_acct_site_id,i.site_use_id,i.site_use_code,

Line 794: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

790: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
791: parent_status, parent_type, confidential_flag,object_id,object_class,object_desc,object_status,source_code,
792: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
793: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,prod_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
794: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
795: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
796: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
797: j.activity_id, j.marketing_medium_id, j.party_id, j.cust_account_id,
798: j.cust_acct_site_id, j.site_use_id, j.site_use_code, j.prod_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 806: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

802: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
803: parent_status, parent_type,confidential_flag, object_id,object_class,object_desc,object_status,source_code,
804: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
805: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,prod_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
806: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
807: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
808: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
809: j.activity_id, j.marketing_medium_id, j.party_id, j.cust_account_id,
810: j.cust_acct_site_id, j.site_use_id, j.site_use_code, j.prod_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 818: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

814: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
815: parent_status, parent_type,confidential_flag, object_id,object_class,object_desc,object_status,source_code,
816: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
817: party_id, cust_account_id,cust_acct_site_id,site_use_id,site_use_code,prod_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
818: values(ozf_activity_customers_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
819: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
820: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
821: j.activity_id, j.marketing_medium_id, j.party_id, j.cust_account_id,
822: j.cust_acct_site_id, j.site_use_id, j.site_use_code, j.prod_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);