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 885: l_denorm_csr := DBMS_SQL.open_cursor;

881: FND_DSQL.add_text(')');
882:
883: IF x_budget_prod THEN
884:
885: l_denorm_csr := DBMS_SQL.open_cursor;
886: FND_DSQL.set_cursor(l_denorm_csr);
887:
888: l_stmt_denorm := FND_DSQL.get_text(FALSE);
889: --dbms_output.put_line('budget query:' || l_stmt_denorm);

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

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

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

888: l_stmt_denorm := FND_DSQL.get_text(FALSE);
889: --dbms_output.put_line('budget query:' || l_stmt_denorm);
890: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
891: FND_DSQL.do_binds;
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) ');

Line 939: l_denorm_csr := DBMS_SQL.open_cursor;

935: CLOSE c_get_products;
936: FND_DSQL.add_text(')');
937:
938: IF x_exclude_prod THEN
939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;

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

938: IF x_exclude_prod THEN
939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;
944: l_ignore := DBMS_SQL.execute(l_denorm_csr);
945: END IF;
946:

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

940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;
944: l_ignore := DBMS_SQL.execute(l_denorm_csr);
945: END IF;
946:
947: EXCEPTION
948: WHEN OTHERS THEN

Line 1071: l_denorm_csr := DBMS_SQL.open_cursor;

1067: CLOSE c_get_budget_market_qualifiers;
1068: FND_DSQL.add_text(')');
1069:
1070: IF x_budget_mark THEN
1071: l_denorm_csr := DBMS_SQL.open_cursor;
1072: FND_DSQL.set_cursor(l_denorm_csr);
1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1074: -- l_budget_market_sql := l_stmt_denorm;
1075: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

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

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

1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1074: -- l_budget_market_sql := l_stmt_denorm;
1075: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1076: FND_DSQL.do_binds;
1077: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1078: --dbms_output.put_line(l_ignore);
1079: END IF;
1080:
1081: FND_DSQL.init;

Line 1153: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 1324: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 1497: l_denorm_csr := DBMS_SQL.open_cursor;

1493: CLOSE c_get_budget_products;
1494: FND_DSQL.add_text(')');
1495:
1496: IF l_budget_prod THEN
1497: l_denorm_csr := DBMS_SQL.open_cursor;
1498: FND_DSQL.set_cursor(l_denorm_csr);
1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1500: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1501: FND_DSQL.do_binds;

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

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

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

1498: FND_DSQL.set_cursor(l_denorm_csr);
1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1500: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1501: FND_DSQL.do_binds;
1502: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1503: --dbms_output.put_line(l_ignore);
1504: END IF;
1505:
1506: FND_DSQL.init;

Line 1551: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 1638: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

1639: FND_DSQL.set_cursor(l_denorm_csr);
1640: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1641: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1642: FND_DSQL.do_binds;
1643: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1644: --dbms_output.put_line(l_ignore);
1645: END IF;
1646:
1647: l_exist_number := NULL;

Line 1838: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 2046: l_denorm_csr := DBMS_SQL.open_cursor;

2042: CLOSE c_get_budget_market_qualifiers;
2043: FND_DSQL.add_text(')');
2044:
2045: IF l_budget_mark THEN
2046: l_denorm_csr := DBMS_SQL.open_cursor;
2047: FND_DSQL.set_cursor(l_denorm_csr);
2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2049: l_budget_market_sql := l_stmt_denorm;
2050: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

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

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

2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2049: l_budget_market_sql := l_stmt_denorm;
2050: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2051: FND_DSQL.do_binds;
2052: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2053: --dbms_output.put_line(l_ignore);
2054: END IF;
2055:
2056: FND_DSQL.init;

Line 2128: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 2207: l_denorm_csr := DBMS_SQL.open_cursor;

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

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

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

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

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