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.FUN_SEQ_BATCH dependencies on FUN_SEQ_CONTEXTS

Line 8: g_sort_option_code fun_seq_contexts.sort_option%TYPE;

4: -- For debuggin
5: --
6: g_module CONSTANT VARCHAR2(30) := 'fun.plsql.fun_seq_batch';
7: -- added global variable for sort by GL Date at posting event
8: g_sort_option_code fun_seq_contexts.sort_option%TYPE;
9: -- PROCEDURE NAME:
10: -- Batch_Init
11: -- *** For XLA Accounting Program ***
12: -- DESCRIPTION:

Line 51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

47: x_status OUT NOCOPY VARCHAR2,
48: x_seq_context_id OUT NOCOPY NUMBER)
49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

Line 52: l_control_date_type fun_seq_contexts.date_type%TYPE;

48: x_seq_context_id OUT NOCOPY NUMBER)
49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:

Line 53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

49: IS
50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:
57: l_seq_context_found BOOLEAN DEFAULT FALSE;

Line 54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

50: PRAGMA AUTONOMOUS_TRANSACTION;
51: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
52: l_control_date_type fun_seq_contexts.date_type%TYPE;
53: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
54: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
55: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
56:
57: l_seq_context_found BOOLEAN DEFAULT FALSE;
58: l_module CONSTANT VARCHAR2(100) DEFAULT

Line 169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

165: x_ledgers_locked_tbl OUT NOCOPY num15_tbl_type,
166: x_ledgers_locked_cnt OUT NOCOPY NUMBER) IS
167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;

Line 170: l_date_type fun_seq_contexts.date_type%TYPE;

166: x_ledgers_locked_cnt OUT NOCOPY NUMBER) IS
167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;

Line 171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

167:
168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;
175: l_seq_head_id_tbl seq_head_id_tbl_type;

Line 172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

168: PRAGMA AUTONOMOUS_TRANSACTION;
169: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
170: l_date_type fun_seq_contexts.date_type%TYPE;
171: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
172: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
173: l_assign_id_tbl assign_id_tbl_type;
174: l_seq_type_tbl seq_type_tbl_type;
175: l_seq_head_id_tbl seq_head_id_tbl_type;
176:

Line 1245: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

1241:
1242: l_sorted_seq_date_tbl date_tbl_type;
1243:
1244: l_dummy fun_seq_headers.gapless_flag%TYPE;
1245: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1246: l_date_dummy_tbl date_tbl_type; -- For Sorting Key
1247:
1248: no_assigned_seq_info EXCEPTION;
1249: j BINARY_INTEGER DEFAULT 1;

Line 1542: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

1538: l_req_assign_flag_tbl req_assign_flag_tbl_type;
1539: l_sorting_key_tbl date_tbl_type;
1540: l_error_code_tbl error_code_tbl_type;
1541:
1542: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
1543: l_dummy fun_seq_headers.gapless_flag%TYPE;
1544:
1545: l_sorted_application_id_tbl num_tbl_type;
1546: l_sorted_ae_header_id_tbl ae_header_id_tbl_type;

Line 1830: FROM fun_seq_contexts WHERE

1826: END IF;
1827:
1828: SELECT name
1829: INTO l_context_name
1830: FROM fun_seq_contexts WHERE
1831: context_type=l_context_type AND
1832: context_value=l_context_value AND
1833: application_id=l_application_id AND
1834: table_name=l_table_name AND