DBA Data[Home] [Help]

APPS.PO_REQIMP_PKG dependencies on JA_AU_ACCT_DEFAULT_SEGS

Line 1151: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,

1147: varchar2,
1148: x_transaction_id IN
1149: po_requisitions_interface.transaction_id%TYPE,
1150: x_table_name IN
1151: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
1152: x_constant IN
1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
1154: x_segment IN
1155: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,

Line 1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,

1149: po_requisitions_interface.transaction_id%TYPE,
1150: x_table_name IN
1151: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
1152: x_constant IN
1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
1154: x_segment IN
1155: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
1156: x_subinv_ccid IN
1157: mtl_secondary_inventories.expense_account%TYPE,

Line 1155: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,

1151: JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE,
1152: x_constant IN
1153: JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE,
1154: x_segment IN
1155: JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE,
1156: x_subinv_ccid IN
1157: mtl_secondary_inventories.expense_account%TYPE,
1158: x_item_ccid IN
1159: mtl_system_items.expense_account%TYPE)

Line 1291: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;

1287: l_chart_of_accts_id org_organization_definitions.organization_id%TYPE;
1288: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
1289: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
1290: l_item_ccid mtl_system_items.expense_account%TYPE;
1291: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
1292: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
1294: l_segvalues fnd_flex_ext.segmentarray;
1295: l_seglength natural := 0;

Line 1292: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;

1288: l_set_of_books_id org_organization_definitions.set_of_books_id%TYPE;
1289: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
1290: l_item_ccid mtl_system_items.expense_account%TYPE;
1291: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
1292: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
1294: l_segvalues fnd_flex_ext.segmentarray;
1295: l_seglength natural := 0;
1296: l_segnumber natural := 0;

Line 1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;

1289: l_subinv_ccid mtl_secondary_inventories.expense_account%TYPE;
1290: l_item_ccid mtl_system_items.expense_account%TYPE;
1291: l_table_name JA_AU_ACCT_DEFAULT_SEGS.table_name%TYPE;
1292: l_constant JA_AU_ACCT_DEFAULT_SEGS.constant%TYPE;
1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
1294: l_segvalues fnd_flex_ext.segmentarray;
1295: l_seglength natural := 0;
1296: l_segnumber natural := 0;
1297: l_ccid gl_code_combinations.code_combination_id%TYPE;

Line 1306: FROM JA_AU_ACCT_DEFAULT_SEGS s, ja_au_account_defaults d

1302: CURSOR l_autoaccount_defns IS
1303: SELECT nvl(upper(s.table_name), '!~') TABLE_NAME,
1304: nvl(s.constant, '!~') CONSTANT,
1305: s.segment
1306: FROM JA_AU_ACCT_DEFAULT_SEGS s, ja_au_account_defaults d
1307: WHERE s.gl_default_id = d.gl_default_id
1308: AND d.set_of_books_id = l_set_of_books_id
1309: ORDER BY d.type,s.segment_num ;
1310: