APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_NA_CUSTOMERS_TEMP

Line 21: FROM ozf_na_customers_temp

17: WHERE cust_account_id = p_sold_to_org_id;
18:
19: CURSOR c_customer_qualified(p_party_id NUMBER) IS
20: SELECT 'Y'
21: FROM ozf_na_customers_temp
22: WHERE (
23: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
24: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
25: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 32: FROM ozf_na_customers_temp

28: AND ROWNUM = 1;
29:
30: CURSOR c_cust_acct_qualified(p_party_id NUMBER) IS
31: SELECT 'Y'
32: FROM ozf_na_customers_temp
33: WHERE (
34: (cust_account_id = p_sold_to_org_id) OR
35: (party_id = p_party_id AND site_use_code IS NULL) OR
36: (party_id = -1)

Line 417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');

413: x_return_status := FND_API.g_ret_sts_success;
414:
415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');

Line 2257: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_customers_temp';

2253: FOR l_net_accrual_offers IN c_net_accrual_offers
2254: LOOP
2255:
2256: --AMITAMKU bug 14692296 - Moved truncate before SAVEPOINT net_accrual_offer to avoid AUTO-COMMIT, in case of failure of a net accrual offer
2257: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_customers_temp';
2258: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_products_temp';
2259: -- Bug 11889816 - Added TRUNCATE for OZF_NA_UNIQUE_PRODUCTS_TEMP
2260: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.OZF_NA_UNIQUE_PRODUCTS_TEMP';
2261:

Line 2354: -- For all other Offers, populate the ozf_na_customers_temp denom table

2350: END IF;
2351: --
2352: ELSE
2353: --
2354: -- For all other Offers, populate the ozf_na_customers_temp denom table
2355: --
2356:
2357: ozf_utility_pvt.write_conc_log('Populate_Customers (+)');
2358:

Line 2422: FROM ozf_na_customers_temp;

2418:
2419: ozf_utility_pvt.write_conc_log('Total Number of Unique Products: '||l_tot_products);
2420:
2421: SELECT count(*) INTO l_tot_customers
2422: FROM ozf_na_customers_temp;
2423:
2424: ozf_utility_pvt.write_conc_log('Total Number of Customers: '||l_tot_customers);
2425:
2426: --Bug 11889816 : end

Line 4665: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_customers_temp';

4661: ozf_utility_pvt.write_conc_log('-- NEXT_OFFER -- ');
4662: END LOOP; --FOR l_net_accrual_offers IN c_net_accrual_offers
4663:
4664: --AMITAMKU bug 14692296 - moved truncate out of the loop to end of the program
4665: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_customers_temp';
4666: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ozf_na_products_temp';
4667: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.OZF_NA_UNIQUE_PRODUCTS_TEMP';
4668:
4669: ozf_utility_pvt.write_conc_log('-- Done -- ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));