APPS.CN_COLLECT_RAM dependencies on DBMS_SQL

Line 44: c := dbms_sql.open_cursor;

40: x_org_id NUMBER;
41:
42: begin
43:
44: c := dbms_sql.open_cursor;
45:
46: x_org_id := mo_global.get_current_org_id;
47:
48: get_org_append(x_org_id);

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

49:
50: statement := 'begin cn_collect_ram'||cached_org_append||
51: '.collect(:err,:ret,:start,:end,:orgid); end;';
52:
53: dbms_sql.parse(c, statement, dbms_sql.native);
54:
55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);

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

51: '.collect(:err,:ret,:start,:end,:orgid); end;';
52:
53: dbms_sql.parse(c, statement, dbms_sql.native);
54:
55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);

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

52:
53: dbms_sql.parse(c, statement, dbms_sql.native);
54:
55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:

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

53: dbms_sql.parse(c, statement, dbms_sql.native);
54:
55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:
61: rows_processed := dbms_sql.execute(c);

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

54:
55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:
61: rows_processed := dbms_sql.execute(c);
62:

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

55: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
56: dbms_sql.bind_variable(c,'ret', dummy_num);
57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:
61: rows_processed := dbms_sql.execute(c);
62:
63: dbms_sql.variable_value(c,'err', errbuf);

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

57: dbms_sql.bind_variable(c,'start', x_start_period_name);
58: dbms_sql.bind_variable(c,'end', x_end_period_name);
59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:
61: rows_processed := dbms_sql.execute(c);
62:
63: dbms_sql.variable_value(c,'err', errbuf);
64: dbms_sql.variable_value(c,'ret', retcode);
65:

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

59: dbms_sql.bind_variable(c,'orgid', x_org_id);
60:
61: rows_processed := dbms_sql.execute(c);
62:
63: dbms_sql.variable_value(c,'err', errbuf);
64: dbms_sql.variable_value(c,'ret', retcode);
65:
66: dbms_sql.close_cursor(c);
67:

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

60:
61: rows_processed := dbms_sql.execute(c);
62:
63: dbms_sql.variable_value(c,'err', errbuf);
64: dbms_sql.variable_value(c,'ret', retcode);
65:
66: dbms_sql.close_cursor(c);
67:
68: end collect;

Line 66: dbms_sql.close_cursor(c);

62:
63: dbms_sql.variable_value(c,'err', errbuf);
64: dbms_sql.variable_value(c,'ret', retcode);
65:
66: dbms_sql.close_cursor(c);
67:
68: end collect;
69:
70: END cn_collect_ram;