APPS.JL_AR_RECUR_PKG dependencies on DBMS_SQL

Line 56: l_trx_num_cursor := dbms_sql.open_cursor;

52: ELSE
53: l_org_str := NULL;
54: END IF;
55:
56: l_trx_num_cursor := dbms_sql.open_cursor;
57:
58: dbms_sql.parse(l_trx_num_cursor,
59: 'select ra_trx_number_' ||
60: REPLACE(p_batch_source_id, '-', 'N') ||

Line 58: dbms_sql.parse(l_trx_num_cursor,

54: END IF;
55:
56: l_trx_num_cursor := dbms_sql.open_cursor;
57:
58: dbms_sql.parse(l_trx_num_cursor,
59: 'select ra_trx_number_' ||
60: REPLACE(p_batch_source_id, '-', 'N') ||
61: l_org_str||
62: '_s.nextval trx_number ' ||

Line 67: dbms_sql.v7);

63: 'from ra_batch_sources ' ||
64: 'where batch_source_id = ' ||
65: p_batch_source_id ||
66: ' and auto_trx_numbering_flag = ''Y''',
67: dbms_sql.v7);
68:
69: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
70:
71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);

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

65: p_batch_source_id ||
66: ' and auto_trx_numbering_flag = ''Y''',
67: dbms_sql.v7);
68:
69: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
70:
71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
72:
73: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);

Line 71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);

67: dbms_sql.v7);
68:
69: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
70:
71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
72:
73: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
74:
75: dbms_sql.close_cursor(l_trx_num_cursor);

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

69: dbms_sql.define_column(l_trx_num_cursor, 1, l_trx_number, 20);
70:
71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
72:
73: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
74:
75: dbms_sql.close_cursor(l_trx_num_cursor);
76:
77: --

Line 75: dbms_sql.close_cursor(l_trx_num_cursor);

71: l_dummy := dbms_sql.execute_and_fetch(l_trx_num_cursor, TRUE);
72:
73: dbms_sql.column_value(l_trx_num_cursor, 1, l_trx_number);
74:
75: dbms_sql.close_cursor(l_trx_num_cursor);
76:
77: --
78: -- Overwrite transaction number and date for Argentina
79: --