29: po_requisitions_interface.transaction_id%TYPE)
30:
31: IS
32:
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;
30:
31: IS
32:
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;
69: l_item_ccid := 0;
70:
71:
72: /* Obtain chart_of_accounts_id and set_of_books from
73: org_organization_definitions*/
74: JA_AU_get_coa_sob( x_org_id,
75: l_chart_of_accts_id,
76: l_set_of_books_id);
77:
153: -- *
154:
155: PROCEDURE JA_AU_GET_COA_SOB
156: (x_org_id IN
157: org_organization_definitions.organization_id%TYPE,
158: x_chart_of_accts_id OUT
159: org_organization_definitions.chart_of_accounts_id%TYPE,
160: x_set_of_books_id OUT
161: org_organization_definitions.set_of_books_id%TYPE)
155: PROCEDURE JA_AU_GET_COA_SOB
156: (x_org_id IN
157: org_organization_definitions.organization_id%TYPE,
158: x_chart_of_accts_id OUT
159: org_organization_definitions.chart_of_accounts_id%TYPE,
160: x_set_of_books_id OUT
161: org_organization_definitions.set_of_books_id%TYPE)
162: IS
163: BEGIN
157: org_organization_definitions.organization_id%TYPE,
158: x_chart_of_accts_id OUT
159: org_organization_definitions.chart_of_accounts_id%TYPE,
160: x_set_of_books_id OUT
161: org_organization_definitions.set_of_books_id%TYPE)
162: IS
163: BEGIN
164:
165: SELECT chart_of_accounts_id, set_of_books_id
163: BEGIN
164:
165: SELECT chart_of_accounts_id, set_of_books_id
166: INTO x_chart_of_accts_id, x_set_of_books_id
167: FROM org_organization_definitions
168: WHERE organization_id = x_org_id
169: AND nvl(disable_date, sysdate+1) > sysdate ;
170:
171: EXCEPTION
183: -- *
184:
185: PROCEDURE JA_AU_GET_REPLN_EXP_ACCTS
186: (x_org_id IN
187: org_organization_definitions.organization_id%TYPE,
188: x_subinv IN
189: mtl_secondary_inventories.secondary_inventory_name%TYPE,
190: x_item_id IN
191: mtl_system_items.inventory_item_id%TYPE,