APPS.JL_AR_AR_PREFIX_TRX_NUM dependencies on DBMS_SQL

Line 49: l_trx_num_cursor := dbms_sql.open_cursor;

45: WHERE batch_source_id = p_batch_source_id;
46:
47: IF l_batch_source_type = 'INV' THEN
48:
49: l_trx_num_cursor := dbms_sql.open_cursor;
50:
51: dbms_sql.parse(l_trx_num_cursor,
52: 'select ra_trx_number_' ||
53: to_char(l_imported_source_id) ||

Line 51: dbms_sql.parse(l_trx_num_cursor,

47: IF l_batch_source_type = 'INV' THEN
48:
49: l_trx_num_cursor := dbms_sql.open_cursor;
50:
51: dbms_sql.parse(l_trx_num_cursor,
52: 'select ra_trx_number_' ||
53: to_char(l_imported_source_id) ||
54: '_' ||
55: to_char(l_org_id)||

Line 58: dbms_sql.NATIVE);

54: '_' ||
55: to_char(l_org_id)||
56: '_s.nextval trx_number ' ||
57: 'from dual ',
58: dbms_sql.NATIVE);
59:
60: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
61:
62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);

Line 60: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);

56: '_s.nextval trx_number ' ||
57: 'from dual ',
58: dbms_sql.NATIVE);
59:
60: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
61:
62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);
63:
64: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);

Line 62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);

58: dbms_sql.NATIVE);
59:
60: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
61:
62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);
63:
64: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
65:
66: dbms_sql.close_cursor(l_trx_num_cursor);

Line 64: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);

60: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
61:
62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);
63:
64: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
65:
66: dbms_sql.close_cursor(l_trx_num_cursor);
67:
68: SELECT substr(global_attribute2,1,4),

Line 66: dbms_sql.close_cursor(l_trx_num_cursor);

62: l_count := dbms_sql.execute_and_fetch(l_trx_num_cursor,TRUE);
63:
64: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
65:
66: dbms_sql.close_cursor(l_trx_num_cursor);
67:
68: SELECT substr(global_attribute2,1,4),
69: substr(global_attribute3,1,1),
70: to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')