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 DBMS_SQL

Line 881: l_denorm_csr := DBMS_SQL.open_cursor;

877: FND_DSQL.add_text(')');
878:
879: IF x_budget_prod THEN
880:
881: l_denorm_csr := DBMS_SQL.open_cursor;
882: FND_DSQL.set_cursor(l_denorm_csr);
883:
884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);

Line 886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

882: FND_DSQL.set_cursor(l_denorm_csr);
883:
884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);
886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
887: FND_DSQL.do_binds;
888: l_ignore := DBMS_SQL.execute(l_denorm_csr);
889: END IF;
890:

Line 888: l_ignore := DBMS_SQL.execute(l_denorm_csr);

884: l_stmt_denorm := FND_DSQL.get_text(FALSE);
885: --dbms_output.put_line('budget query:' || l_stmt_denorm);
886: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
887: FND_DSQL.do_binds;
888: l_ignore := DBMS_SQL.execute(l_denorm_csr);
889: END IF;
890:
891: FND_DSQL.init;
892: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

Line 935: l_denorm_csr := DBMS_SQL.open_cursor;

931: CLOSE c_get_products;
932: FND_DSQL.add_text(')');
933:
934: IF x_exclude_prod THEN
935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;

Line 938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

934: IF x_exclude_prod THEN
935: l_denorm_csr := DBMS_SQL.open_cursor;
936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;
940: l_ignore := DBMS_SQL.execute(l_denorm_csr);
941: END IF;
942:

Line 940: l_ignore := DBMS_SQL.execute(l_denorm_csr);

936: FND_DSQL.set_cursor(l_denorm_csr);
937: l_stmt_denorm := FND_DSQL.get_text(FALSE);
938: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
939: FND_DSQL.do_binds;
940: l_ignore := DBMS_SQL.execute(l_denorm_csr);
941: END IF;
942:
943: EXCEPTION
944: WHEN OTHERS THEN

Line 1067: l_denorm_csr := DBMS_SQL.open_cursor;

1063: CLOSE c_get_budget_market_qualifiers;
1064: FND_DSQL.add_text(')');
1065:
1066: IF x_budget_mark THEN
1067: l_denorm_csr := DBMS_SQL.open_cursor;
1068: FND_DSQL.set_cursor(l_denorm_csr);
1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1067: l_denorm_csr := DBMS_SQL.open_cursor;
1068: FND_DSQL.set_cursor(l_denorm_csr);
1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1072: FND_DSQL.do_binds;
1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1074: --dbms_output.put_line(l_ignore);
1075: END IF;

Line 1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1069: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1070: -- l_budget_market_sql := l_stmt_denorm;
1071: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1072: FND_DSQL.do_binds;
1073: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1074: --dbms_output.put_line(l_ignore);
1075: END IF;
1076:
1077: FND_DSQL.init;

Line 1149: l_denorm_csr := DBMS_SQL.open_cursor;

1145: END LOOP;
1146: CLOSE c_get_budget_market_qualifiers;
1147: FND_DSQL.add_text(')');
1148: IF x_exclude_mark THEN
1149: l_denorm_csr := DBMS_SQL.open_cursor;
1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1149: l_denorm_csr := DBMS_SQL.open_cursor;
1150: FND_DSQL.set_cursor(l_denorm_csr);
1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1154: FND_DSQL.do_binds;
1155: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1156: --dbms_output.put_line(l_ignore);
1157: END IF;

Line 1155: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1151: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1152: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1153: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1154: FND_DSQL.do_binds;
1155: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1156: --dbms_output.put_line(l_ignore);
1157: END IF;
1158:
1159: EXCEPTION

Line 1320: l_denorm_csr := DBMS_SQL.open_cursor;

1316: RETURN;
1317: END IF;
1318:
1319: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1320: l_denorm_csr := DBMS_SQL.open_cursor;
1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;

Line 1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1319: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1320: l_denorm_csr := DBMS_SQL.open_cursor;
1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;
1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1326: --dbms_output.put_line(l_ignore);
1327: END IF;

Line 1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1321: FND_DSQL.set_cursor(l_denorm_csr);
1322: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1323: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1324: FND_DSQL.do_binds;
1325: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1326: --dbms_output.put_line(l_ignore);
1327: END IF;
1328:
1329: --kdass 08/31/2005 fixed bug 4338544 - if offer has no products (can happen when the

Line 1493: l_denorm_csr := DBMS_SQL.open_cursor;

1489: CLOSE c_get_budget_products;
1490: FND_DSQL.add_text(')');
1491:
1492: IF l_budget_prod THEN
1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;

Line 1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1492: IF l_budget_prod THEN
1493: l_denorm_csr := DBMS_SQL.open_cursor;
1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;
1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1499: --dbms_output.put_line(l_ignore);
1500: END IF;

Line 1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1494: FND_DSQL.set_cursor(l_denorm_csr);
1495: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1496: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1497: FND_DSQL.do_binds;
1498: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1499: --dbms_output.put_line(l_ignore);
1500: END IF;
1501:
1502: FND_DSQL.init;

Line 1547: l_denorm_csr := DBMS_SQL.open_cursor;

1543: CLOSE c_get_budget_products;
1544: FND_DSQL.add_text(')');
1545:
1546: IF l_exclude_prod THEN
1547: l_denorm_csr := DBMS_SQL.open_cursor;
1548: FND_DSQL.set_cursor(l_denorm_csr);
1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1547: l_denorm_csr := DBMS_SQL.open_cursor;
1548: FND_DSQL.set_cursor(l_denorm_csr);
1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1552: FND_DSQL.do_binds;
1553: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1554: --dbms_output.put_line(l_ignore);
1555: END IF;

Line 1553: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1549: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1550: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1551: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1552: FND_DSQL.do_binds;
1553: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1554: --dbms_output.put_line(l_ignore);
1555: END IF;
1556: -- not product eligibility for budget, validation is true.
1557: IF l_budget_prod = FALSE AND l_exclude_prod = FALSE THEN

Line 1634: l_denorm_csr := DBMS_SQL.open_cursor;

1630: RETURN;
1631: END IF;
1632:
1633: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1634: l_denorm_csr := DBMS_SQL.open_cursor;
1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;

Line 1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1633: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1634: l_denorm_csr := DBMS_SQL.open_cursor;
1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;
1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1640: --dbms_output.put_line(l_ignore);
1641: END IF;

Line 1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1635: FND_DSQL.set_cursor(l_denorm_csr);
1636: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1637: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1638: FND_DSQL.do_binds;
1639: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1640: --dbms_output.put_line(l_ignore);
1641: END IF;
1642:
1643: l_exist_number := NULL;

Line 1834: l_denorm_csr := DBMS_SQL.open_cursor;

1830: x_return_status := fnd_api.g_ret_sts_success;
1831: x_valid_flag := fnd_api.g_false;
1832: RETURN;
1833: ELSE
1834: l_denorm_csr := DBMS_SQL.open_cursor;
1835: FND_DSQL.set_cursor(l_denorm_csr);
1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1834: l_denorm_csr := DBMS_SQL.open_cursor;
1835: FND_DSQL.set_cursor(l_denorm_csr);
1836: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1839: l_offer_market_sql := l_stmt_denorm;
1840: FND_DSQL.do_binds;
1841: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1842: --dbms_output.put_line(l_ignore);

Line 1841: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1837: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1838: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1839: l_offer_market_sql := l_stmt_denorm;
1840: FND_DSQL.do_binds;
1841: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1842: --dbms_output.put_line(l_ignore);
1843: END IF;
1844:
1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN

Line 2042: l_denorm_csr := DBMS_SQL.open_cursor;

2038: CLOSE c_get_budget_market_qualifiers;
2039: FND_DSQL.add_text(')');
2040:
2041: IF l_budget_mark THEN
2042: l_denorm_csr := DBMS_SQL.open_cursor;
2043: FND_DSQL.set_cursor(l_denorm_csr);
2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

2042: l_denorm_csr := DBMS_SQL.open_cursor;
2043: FND_DSQL.set_cursor(l_denorm_csr);
2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2047: FND_DSQL.do_binds;
2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2049: --dbms_output.put_line(l_ignore);
2050: END IF;

Line 2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);

2044: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2045: l_budget_market_sql := l_stmt_denorm;
2046: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2047: FND_DSQL.do_binds;
2048: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2049: --dbms_output.put_line(l_ignore);
2050: END IF;
2051:
2052: FND_DSQL.init;

Line 2124: l_denorm_csr := DBMS_SQL.open_cursor;

2120: CLOSE c_get_budget_market_qualifiers;
2121: FND_DSQL.add_text(')');
2122:
2123: IF l_exclude_mark THEN
2124: l_denorm_csr := DBMS_SQL.open_cursor;
2125: FND_DSQL.set_cursor(l_denorm_csr);
2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

2124: l_denorm_csr := DBMS_SQL.open_cursor;
2125: FND_DSQL.set_cursor(l_denorm_csr);
2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2129: FND_DSQL.do_binds;
2130: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2131: --dbms_output.put_line(l_ignore);
2132: END IF;

Line 2130: l_ignore := DBMS_SQL.execute(l_denorm_csr);

2126: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2127: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2128: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2129: FND_DSQL.do_binds;
2130: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2131: --dbms_output.put_line(l_ignore);
2132: END IF;
2133: -- not product eligibility for budget, validation is true.
2134: IF l_budget_mark = FALSE AND l_exclude_mark = FALSE THEN

Line 2203: l_denorm_csr := DBMS_SQL.open_cursor;

2199: x_return_status := fnd_api.g_ret_sts_success;
2200: x_valid_flag := fnd_api.g_false;
2201: RETURN;
2202: ELSE
2203: l_denorm_csr := DBMS_SQL.open_cursor;
2204: FND_DSQL.set_cursor(l_denorm_csr);
2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

2203: l_denorm_csr := DBMS_SQL.open_cursor;
2204: FND_DSQL.set_cursor(l_denorm_csr);
2205: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2208: l_offer_market_sql := l_stmt_denorm;
2209: FND_DSQL.do_binds;
2210: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2211: --dbms_output.put_line(l_ignore);

Line 2210: l_ignore := DBMS_SQL.execute(l_denorm_csr);

2206: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2207: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2208: l_offer_market_sql := l_stmt_denorm;
2209: FND_DSQL.do_binds;
2210: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2211: --dbms_output.put_line(l_ignore);
2212: END IF;
2213:
2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN