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 FND_GLOBAL

Line 224: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id

220: SELECT ozf_activity_hl_denorm_s.nextval, s.schedule_id, i.campaign_id, i.status_code,
221: i.rollup_type, i.campaign_type, i.campaign_name,i.private_flag,
222: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
223: ap.level_type_code item_type, al.list_header_id,s.custom_setup_id,
224: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id
225: FROM
226: ams_campaign_schedules_b s,
227: ams_act_products ap,
228: ams_act_lists al

Line 267: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

263: i.marketing_medium_id,
264: i.custom_setup_id,
265: i.party_id,i.cust_account_id,i.cust_acct_site_id,i.site_use_id,i.site_use_code,
266: i.qualifier_attribute,i.qualifier_context, i.prod_indicator,
267: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
268: END LOOP;
269:
270:
271: ozf_utility_pvt.write_conc_log('-- Insert into Activity Customers 2 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

Line 286: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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,
285: i.qualifier_attribute,i.qualifier_context, i.prod_indicator,
286: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
287: END LOOP;
288:
289:
290: ozf_utility_pvt.write_conc_log('-- Insert into Activity Customers 3 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

Line 305: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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,
304: i.qualifier_attribute,i.qualifier_context, i.prod_indicator,
305: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
306: END LOOP;
307:
308:
309: ozf_utility_pvt.write_conc_log('-- Insert into Activity Products 1 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

Line 320: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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);
321: END LOOP;
322:
323: ozf_utility_pvt.write_conc_log('-- Insert into Activity Products 2 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
324:

Line 334: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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);
335: END LOOP;
336:
337:
338: ozf_utility_pvt.write_conc_log('-- Initial Load End --');

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

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;
705:
706: ozf_utility_pvt.write_conc_log('-- Adding category products to the denorm table -- '|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));
707:

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

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;
720:
721: /* Need to look into Campaign Status also */
722:

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

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

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

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

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

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);
823: END LOOP;
824:
825: END LOOP;
826:

Line 841: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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);
842: END LOOP;
843: FOR j in c_activity_incr_cat_new(i.schedule_id, l_org_id,i.list_header_id) LOOP
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,

Line 852: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

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);
853: END LOOP;
854: END LOOP;
855:
856: ozf_utility_pvt.write_conc_log('-- Incremental Load End --'|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));