APPS.CN_COLLECT_INVOICES dependencies on DBMS_SQL

Line 53: c := dbms_sql.open_cursor;

49: x_org_id NUMBER;
50:
51: BEGIN
52:
53: c := dbms_sql.open_cursor;
54:
55: x_org_id := mo_global.get_current_org_id;
56:
57: get_org_append(x_org_id);

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

58:
59: STATEMENT := 'begin cn_collect_invoices'||cached_org_append||
60: '.collect(:err,:ret,:start,:end,:org); end;';
61:
62: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
63:
64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);

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

60: '.collect(:err,:ret,:start,:end,:org); end;';
61:
62: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
63:
64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);

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

61:
62: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
63:
64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);
69:

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

62: dbms_sql.parse(c, STATEMENT, dbms_sql.native);
63:
64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);
69:
70: rows_processed := dbms_sql.EXECUTE(c);

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

63:
64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);
69:
70: rows_processed := dbms_sql.EXECUTE(c);
71:

Line 68: dbms_sql.bind_variable(c,'org', x_org_id);

64: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
65: dbms_sql.bind_variable(c,'ret', dummy_num);
66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);
69:
70: rows_processed := dbms_sql.EXECUTE(c);
71:
72: dbms_sql.variable_value(c,'err', errbuf);

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

66: dbms_sql.bind_variable(c,'start', x_start_period_name);
67: dbms_sql.bind_variable(c,'end', x_end_period_name);
68: dbms_sql.bind_variable(c,'org', x_org_id);
69:
70: rows_processed := dbms_sql.EXECUTE(c);
71:
72: dbms_sql.variable_value(c,'err', errbuf);
73: dbms_sql.variable_value(c,'ret', retcode);
74:

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

68: dbms_sql.bind_variable(c,'org', x_org_id);
69:
70: rows_processed := dbms_sql.EXECUTE(c);
71:
72: dbms_sql.variable_value(c,'err', errbuf);
73: dbms_sql.variable_value(c,'ret', retcode);
74:
75: dbms_sql.close_cursor(c);
76:

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

69:
70: rows_processed := dbms_sql.EXECUTE(c);
71:
72: dbms_sql.variable_value(c,'err', errbuf);
73: dbms_sql.variable_value(c,'ret', retcode);
74:
75: dbms_sql.close_cursor(c);
76:
77: END COLLECT;

Line 75: dbms_sql.close_cursor(c);

71:
72: dbms_sql.variable_value(c,'err', errbuf);
73: dbms_sql.variable_value(c,'ret', retcode);
74:
75: dbms_sql.close_cursor(c);
76:
77: END COLLECT;
78:
79: