DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on FND_DSQL

Line 1201: FND_DSQL.set_cursor(l_emp_csr);

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);
1205: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );

Line 1223: FND_DSQL.do_binds;

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:
1225: l_ignore := DBMS_SQL.execute(l_emp_csr);
1226: LOOP
1227: FND_MSG_PUB.initialize;