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_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 529: -- Refreshes offer and party denorm table ozf_activity_customers.

525: -- PROCEDURE
526: -- refresh_netaccrual_parties
527: --
528: -- PURPOSE
529: -- Refreshes offer and party denorm table ozf_activity_customers.
530: --
531: -- PARAMETERS
532: -- p_list_header_id: qp_list_header_id of the offer
533: --

Line 535: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers

531: -- PARAMETERS
532: -- p_list_header_id: qp_list_header_id of the offer
533: --
534: -- DESCRIPTION
535: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
536: ---------------------------------------------------------------------
537: PROCEDURE refresh_netaccrual_parties(
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 1309: -- Refreshes offer and party denorm table ozf_activity_customers.

1305: -- PROCEDURE
1306: -- refresh_volume_parties
1307: --
1308: -- PURPOSE
1309: -- Refreshes offer and party denorm table ozf_activity_customers.
1310: --
1311: -- PARAMETERS
1312: -- p_list_header_id: qp_list_header_id of the offer
1313: --

Line 1315: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers

1311: -- PARAMETERS
1312: -- p_list_header_id: qp_list_header_id of the offer
1313: --
1314: -- DESCRIPTION
1315: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1316: ---------------------------------------------------------------------
1317: PROCEDURE refresh_volume_parties(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 1568: -- Refreshes offer and party denorm table ozf_activity_customers.

1564: -- PROCEDURE
1565: -- refresh_parties
1566: --
1567: -- PURPOSE
1568: -- Refreshes offer and party denorm table ozf_activity_customers.
1569: --
1570: -- PARAMETERS
1571: -- p_list_header_id: qp_list_header_id of the offer
1572: --

Line 1574: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers

1570: -- PARAMETERS
1571: -- p_list_header_id: qp_list_header_id of the offer
1572: --
1573: -- DESCRIPTION
1574: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1575: ---------------------------------------------------------------------
1576: PROCEDURE refresh_parties(
1577: p_api_version IN NUMBER,
1578: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 2341: FROM ozf_activity_customers

2337: SELECT 'Y'
2338: FROM DUAL
2339: WHERE EXISTS (
2340: SELECT 1
2341: FROM ozf_activity_customers
2342: WHERE last_update_date > l_date
2343: AND object_id = l_id and object_class = 'OFFR'
2344: );
2345:

Line 2786: DELETE FROM ozf_activity_customers

2782:
2783: write_conc_log('-- Deleting Temp and Denorm Tables --');
2784:
2785: if p_offer_id is not null then
2786: DELETE FROM ozf_activity_customers
2787: WHERE object_class = 'OFFR'
2788: and object_id = p_offer_id;
2789:
2790: DELETE FROM ozf_activity_products

Line 2794: DELETE FROM ozf_activity_customers_temp

2790: DELETE FROM ozf_activity_products
2791: WHERE object_class = 'OFFR'
2792: and object_id = p_offer_id;
2793:
2794: DELETE FROM ozf_activity_customers_temp
2795: WHERE object_class = 'OFFR'
2796: and object_id = p_offer_id;
2797:
2798: DELETE FROM ozf_activity_products_temp

Line 2802: DELETE FROM ozf_activity_customers

2798: DELETE FROM ozf_activity_products_temp
2799: WHERE object_class = 'OFFR'
2800: and object_id = p_offer_id;
2801: else
2802: DELETE FROM ozf_activity_customers
2803: WHERE object_class = 'OFFR';
2804:
2805: DELETE FROM ozf_activity_products
2806: WHERE object_class = 'OFFR';

Line 2808: DELETE FROM ozf_activity_customers_temp

2804:
2805: DELETE FROM ozf_activity_products
2806: WHERE object_class = 'OFFR';
2807:
2808: DELETE FROM ozf_activity_customers_temp
2809: WHERE object_class = 'OFFR';
2810:
2811: DELETE FROM ozf_activity_products_temp
2812: WHERE object_class = 'OFFR';

Line 2829: DELETE FROM ozf_activity_customers_temp

2825: -- denorm parties
2826:
2827: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');
2828: /*
2829: DELETE FROM ozf_activity_customers_temp
2830: WHERE object_class = 'OFFR'
2831: AND object_id = i.object_id ;
2832:
2833: DELETE FROM ozf_activity_products_temp

Line 2837: DELETE FROM ozf_activity_customers

2833: DELETE FROM ozf_activity_products_temp
2834: WHERE object_class = 'OFFR'
2835: AND object_id = i.object_id ;
2836:
2837: DELETE FROM ozf_activity_customers
2838: WHERE object_class = 'OFFR'
2839: AND object_id = i.object_id;
2840:
2841: DELETE FROM ozf_activity_products

Line 2860: FND_DSQL.add_text('INSERT INTO ozf_activity_customers_temp(');

2856: if z.qnum = -99 AND l_group_count > 0 then
2857: goto GROUP_END1;
2858: end if;
2859: FND_DSQL.init;
2860: FND_DSQL.add_text('INSERT INTO ozf_activity_customers_temp(');
2861: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,last_update_login,');
2862: FND_DSQL.add_text('confidential_flag,custom_setup_id,');
2863: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,');
2864: FND_DSQL.add_text('parent_id,parent_class,parent_desc,');

Line 3166: update ozf_activity_customers_temp

3162: where object_id = i.object_id
3163: and object_class = 'OFFR';
3164:
3165: -- update offer forecast and offer values.
3166: update ozf_activity_customers_temp
3167: set forecast_units = s_forecast_units,
3168: forecast_revenue = s_forecast_revenue,
3169: forecast_costs = s_forecast_costs,
3170: forecast_roi = s_forecast_roi,

Line 3211: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed

3207:
3208: IF l_offer_changed IS NOT NULL THEN -- offer changed
3209: --write_log('OCHAN-Offer Id: '|| i.object_id || ' has changed.');
3210: -- parties have to be denormed as associated offers are changed
3211: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3212: WHERE object_id = i.object_id and object_class = 'OFFR';
3213:
3214: l_group_count := 0;
3215: FOR z IN c_groups(i.object_id)

Line 3222: FND_DSQL.add_text('INSERT INTO ozf_activity_customers(');

3218: goto GROUP_END2;
3219: end if;
3220:
3221: FND_DSQL.init;
3222: FND_DSQL.add_text('INSERT INTO ozf_activity_customers(');
3223: FND_DSQL.add_text('activity_customer_id,creation_date,created_by,last_update_date,last_updated_by,');
3224: FND_DSQL.add_text('last_update_login,confidential_flag,custom_setup_id,');
3225: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
3226: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');

Line 3231: FND_DSQL.add_text('SELECT ozf_activity_customers_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

3227: FND_DSQL.add_text('qp_qualifier_id,qp_qualifier_group,party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
3228: -- FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
3229: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
3230:
3231: FND_DSQL.add_text('SELECT ozf_activity_customers_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
3232: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
3233: FND_DSQL.add_bind(i.confidential_flag);
3234: FND_DSQL.add_text(',');
3235: FND_DSQL.add_bind(i.custom_setup_id);

Line 3306: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed

3302: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
3303: FND_DSQL.add_text(')');
3304:
3305: /*
3306: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3307: WHERE object_id = i.object_id and object_class = 'OFFR';
3308: */
3309: l_denorm_csr := DBMS_SQL.open_cursor;
3310: FND_DSQL.set_cursor(l_denorm_csr);

Line 3428: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed

3424: CLOSE c_party_denormed;
3425:
3426: IF l_dummy IS NULL THEN
3427:
3428: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3429: WHERE object_id = i.object_id and object_class = 'OFFR';
3430:
3431: l_group_count := 0;
3432: FOR z IN c_groups(i.object_id)

Line 3438: FND_DSQL.add_text('INSERT INTO ozf_activity_customers(');

3434: if z.qnum = -99 AND l_group_count > 0 then
3435: goto GROUP_END3;
3436: end if;
3437: FND_DSQL.init;
3438: FND_DSQL.add_text('INSERT INTO ozf_activity_customers(');
3439: FND_DSQL.add_text('activity_customer_id,creation_date,created_by,last_update_date,last_updated_by,');
3440: FND_DSQL.add_text('last_update_login,confidential_flag,custom_setup_id,');
3441: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
3442: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');

Line 3446: FND_DSQL.add_text('SELECT ozf_activity_customers_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

3442: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');
3443: FND_DSQL.add_text('qp_qualifier_id, qp_qualifier_group,party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
3444: -- FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
3445: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
3446: FND_DSQL.add_text('SELECT ozf_activity_customers_s.nextval,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
3447: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
3448: FND_DSQL.add_bind(i.confidential_flag);
3449: FND_DSQL.add_text(',');
3450: FND_DSQL.add_bind(i.custom_setup_id);

Line 3517: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed

3513: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'',''ORDER'') ');
3514: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
3515: FND_DSQL.add_text(')');
3516: /*
3517: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3518: WHERE object_id = i.object_id and object_class = 'OFFR';
3519: */
3520: l_denorm_csr := DBMS_SQL.open_cursor;
3521: FND_DSQL.set_cursor(l_denorm_csr);

Line 3732: update ozf_activity_customers

3728: actual_uom = l_uom_code
3729: where object_id = i.offer_id
3730: and object_class = 'OFFR';
3731:
3732: update ozf_activity_customers
3733: set forecast_units = s_forecast_units,
3734: forecast_revenue = s_forecast_revenue,
3735: forecast_costs = s_forecast_costs,
3736: forecast_roi = s_forecast_roi,

Line 3799: update ozf_activity_customers

3795: forecast_uom = i.forecast_uom_code
3796: where object_id = i.offer_id
3797: and object_class = 'OFFR';
3798:
3799: update ozf_activity_customers
3800: set forecast_units = s_forecast_units,
3801: forecast_revenue = s_forecast_revenue,
3802: forecast_costs = s_forecast_costs,
3803: forecast_roi = s_forecast_roi,

Line 3857: update ozf_activity_customers

3853: actual_uom = l_uom_code
3854: where object_id = i.offer_id
3855: and object_class = 'OFFR';
3856:
3857: update ozf_activity_customers
3858: set forecast_units = s_forecast_units,
3859: forecast_revenue = s_forecast_revenue,
3860: forecast_costs = s_forecast_costs,
3861: forecast_roi = s_forecast_roi,

Line 3872: DELETE FROM ozf_activity_customers

3868: --write_log('After c_incremental_actual_values loop' );
3869: END IF;
3870:
3871: /*
3872: DELETE FROM ozf_activity_customers
3873: WHERE object_id IN (
3874: SELECT l.list_header_id
3875: FROM ozf_offers o, qp_list_headers l
3876: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')

Line 3891: DELETE FROM OZF_ACTIVITY_CUSTOMERS b

3887: )
3888: AND object_class = 'OFFR';
3889: */
3890:
3891: DELETE FROM OZF_ACTIVITY_CUSTOMERS b
3892: WHERE
3893: exists ( SELECT L.LIST_HEADER_ID
3894: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3895: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND

Line 3918: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');

3914: WHERE a.application_short_name = 'AMS'
3915: AND a.application_id = i.application_id;
3916: */
3917:
3918: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');
3919:
3920: INSERT INTO ozf_activity_customers
3921: (activity_customer_id,OBJECT_ID,
3922: OBJECT_TYPE,

Line 3920: INSERT INTO ozf_activity_customers

3916: */
3917:
3918: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');
3919:
3920: INSERT INTO ozf_activity_customers
3921: (activity_customer_id,OBJECT_ID,
3922: OBJECT_TYPE,
3923: OBJECT_STATUS,
3924: OBJECT_CLASS,

Line 3959: SELECT ozf_activity_customers_s.nextval,OBJECT_ID,

3955: CONFIDENTIAL_FLAG,
3956: CUSTOM_SETUP_ID,
3957: QP_QUALIFIER_ID,
3958: QP_QUALIFIER_GROUP)
3959: SELECT ozf_activity_customers_s.nextval,OBJECT_ID,
3960: OBJECT_TYPE,
3961: OBJECT_STATUS,
3962: OBJECT_CLASS,
3963: PARENT_ID,

Line 3997: FROM ozf_activity_customers_temp;

3993: CONFIDENTIAL_FLAG,
3994: CUSTOM_SETUP_ID,
3995: QP_QUALIFIER_ID,
3996: QP_QUALIFIER_GROUP
3997: FROM ozf_activity_customers_temp;
3998:
3999: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');
4000:
4001: INSERT INTO ozf_activity_products

Line 4585: FROM ozf_activity_customers

4581: IS
4582:
4583: CURSOR c_offer(l_party NUMBER, l_offer NUMBER) IS
4584: SELECT distinct(1)
4585: FROM ozf_activity_customers
4586: WHERE (party_id = l_party
4587: OR party_id = -1)
4588: AND object_id = l_offer
4589: AND object_class = 'OFFR'

Line 4652: FROM ozf_activity_customers

4648:
4649: CURSOR c_offer(l_party NUMBER, l_product NUMBER) IS
4650: SELECT object_id
4651: FROM (SELECT distinct object_id
4652: FROM ozf_activity_customers
4653: WHERE (party_id = l_party OR party_id = -1)
4654: AND active_flag = 'Y'
4655: AND ask_for_flag = 'Y'
4656: AND object_class = 'OFFR'