APPS.CN_CLASSIFICATION dependencies on DBMS_SQL

Line 30: c := dbms_sql.open_cursor;

26: rows_processed INTEGER;
27: statement VARCHAR2(1000);
28:
29: BEGIN
30: c := dbms_sql.open_cursor;
31:
32: statement := 'begin cn_classification'||cached_org_append||
33: '.classify_batch(:physical_batch_id,:process_audit_id);'||
34: 'end;';

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

32: statement := 'begin cn_classification'||cached_org_append||
33: '.classify_batch(:physical_batch_id,:process_audit_id);'||
34: 'end;';
35:
36: dbms_sql.parse(c, statement, dbms_sql.native);
37:
38: dbms_sql.bind_variable(c,'physical_batch_id', x_physical_batch_id);
39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);
40:

Line 38: dbms_sql.bind_variable(c,'physical_batch_id', x_physical_batch_id);

34: 'end;';
35:
36: dbms_sql.parse(c, statement, dbms_sql.native);
37:
38: dbms_sql.bind_variable(c,'physical_batch_id', x_physical_batch_id);
39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);
40:
41: rows_processed := dbms_sql.execute(c);
42:

Line 39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);

35:
36: dbms_sql.parse(c, statement, dbms_sql.native);
37:
38: dbms_sql.bind_variable(c,'physical_batch_id', x_physical_batch_id);
39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);
40:
41: rows_processed := dbms_sql.execute(c);
42:
43: dbms_sql.variable_value(c,'physical_batch_id', dummy);

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

37:
38: dbms_sql.bind_variable(c,'physical_batch_id', x_physical_batch_id);
39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);
40:
41: rows_processed := dbms_sql.execute(c);
42:
43: dbms_sql.variable_value(c,'physical_batch_id', dummy);
44: dbms_sql.variable_value(c,'process_audit_id', dummy);
45:

Line 43: dbms_sql.variable_value(c,'physical_batch_id', dummy);

39: dbms_sql.bind_variable(c,'process_audit_id', x_process_audit_id);
40:
41: rows_processed := dbms_sql.execute(c);
42:
43: dbms_sql.variable_value(c,'physical_batch_id', dummy);
44: dbms_sql.variable_value(c,'process_audit_id', dummy);
45:
46: dbms_sql.close_cursor(c);
47:

Line 44: dbms_sql.variable_value(c,'process_audit_id', dummy);

40:
41: rows_processed := dbms_sql.execute(c);
42:
43: dbms_sql.variable_value(c,'physical_batch_id', dummy);
44: dbms_sql.variable_value(c,'process_audit_id', dummy);
45:
46: dbms_sql.close_cursor(c);
47:
48:

Line 46: dbms_sql.close_cursor(c);

42:
43: dbms_sql.variable_value(c,'physical_batch_id', dummy);
44: dbms_sql.variable_value(c,'process_audit_id', dummy);
45:
46: dbms_sql.close_cursor(c);
47:
48:
49: END classify_batch;
50: