APPS.CN_COLLECT_ORDERS dependencies on DBMS_SQL

Line 40: c := dbms_sql.open_cursor;

36: x_org_id NUMBER;
37:
38: BEGIN
39:
40: c := dbms_sql.open_cursor;
41:
42: x_org_id := mo_global.get_current_org_id;
43:
44: get_org_append(x_org_id);

Line 49: dbms_sql.parse(c, STATEMENT, dbms_sql.native);

45:
46: STATEMENT := 'begin CN_COLLECT_ORDERS'||cached_org_append||
47: '.collect(:err,:ret,:start,:end,:orgid); end;';
48:
49: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
50:
51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);

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

47: '.collect(:err,:ret,:start,:end,:orgid); end;';
48:
49: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
50:
51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);

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

48:
49: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
50:
51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:

Line 53: dbms_sql.bind_variable(c,'start', x_start_period_name);

49: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
50:
51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:
57: rows_processed := dbms_sql.EXECUTE(c);

Line 54: dbms_sql.bind_variable(c,'end', x_end_period_name);

50:
51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:
57: rows_processed := dbms_sql.EXECUTE(c);
58:

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

51: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
52: dbms_sql.bind_variable(c,'ret', dummy_num);
53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:
57: rows_processed := dbms_sql.EXECUTE(c);
58:
59: dbms_sql.variable_value(c,'err', errbuf);

Line 57: rows_processed := dbms_sql.EXECUTE(c);

53: dbms_sql.bind_variable(c,'start', x_start_period_name);
54: dbms_sql.bind_variable(c,'end', x_end_period_name);
55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:
57: rows_processed := dbms_sql.EXECUTE(c);
58:
59: dbms_sql.variable_value(c,'err', errbuf);
60: dbms_sql.variable_value(c,'ret', retcode);
61:

Line 59: dbms_sql.variable_value(c,'err', errbuf);

55: dbms_sql.bind_variable(c,'orgid',x_org_id);
56:
57: rows_processed := dbms_sql.EXECUTE(c);
58:
59: dbms_sql.variable_value(c,'err', errbuf);
60: dbms_sql.variable_value(c,'ret', retcode);
61:
62: dbms_sql.close_cursor(c);
63:

Line 60: dbms_sql.variable_value(c,'ret', retcode);

56:
57: rows_processed := dbms_sql.EXECUTE(c);
58:
59: dbms_sql.variable_value(c,'err', errbuf);
60: dbms_sql.variable_value(c,'ret', retcode);
61:
62: dbms_sql.close_cursor(c);
63:
64: END COLLECT;

Line 62: dbms_sql.close_cursor(c);

58:
59: dbms_sql.variable_value(c,'err', errbuf);
60: dbms_sql.variable_value(c,'ret', retcode);
61:
62: dbms_sql.close_cursor(c);
63:
64: END COLLECT;
65:
66: