eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_GL_PKG dependencies on DBMS_SQL

Line 33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;

29:
30: BEGIN
31:
32: FOR i IN get_segments_used(p_chart_of_accounts_id,'GL#') LOOP --L1
33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;
34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);

Line 34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'

30: BEGIN
31:
32: FOR i IN get_segments_used(p_chart_of_accounts_id,'GL#') LOOP --L1
33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;
34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);

Line 35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)

31:
32: FOR i IN get_segments_used(p_chart_of_accounts_id,'GL#') LOOP --L1
33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;
34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);

Line 36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)

32: FOR i IN get_segments_used(p_chart_of_accounts_id,'GL#') LOOP --L1
33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;
34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);
40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);

Line 37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);

33: v_segment_cur := DBMS_SQL.OPEN_CURSOR;
34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);
40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);
41:

Line 38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);

34: DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);
40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);
41:
42: IF v_account_number IS NOT NULL AND v_segment IS NOT NULL THEN

Line 39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);

35: ||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);
40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);
41:
42: IF v_account_number IS NOT NULL AND v_segment IS NOT NULL THEN
43: v_account_number := v_account_number||'-'||v_segment;

Line 40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);

36: DBMS_SQL.BIND_VARIABLE(v_segment_cur,':p_ccid',p_ccid); -- Added by Brathod, for 4407184 (Bind Var)
37: DBMS_SQL.DEFINE_COLUMN(v_segment_cur, 1, v_segment, 1000);
38: v_execute := DBMS_SQL.EXECUTE(v_segment_cur);
39: v_rows := DBMS_SQL.FETCH_ROWS(v_segment_cur);
40: DBMS_SQL.COLUMN_VALUE(v_segment_cur, 1, v_segment);
41:
42: IF v_account_number IS NOT NULL AND v_segment IS NOT NULL THEN
43: v_account_number := v_account_number||'-'||v_segment;
44: ELSIF v_account_number IS NULL AND v_segment IS NOT NULL THEN

Line 47: DBMS_SQL.CLOSE_CURSOR(v_segment_cur);

43: v_account_number := v_account_number||'-'||v_segment;
44: ELSIF v_account_number IS NULL AND v_segment IS NOT NULL THEN
45: v_account_number := v_segment;
46: END IF;
47: DBMS_SQL.CLOSE_CURSOR(v_segment_cur);
48: END LOOP; --L1
49: p_account_number := v_account_number;
50: EXCEPTION
51: WHEN OTHERS THEN

Line 52: IF dbms_sql.is_open(v_segment_cur) THEN

48: END LOOP; --L1
49: p_account_number := v_account_number;
50: EXCEPTION
51: WHEN OTHERS THEN
52: IF dbms_sql.is_open(v_segment_cur) THEN
53: dbms_sql.close_cursor(v_segment_cur);
54: END IF;
55: END get_account_number ;
56:

Line 53: dbms_sql.close_cursor(v_segment_cur);

49: p_account_number := v_account_number;
50: EXCEPTION
51: WHEN OTHERS THEN
52: IF dbms_sql.is_open(v_segment_cur) THEN
53: dbms_sql.close_cursor(v_segment_cur);
54: END IF;
55: END get_account_number ;
56:
57: PROCEDURE create_gl_entry