DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on OZF_ACTIVITY_PRODUCTS_S

Line 316: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

312: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
313: parent_status, parent_type, confidential_flag,object_id,object_class, object_desc,object_status,source_code,
314: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
315: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
316: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
317: i.schedule_id, i.object_class,i.schedule_name,i.status_code,i.source_code, i.start_date_time, i.end_date_time,
318: i.owner_user_id, i.item, i.item_type,
319: i.activity_type_code, i.activity_id, i.marketing_medium_id,i.custom_setup_id,i.cust_indicator,
320: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 330: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

326: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
327: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
328: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
329: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
330: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
331: i.schedule_id, i.object_class,i.schedule_name,i.status_code,i.source_code, i.start_date_time, i.end_date_time,
332: i.owner_user_id, i.item, i.item_type,
333: i.activity_type_code, i.activity_id, i.marketing_medium_id,i.custom_setup_id,i.cust_indicator,
334: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 700: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

696: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
697: parent_status, parent_type, confidential_flag,object_id,object_type,object_status,object_class, source_code,
698: start_date, end_date, owner_id, item, item_type, activity_type_code,
699: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
700: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,
701: i.parent_status, i.parent_type,i.confidential_flag, i.object_id, i.object_type,i.object_status,i.object_class,
702: i.source_code, i.start_date, i.end_date, i.owner_id, i.item, i.item_type, i.activity_type_code,
703: i.activity_id, i.marketing_medium_id, i.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
704: END LOOP;

Line 715: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

711: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
712: parent_status, parent_type,confidential_flag, object_id,object_type,object_status,object_class, source_code,
713: start_date, end_date, owner_id, item, item_type, activity_type_code,
714: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
715: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,
716: i.parent_status, i.parent_type,i.confidential_flag, i.object_id, i.object_type,i.object_status,i.object_class,
717: i.source_code, i.start_date, i.end_date, i.owner_id, i.item, i.item_type, i.activity_type_code,
718: i.activity_id, i.marketing_medium_id, i.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
719: END LOOP;

Line 837: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

833: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
834: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
835: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
836: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
837: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
838: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
839: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
840: j.activity_id, j.marketing_medium_id, j.item, j.item_type,
841: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 848: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

844: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
845: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
846: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
847: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
848: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
849: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
850: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
851: j.activity_id, j.marketing_medium_id, j.item, j.item_type,
852: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);