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_AUTOPAY_PVT dependencies on DBMS_SQL

Line 1200: l_emp_csr := DBMS_SQL.open_cursor;

1196: IF OZF_DEBUG_LOW_ON THEN
1197: OZF_UTILITY_PVT.write_conc_log;
1198: END IF;
1199:
1200: l_emp_csr := DBMS_SQL.open_cursor;
1201: FND_DSQL.set_cursor(l_emp_csr);
1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);

Line 1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);

1198: END IF;
1199:
1200: l_emp_csr := DBMS_SQL.open_cursor;
1201: FND_DSQL.set_cursor(l_emp_csr);
1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);
1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );
1206:

Line 1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);

1199:
1200: l_emp_csr := DBMS_SQL.open_cursor;
1201: FND_DSQL.set_cursor(l_emp_csr);
1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);
1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );
1206:
1207:

Line 1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);

1200: l_emp_csr := DBMS_SQL.open_cursor;
1201: FND_DSQL.set_cursor(l_emp_csr);
1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);
1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );
1206:
1207:
1208: --R12.1 enhancement add l_bill_to_site_use_id and fetch its value

Line 1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );

1201: FND_DSQL.set_cursor(l_emp_csr);
1202: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1203: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1204: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);
1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );
1206:
1207:
1208: --R12.1 enhancement add l_bill_to_site_use_id and fetch its value
1209: -- This will be used to group the customer earnings.

Line 1210: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_use_id );

1206:
1207:
1208: --R12.1 enhancement add l_bill_to_site_use_id and fetch its value
1209: -- This will be used to group the customer earnings.
1210: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_use_id );
1211:
1212:
1213: IF p_customer_id IS NULL THEN
1214: DBMS_SQL.define_column(l_emp_csr, 5, l_cust_account_id);

Line 1214: DBMS_SQL.define_column(l_emp_csr, 5, l_cust_account_id);

1210: DBMS_SQL.define_column(l_emp_csr, 4, l_bill_to_site_use_id );
1211:
1212:
1213: IF p_customer_id IS NULL THEN
1214: DBMS_SQL.define_column(l_emp_csr, 5, l_cust_account_id);
1215: END IF;
1216:
1217: IF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NULL THEN
1218: DBMS_SQL.define_column(l_emp_csr, 6, l_plan_id);

Line 1218: DBMS_SQL.define_column(l_emp_csr, 6, l_plan_id);

1214: DBMS_SQL.define_column(l_emp_csr, 5, l_cust_account_id);
1215: END IF;
1216:
1217: IF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NULL THEN
1218: DBMS_SQL.define_column(l_emp_csr, 6, l_plan_id);
1219: ELSIF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NOT NULL THEN
1220: DBMS_SQL.define_column(l_emp_csr, 5, l_plan_id);
1221: END IF;
1222:

Line 1220: DBMS_SQL.define_column(l_emp_csr, 5, l_plan_id);

1216:
1217: IF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NULL THEN
1218: DBMS_SQL.define_column(l_emp_csr, 6, l_plan_id);
1219: ELSIF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NOT NULL THEN
1220: DBMS_SQL.define_column(l_emp_csr, 5, l_plan_id);
1221: END IF;
1222:
1223: FND_DSQL.do_binds;
1224:

Line 1225: l_ignore := DBMS_SQL.execute(l_emp_csr);

1221: END IF;
1222:
1223: FND_DSQL.do_binds;
1224:
1225: l_ignore := DBMS_SQL.execute(l_emp_csr);
1226: LOOP
1227: FND_MSG_PUB.initialize;
1228:
1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

Line 1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN

1225: l_ignore := DBMS_SQL.execute(l_emp_csr);
1226: LOOP
1227: FND_MSG_PUB.initialize;
1228:
1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);
1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa

Line 1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);

1226: LOOP
1227: FND_MSG_PUB.initialize;
1228:
1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);
1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa
1234:

Line 1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);

1227: FND_MSG_PUB.initialize;
1228:
1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);
1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa
1234:
1235: IF p_customer_id IS NULL THEN

Line 1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);

1228:
1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);
1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa
1234:
1235: IF p_customer_id IS NULL THEN
1236: DBMS_SQL.column_value(l_emp_csr, 5, l_cust_account_id);

Line 1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa

1229: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1230: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1231: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);
1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa
1234:
1235: IF p_customer_id IS NULL THEN
1236: DBMS_SQL.column_value(l_emp_csr, 5, l_cust_account_id);
1237: ELSE

Line 1236: DBMS_SQL.column_value(l_emp_csr, 5, l_cust_account_id);

1232: DBMS_SQL.column_value(l_emp_csr, 3, l_utiz_currency);
1233: DBMS_SQL.column_value(l_emp_csr, 4, l_bill_to_site_use_id); --R12.1 enhancement nirprasa
1234:
1235: IF p_customer_id IS NULL THEN
1236: DBMS_SQL.column_value(l_emp_csr, 5, l_cust_account_id);
1237: ELSE
1238: l_cust_account_id := p_customer_id;
1239: END IF;
1240:

Line 1242: DBMS_SQL.column_value(l_emp_csr, 6, l_plan_id);

1238: l_cust_account_id := p_customer_id;
1239: END IF;
1240:
1241: IF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NULL THEN
1242: DBMS_SQL.column_value(l_emp_csr, 6, l_plan_id);
1243: l_funds_util_flt.activity_id := l_plan_id;
1244: ELSIF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NOT NULL THEN
1245: DBMS_SQL.column_value(l_emp_csr, 5, l_plan_id);
1246: l_funds_util_flt.activity_id := l_plan_id;

Line 1245: DBMS_SQL.column_value(l_emp_csr, 5, l_plan_id);

1241: IF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NULL THEN
1242: DBMS_SQL.column_value(l_emp_csr, 6, l_plan_id);
1243: l_funds_util_flt.activity_id := l_plan_id;
1244: ELSIF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NOT NULL THEN
1245: DBMS_SQL.column_value(l_emp_csr, 5, l_plan_id);
1246: l_funds_util_flt.activity_id := l_plan_id;
1247: -- Fix for multi currency --kpatro
1248: ELSIF (NVL(p_group_by_offer,'N') = 'N' AND p_customer_id IS NOT NULL AND p_plan_id IS NOT NULL) THEN
1249: l_funds_util_flt.activity_id := p_plan_id;

Line 1503: DBMS_SQL.close_cursor(l_emp_csr);

1499: EXIT;
1500: END IF;
1501: END LOOP;
1502: --CLOSE l_emp_csr;
1503: DBMS_SQL.close_cursor(l_emp_csr);
1504:
1505: -- update the trade_profiles together
1506: FORALL i IN 1..l_trd_prof_tbl.COUNT
1507: UPDATE OZF_CUST_TRD_PRFLS_ALL