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_OFFR_ELIG_PROD_DENORM_PVT

Line 856: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

852: END IF;
853:
854: IF c_get_products%ROWCOUNT = 1 THEN -- for first row.
855: FND_DSQL.add_text('(');
856: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
857: ( p_context => 'ITEM',
858: p_attribute => l_attribute,
859: p_attr_value_from => l_attr_value,
860: p_attr_value_to => NULL,

Line 867: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

863: );
864: FND_DSQL.add_text(')');
865: ELSE
866: FND_DSQL.add_text('UNION (');
867: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
868: ( p_context => 'ITEM',
869: p_attribute => l_attribute,
870: p_attr_value_from => l_attr_value,
871: p_attr_value_to => NULL,

Line 911: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

907:
908: IF c_get_products%ROWCOUNT = 1 THEN
909: -- l_exclude_sql := '(' || l_temp_sql || ')';
910: FND_DSQL.add_text('(');
911: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
912: ( p_context => 'ITEM',
913: p_attribute => l_attribute,
914: p_attr_value_from => l_attr_value,
915: p_attr_value_to => NULL,

Line 923: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

919: FND_DSQL.add_text(')');
920: ELSE
921: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
922: FND_DSQL.add_text('UNION (');
923: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
924: ( p_context => 'ITEM',
925: p_attribute => l_attribute,
926: p_attr_value_from => l_attr_value,
927: p_attr_value_to => NULL,

Line 1042: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1038:
1039: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1040: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1041: FND_DSQL.add_text('(');
1042: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1043: ( p_context => l_context,
1044: p_attribute => l_attribute,
1045: p_attr_value_from => l_attr_value,
1046: p_attr_value_to => NULL,

Line 1054: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1050: FND_DSQL.add_text(')');
1051: ELSE
1052: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1053: FND_DSQL.add_text('UNION (');
1054: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1055: ( p_context => l_context,
1056: p_attribute => l_attribute,
1057: p_attr_value_from => l_attr_value,
1058: p_attr_value_to => NULL,

Line 1126: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1122:
1123: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1124: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1125: FND_DSQL.add_text('(');
1126: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1127: ( p_context => l_context,
1128: p_attribute => l_attribute,
1129: p_attr_value_from => l_attr_value,
1130: p_attr_value_to => NULL,

Line 1138: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1134: FND_DSQL.add_text(')');
1135: ELSE
1136: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1137: FND_DSQL.add_text('UNION (');
1138: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1139: ( p_context => l_context,
1140: p_attribute => l_attribute,
1141: p_attr_value_from => l_attr_value,
1142: p_attr_value_to => NULL,

Line 1270: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1266:
1267: IF c_get_products%ROWCOUNT = 1 THEN
1268: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1269: FND_DSQL.add_text('(');
1270: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1271: ( p_context => 'ITEM',
1272: p_attribute => l_attribute,
1273: p_attr_value_from => l_attr_value,
1274: p_attr_value_to => NULL,

Line 1282: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1278: FND_DSQL.add_text(')');
1279: ELSE
1280: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1281: FND_DSQL.add_text('UNION (');
1282: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1283: ( p_context => 'ITEM',
1284: p_attribute => l_attribute,
1285: p_attr_value_from => l_attr_value,
1286: p_attr_value_to => NULL,

Line 1297: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_products(

1293: CLOSE c_get_products;
1294:
1295: ELSE -- for other offer,
1296: -- get offer's product eligibility query
1297: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_products(
1298: p_api_version => 1.0,
1299: p_init_msg_list => fnd_api.g_false,
1300: p_commit => fnd_api.g_false,
1301: p_list_header_id => p_object_id,

Line 1468: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1464: END IF;
1465:
1466: IF c_get_budget_products%ROWCOUNT = 1 THEN -- for first row.
1467: FND_DSQL.add_text('(');
1468: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1469: ( p_context => 'ITEM',
1470: p_attribute => l_attribute,
1471: p_attr_value_from => l_attr_value,
1472: p_attr_value_to => NULL,

Line 1479: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1475: );
1476: FND_DSQL.add_text(')');
1477: ELSE
1478: FND_DSQL.add_text('UNION (');
1479: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1480: ( p_context => 'ITEM',
1481: p_attribute => l_attribute,
1482: p_attr_value_from => l_attr_value,
1483: p_attr_value_to => NULL,

Line 1523: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1519:
1520: IF c_get_budget_products%ROWCOUNT = 1 THEN
1521: -- l_exclude_sql := '(' || l_temp_sql || ')';
1522: FND_DSQL.add_text('(');
1523: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1524: ( p_context => 'ITEM',
1525: p_attribute => l_attribute,
1526: p_attr_value_from => l_attr_value,
1527: p_attr_value_to => NULL,

Line 1535: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1531: FND_DSQL.add_text(')');
1532: ELSE
1533: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
1534: FND_DSQL.add_text('UNION (');
1535: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1536: ( p_context => 'ITEM',
1537: p_attribute => l_attribute,
1538: p_attr_value_from => l_attr_value,
1539: p_attr_value_to => NULL,

Line 1586: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1582:
1583: IF c_get_offer_products%ROWCOUNT = 1 THEN
1584: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1585: FND_DSQL.add_text('(');
1586: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1587: ( p_context => 'ITEM',
1588: p_attribute => l_attribute,
1589: p_attr_value_from => l_attr_value,
1590: p_attr_value_to => NULL,

Line 1598: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1594: FND_DSQL.add_text(')');
1595: ELSE
1596: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1597: FND_DSQL.add_text('UNION (');
1598: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1599: ( p_context => 'ITEM',
1600: p_attribute => l_attribute,
1601: p_attr_value_from => l_attr_value,
1602: p_attr_value_to => NULL,

Line 1613: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_products(

1609: CLOSE c_get_offer_products;
1610:
1611: ELSE -- for other offer,
1612: -- get offer's product eligibility query
1613: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_products(
1614: p_api_version => 1.0,
1615: p_init_msg_list => fnd_api.g_false,
1616: p_commit => fnd_api.g_false,
1617: p_list_header_id => p_object_id,

Line 1804: l_offer_market_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

1800: l_offer_mark := TRUE;
1801: l_context := 'CUSTOMER'; -- same as customer sold to
1802: l_attribute := 'QUALIFIER_ATTRIBUTE2';
1803: l_attr_value := l_offer_qualifier_id;
1804: l_offer_market_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1805: ( p_context => l_context,
1806: p_attribute => l_attribute,
1807: p_attr_value_from => l_attr_value,
1808: p_attr_value_to => NULL,

Line 1815: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_parties(

1811: );
1812: END IF;
1813: ELSE
1814: -- get offer's market eligibility query
1815: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_parties(
1816: p_api_version => 1.0,
1817: p_init_msg_list => fnd_api.g_false,
1818: p_commit => fnd_api.g_false,
1819: p_list_header_id => p_object_id,

Line 2017: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

2013:
2014: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2015: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2016: FND_DSQL.add_text('(');
2017: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2018: ( p_context => l_context,
2019: p_attribute => l_attribute,
2020: p_attr_value_from => l_attr_value,
2021: p_attr_value_to => NULL,

Line 2029: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

2025: FND_DSQL.add_text(')');
2026: ELSE
2027: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2028: FND_DSQL.add_text('UNION (');
2029: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2030: ( p_context => l_context,
2031: p_attribute => l_attribute,
2032: p_attr_value_from => l_attr_value,
2033: p_attr_value_to => NULL,

Line 2100: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

2096:
2097: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2098: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2099: FND_DSQL.add_text('(');
2100: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2101: ( p_context => l_context,
2102: p_attribute => l_attribute,
2103: p_attr_value_from => l_attr_value,
2104: p_attr_value_to => NULL,

Line 2112: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

2108: FND_DSQL.add_text(')');
2109: ELSE
2110: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2111: FND_DSQL.add_text('UNION (');
2112: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2113: ( p_context => l_context,
2114: p_attribute => l_attribute,
2115: p_attr_value_from => l_attr_value,
2116: p_attr_value_to => NULL,

Line 2172: l_offer_market_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

2168: l_offer_mark := TRUE;
2169: l_context := 'CUSTOMER'; -- same as customer sold to
2170: l_attribute := 'QUALIFIER_ATTRIBUTE2';
2171: l_attr_value := l_offer_qualifier_id;
2172: l_offer_market_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2173: ( p_context => l_context,
2174: p_attribute => l_attribute,
2175: p_attr_value_from => l_attr_value,
2176: p_attr_value_to => NULL,

Line 2183: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_parties(

2179: );
2180: END IF;
2181: ELSE
2182: -- get offer's market eligibility query
2183: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_parties(
2184: p_api_version => 1.0,
2185: p_init_msg_list => fnd_api.g_false,
2186: p_commit => fnd_api.g_false,
2187: p_list_header_id => p_object_id,