DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on FND_DSQL

Line 1147: FND_DSQL.set_cursor(l_emp_csr);

1143: OZF_UTILITY_PVT.write_conc_log;
1144: END IF;
1145:
1146: l_emp_csr := DBMS_SQL.open_cursor;
1147: FND_DSQL.set_cursor(l_emp_csr);
1148: DBMS_SQL.parse(l_emp_csr, l_stmt, DBMS_SQL.native);
1149: DBMS_SQL.define_column(l_emp_csr, 1, l_offer_pay_method, 30);
1150: DBMS_SQL.define_column(l_emp_csr, 2, l_amount);
1151: DBMS_SQL.define_column(l_emp_csr, 3, l_utiz_currency, 15 );

Line 1169: FND_DSQL.do_binds;

1165: ELSIF NVL(p_group_by_offer,'N') = 'Y' AND p_customer_id IS NOT NULL THEN
1166: DBMS_SQL.define_column(l_emp_csr, 5, l_plan_id);
1167: END IF;
1168:
1169: FND_DSQL.do_binds;
1170:
1171: l_ignore := DBMS_SQL.execute(l_emp_csr);
1172: LOOP
1173: FND_MSG_PUB.initialize;