APPS.CN_COLLECT_CUSTOM dependencies on DBMS_SQL

Line 56: c := dbms_sql.open_cursor;

52:
53: --+
54: -- Use dynamic SQL to run the statement
55: --+
56: c := dbms_sql.open_cursor;
57:
58: dbms_sql.parse(c, statement, dbms_sql.native);
59:
60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);

Line 58: dbms_sql.parse(c, statement, dbms_sql.native);

54: -- Use dynamic SQL to run the statement
55: --+
56: c := dbms_sql.open_cursor;
57:
58: dbms_sql.parse(c, statement, dbms_sql.native);
59:
60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
61: dbms_sql.bind_variable(c,'ret', dummy_num);
62: dbms_sql.bind_variable(c,'orgid', x_org_id);

Line 60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);

56: c := dbms_sql.open_cursor;
57:
58: dbms_sql.parse(c, statement, dbms_sql.native);
59:
60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
61: dbms_sql.bind_variable(c,'ret', dummy_num);
62: dbms_sql.bind_variable(c,'orgid', x_org_id);
63:
64: rows_processed := dbms_sql.execute(c);

Line 61: dbms_sql.bind_variable(c,'ret', dummy_num);

57:
58: dbms_sql.parse(c, statement, dbms_sql.native);
59:
60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
61: dbms_sql.bind_variable(c,'ret', dummy_num);
62: dbms_sql.bind_variable(c,'orgid', x_org_id);
63:
64: rows_processed := dbms_sql.execute(c);
65:

Line 62: dbms_sql.bind_variable(c,'orgid', x_org_id);

58: dbms_sql.parse(c, statement, dbms_sql.native);
59:
60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
61: dbms_sql.bind_variable(c,'ret', dummy_num);
62: dbms_sql.bind_variable(c,'orgid', x_org_id);
63:
64: rows_processed := dbms_sql.execute(c);
65:
66: dbms_sql.variable_value(c,'err', x_errbuf);

Line 64: rows_processed := dbms_sql.execute(c);

60: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
61: dbms_sql.bind_variable(c,'ret', dummy_num);
62: dbms_sql.bind_variable(c,'orgid', x_org_id);
63:
64: rows_processed := dbms_sql.execute(c);
65:
66: dbms_sql.variable_value(c,'err', x_errbuf);
67: dbms_sql.variable_value(c,'ret', x_retcode);
68:

Line 66: dbms_sql.variable_value(c,'err', x_errbuf);

62: dbms_sql.bind_variable(c,'orgid', x_org_id);
63:
64: rows_processed := dbms_sql.execute(c);
65:
66: dbms_sql.variable_value(c,'err', x_errbuf);
67: dbms_sql.variable_value(c,'ret', x_retcode);
68:
69: dbms_sql.close_cursor(c);
70:

Line 67: dbms_sql.variable_value(c,'ret', x_retcode);

63:
64: rows_processed := dbms_sql.execute(c);
65:
66: dbms_sql.variable_value(c,'err', x_errbuf);
67: dbms_sql.variable_value(c,'ret', x_retcode);
68:
69: dbms_sql.close_cursor(c);
70:
71: END collect;

Line 69: dbms_sql.close_cursor(c);

65:
66: dbms_sql.variable_value(c,'err', x_errbuf);
67: dbms_sql.variable_value(c,'ret', x_retcode);
68:
69: dbms_sql.close_cursor(c);
70:
71: END collect;
72:
73: END cn_collect_custom;