eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 240: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

236:
237: ozf_utility_pvt.write_conc_log('-- Insert into Activity Customers 1 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
238:
239: FOR i IN c_activity_person LOOP
240: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
241: parent_status, parent_type, confidential_flag,object_id,object_class, object_desc,object_status,source_code,
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,

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 274: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

270:
271: ozf_utility_pvt.write_conc_log('-- Insert into Activity Customers 2 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
272:
273: FOR i IN c_activity_relationship LOOP
274: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
275: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
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,

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 293: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

289:
290: ozf_utility_pvt.write_conc_log('-- Insert into Activity Customers 3 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
291:
292: FOR i IN c_activity_organization LOOP
293: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,
294: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
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,

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 620: --DELETE FROM ozf_activity_customers_temp where object_class = 'CSCH' ;

616:
617: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Temp Tables --');
618:
619: --DELETE FROM ozf_activity_products_temp where object_class = 'CSCH' ;
620: --DELETE FROM ozf_activity_customers_temp where object_class = 'CSCH' ;
621:
622: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Denorm Tables --');
623:
624: delete from ozf_activity_hl_denorm;

Line 626: delete from ozf_activity_customers where object_class = 'CSCH' ;

622: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Denorm Tables --');
623:
624: delete from ozf_activity_hl_denorm;
625: delete from ozf_activity_products where object_class = 'CSCH' ;
626: delete from ozf_activity_customers where object_class = 'CSCH' ;
627:
628: initial_load(l_org_id);
629: else
630:

Line 735: DELETE from ozf_activity_customers a where EXISTS

731:
732: ozf_utility_pvt.write_conc_log('-- After the update, the status of some schedules may change --'|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));
733: ozf_utility_pvt.write_conc_log('-- Delete Cancelled Schedules and its depedants --');
734:
735: DELETE from ozf_activity_customers a where EXISTS
736: (select b.schedule_id
737: from ozf_activity_hl_denorm b
738: where b.schedule_status in ('CANCELLED','ARCHIVED','ONHOLD')
739: and b.schedule_id = a.object_id and a.object_class = 'CSCH');

Line 748: from ozf_activity_customers */

744: and b.schedule_id = a.object_id and a.object_class = 'CSCH');
745: DELETE from ozf_activity_hl_denorm where schedule_status in ('CANCELLED', 'ARCHIVED', 'ONHOLD');
746:
747: /*If the list have been re-regenerated, mark them for to picked up as new schedules and also delete them
748: from ozf_activity_customers */
749:
750: FOR i in c_changed_list_headers(l_latest_comp_date) LOOP
751:
752: ozf_utility_pvt.write_conc_log('-- List changed for schedule : ' || i.schedule_id || '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));

Line 759: DELETE from ozf_activity_customers where object_id = i.schedule_id and object_class = 'CSCH';

755: SET schedule_update_date = sysdate
756: WHERE schedule_id = i.schedule_id
757: AND list_header_id is not null;
758:
759: DELETE from ozf_activity_customers where object_id = i.schedule_id and object_class = 'CSCH';
760: END LOOP;
761:
762: /* Add new schedules to both the hl_denorm table */
763: FOR i in c_incr_campaigns LOOP

Line 790: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

786:
787: ozf_utility_pvt.write_conc_log('-- Denorm parties for new or changed schedule : ' || i.schedule_id|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss') );
788:
789: FOR j in c_activity_incr_person( i.schedule_id, i.party_id,i.item_type) LOOP
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,

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 802: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

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);
799: END LOOP;
800:
801: FOR j in c_activity_incr_relationship( i.schedule_id, i.party_id,i.item_type) LOOP
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,

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 814: INSERT into ozf_activity_customers (activity_customer_id,parent_id, parent_desc, parent_class,

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);
811: END LOOP;
812:
813: FOR j in c_activity_incr_organization( i.schedule_id, i.party_id,i.item_type) LOOP
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,

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);