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_BUDGETAPPROVAL_PVT dependencies on OZF_TEMP_ELIGIBILITY

Line 17: -- 12/14/2003 kdass changed table name from ams_temp_eligibility to ozf_temp_eligibility

13: -- 02/21/2002 feliu fixed bug 2231003.
14: -- 10/28/2002 feliu Change for 11.5.9
15: -- 10/28/2002 feliu added budget_request_approval for non_approval budget request.
16: -- 05/09/2003 feliu use bind variable for dynamic sql.
17: -- 12/14/2003 kdass changed table name from ams_temp_eligibility to ozf_temp_eligibility
18: -- 01/29/2004 kdass fix bug 3402233 -- removed the check for debug level for the messages.
19: -- 02/03/2004 kdass fix bug 3380548 -- added new procedure revert_approved_request
20: -- 02/12/2004 kdass fix bug 3436425 -- removed raise and exit statements from conc_validate_offer_budget
21: -- 02/23/2004 kdass fix bug 3457111 -- modified the cursor query c_check_items in check_product_market_strict

Line 670: FROM ozf_temp_eligibility offr

666: x_valid_flag OUT NOCOPY VARCHAR2)
667: IS
668: CURSOR c_check_items IS
669: SELECT 1
670: FROM ozf_temp_eligibility offr
671: WHERE object_type = 'OFFR'
672: AND offr.eligibility_id > 0
673: AND (
674: (NOT EXISTS

Line 676: FROM ozf_temp_eligibility fund

672: AND offr.eligibility_id > 0
673: AND (
674: (NOT EXISTS
675: (SELECT 1
676: FROM ozf_temp_eligibility fund
677: WHERE fund.object_type = 'FUND'
678: AND fund.exclude_flag = 'N'
679: AND fund.eligibility_id > 0
680: AND fund.eligibility_id = offr.eligibility_id))

Line 684: FROM ozf_temp_eligibility fund

680: AND fund.eligibility_id = offr.eligibility_id))
681: OR
682: (EXISTS
683: (SELECT 1
684: FROM ozf_temp_eligibility fund
685: WHERE fund.object_type = 'FUND'
686: AND fund.exclude_flag = 'Y'
687: AND fund.eligibility_id > 0
688: AND fund.eligibility_id = offr.eligibility_id))

Line 693: FROM ozf_temp_eligibility fund

689: );
690:
691: CURSOR c_check_exclude_items IS
692: SELECT 1
693: FROM ozf_temp_eligibility fund
694: WHERE fund.object_type = 'FUND'
695: AND exclude_flag = 'Y'
696: AND fund.eligibility_id > 0
697: AND EXISTS

Line 699: FROM ozf_temp_eligibility offr

695: AND exclude_flag = 'Y'
696: AND fund.eligibility_id > 0
697: AND EXISTS
698: (SELECT 1
699: FROM ozf_temp_eligibility offr
700: WHERE offr.object_type = 'OFFR'
701: AND offr.eligibility_id > 0
702: AND offr.eligibility_id = fund.eligibility_id);
703:

Line 751: FROM ozf_temp_eligibility offr

747: x_valid_flag OUT NOCOPY VARCHAR2)
748: IS
749: CURSOR c_check_exclude_items IS
750: SELECT 1
751: FROM ozf_temp_eligibility offr
752: WHERE object_type = 'OFFR'
753: AND offr.eligibility_id > 0
754: AND NOT EXISTS
755: (SELECT 1

Line 756: FROM ozf_temp_eligibility fund

752: WHERE object_type = 'OFFR'
753: AND offr.eligibility_id > 0
754: AND NOT EXISTS
755: (SELECT 1
756: FROM ozf_temp_eligibility fund
757: WHERE offr.eligibility_id = fund.eligibility_id
758: AND fund.object_type = 'FUND'
759: AND fund.eligibility_id > 0
760: AND fund.exclude_flag = 'Y');

Line 764: FROM ozf_temp_eligibility offr, ozf_temp_eligibility fund

760: AND fund.exclude_flag = 'Y');
761:
762: CURSOR c_check_items IS
763: SELECT 1
764: FROM ozf_temp_eligibility offr, ozf_temp_eligibility fund
765: WHERE offr.object_type = 'OFFR'
766: AND fund.eligibility_id > 0
767: AND offr.eligibility_id > 0
768: AND fund.object_type = 'FUND'

Line 843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

839: x_exclude_prod := FALSE;
840: SAVEPOINT denorm_product_for_one_budget;
841:
842: FND_DSQL.init;
843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
844: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
845: -- Get all product qualifiers for 'FUND'
846: OPEN c_get_products(p_budget_id, 'FUND', 'N');
847: LOOP

Line 896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

892: l_ignore := DBMS_SQL.execute(l_denorm_csr);
893: END IF;
894:
895: FND_DSQL.init;
896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
897: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
898: -- for exclude product of FUND.
899:
900: OPEN c_get_products(p_budget_id,'FUND','Y');

Line 997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

993: x_exclude_mark := FALSE;
994: SAVEPOINT denorm_market_for_one_budget;
995:
996: FND_DSQL.init;
997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
998: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
999:
1000: OPEN c_get_budget_market_qualifiers('N');
1001:

Line 1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1078: --dbms_output.put_line(l_ignore);
1079: END IF;
1080:
1081: FND_DSQL.init;
1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1083: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1084:
1085: OPEN c_get_budget_market_qualifiers('Y');
1086: -- Get all excluded market qualifiers for 'FUND'

Line 1222: FROM ozf_temp_eligibility

1218: AND excluded_flag = p_excluded_flag;
1219:
1220: CURSOR c_count_offer_prod IS
1221: SELECT count(*)
1222: FROM ozf_temp_eligibility
1223: WHERE object_type = 'OFFR';
1224:
1225: BEGIN
1226:

Line 1230: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

1226:
1227: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1228: x_valid_flag := fnd_api.G_TRUE;
1229:
1230: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1231:
1232: denorm_product_for_one_budget (
1233: p_budget_id => p_actbudget_id,
1234: x_budget_prod => l_budget_prod,

Line 1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1252: END IF;
1253:
1254:
1255: FND_DSQL.init;
1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1257: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1258: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1259: OPEN c_get_products(p_object_id,'OFFR','N');
1260: LOOP

Line 1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

1447:
1448: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1449: x_valid_flag := fnd_api.G_TRUE;
1450:
1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1452:
1453: FND_DSQL.init;
1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');

Line 1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1450:
1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1452:
1453: FND_DSQL.init;
1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1456: -- Get all product qualifiers for 'FUND'
1457: OPEN c_get_budget_products('N');
1458: LOOP

Line 1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1503: --dbms_output.put_line(l_ignore);
1504: END IF;
1505:
1506: FND_DSQL.init;
1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1508: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1509: -- for exclude product of FUND.
1510:
1511: OPEN c_get_budget_products('Y');

Line 1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1568: l_exclude_only := TRUE;
1569: END IF;
1570:
1571: FND_DSQL.init;
1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1573: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1574: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1575: OPEN c_get_offer_products;
1576: LOOP

Line 1755: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

1751: set org id since for customer bill to, denorm query on org-striped table ra_addresses party,ra_site_uses
1752: */
1753: set_budget_org(p_budget_id => p_actbudget_id);
1754:
1755: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1756:
1757: denorm_market_for_one_budget (
1758: p_budget_id => p_actbudget_id,
1759: x_budget_mark => l_budget_mark,

Line 1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1784: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
1785: CLOSE c_get_offer_customer;
1786:
1787: FND_DSQL.init;
1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1789: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1790:
1791: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1792: -- for lumpsum and scandata, market eligibility can be only one customer

Line 1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

1966: set org id since for customer bill to, denorm query on org-striped table ra_addresses party,ra_site_uses
1967: */
1968: --set_budget_org(p_budget_id => p_actbudget_id);
1969:
1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1971:
1972: FND_DSQL.init;
1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');

Line 1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1969:
1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1971:
1972: FND_DSQL.init;
1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1975:
1976: OPEN c_get_budget_market_qualifiers('N');
1977:

Line 2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2053: --dbms_output.put_line(l_ignore);
2054: END IF;
2055:
2056: FND_DSQL.init;
2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2058: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2059:
2060: OPEN c_get_budget_market_qualifiers('Y');
2061: -- Get all excluded market qualifiers for 'FUND'

Line 2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2152: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
2153: CLOSE c_get_offer_customer;
2154:
2155: FND_DSQL.init;
2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2157: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2158:
2159: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
2160: -- for lumpsum and scandata, market eligibility can be only one customer

Line 2260: -- CREATE GLOBAL TEMPORARY TABLE ozf_temp_eligibility(

2256: -- validate whether a budget is qualified to fund an offer in terms of
2257: -- market and product eligibility
2258: -- History
2259: -- Created yzhao 01/22/2002
2260: -- CREATE GLOBAL TEMPORARY TABLE ozf_temp_eligibility(
2261: -- OBJECT_TYPE VARCHAR2(30),
2262: -- ELIGIBILITY_ID NUMBER,
2263: -- EXCLUDE_FLAG VARCHAR2(1))
2264: -- ON COMMIT DELETE ROWS;

Line 2614: FROM ozf_temp_eligibility

2610: SELECT 1
2611: FROM dual
2612: WHERE (EXISTS
2613: (SELECT 1
2614: FROM ozf_temp_eligibility
2615: WHERE object_type = 'FUND'
2616: AND exclude_flag = 'N'
2617: AND eligibility_id = p_item_id))
2618: AND (

Line 2621: FROM ozf_temp_eligibility

2617: AND eligibility_id = p_item_id))
2618: AND (
2619: NOT EXISTS
2620: (SELECT 1
2621: FROM ozf_temp_eligibility
2622: WHERE object_type = 'FUND'
2623: AND exclude_flag = 'Y'
2624: AND eligibility_id = p_item_id));
2625:

Line 2628: FROM ozf_temp_eligibility

2624: AND eligibility_id = p_item_id));
2625:
2626: CURSOR c_check_exclude_items(p_item_id NUMBER) IS
2627: SELECT 1
2628: FROM ozf_temp_eligibility
2629: WHERE object_type = 'FUND'
2630: AND exclude_flag = 'Y'
2631: AND eligibility_id = p_item_id;
2632:

Line 2650: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

2646: OPEN c_get_party_id;
2647: FETCH c_get_party_id INTO l_party_id;
2648: CLOSE c_get_party_id;
2649:
2650: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
2651:
2652: denorm_market_for_one_budget (
2653: p_budget_id => p_budget_id,
2654: x_budget_mark => l_budget_mark,

Line 2707: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';

2703: END IF;
2704:
2705: l_temp_id := null;
2706: l_qualify_flag := false;
2707: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
2708:
2709: denorm_product_for_one_budget (
2710: p_budget_id => p_budget_id,
2711: x_budget_prod => l_budget_mark,