DBA Data[Home] [Help]

APPS.JA_AU_CCID_PKG dependencies on JA_AU_ACCT_DEFAULT_SEGS

Line 37: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;

33: l_chart_of_accts_id org_organization_definitions.organization_id%TYPE;
34: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
35: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
36: l_item_ccid mtl_system_items.expense_account%TYPE;
37: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
38: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
40: l_segvalues fnd_flex_ext.segmentarray;
41: l_seglength natural := 0;

Line 38: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;

34: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
35: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
36: l_item_ccid mtl_system_items.expense_account%TYPE;
37: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
38: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
40: l_segvalues fnd_flex_ext.segmentarray;
41: l_seglength natural := 0;
42: l_segnumber natural := 0;

Line 39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;

35: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
36: l_item_ccid mtl_system_items.expense_account%TYPE;
37: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
38: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
39: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
40: l_segvalues fnd_flex_ext.segmentarray;
41: l_seglength natural := 0;
42: l_segnumber natural := 0;
43: l_ccid gl_code_combinations.code_combination_id%TYPE;

Line 52: FROM JA_AU_ACCT_DEFAULT_SEGS s, ja_au_account_defaults d

48: CURSOR l_autoaccount_defns IS
49: SELECT nvl(upper(s.table_name), '!~') TABLE_NAME,
50: nvl(s.constant, '!~') CONSTANT,
51: s.segment
52: FROM JA_AU_ACCT_DEFAULT_SEGS s, ja_au_account_defaults d
53: WHERE s.gl_default_id = d.gl_default_id
54: AND d.set_of_books_id = l_set_of_books_id
55: ORDER BY d.type,s.segment_num ;
56:

Line 245: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,

241:
242: FUNCTION JA_AU_GET_SEGMENT_VALUE
243: (
244: x_table_name IN
245: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
246: x_constant IN
247: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
248: x_segment IN
249: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,

Line 247: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,

243: (
244: x_table_name IN
245: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
246: x_constant IN
247: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
248: x_segment IN
249: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
250: x_subinv_ccid IN
251: mtl_secondary_inventories.expense_account%TYPE,

Line 249: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,

245: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
246: x_constant IN
247: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
248: x_segment IN
249: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
250: x_subinv_ccid IN
251: mtl_secondary_inventories.expense_account%TYPE,
252: x_item_ccid IN
253: mtl_system_items.expense_account%TYPE)