839: varchar2,
840: x_transaction_id IN
841: po_requisitions_interface.transaction_id%TYPE,
842: x_org_id IN
843: org_organization_definitions.organization_id%TYPE,
844: x_chart_of_accts_id OUT NOCOPY
845: org_organization_definitions.chart_of_accounts_id%TYPE,
846: x_set_of_books_id OUT NOCOPY
847: org_organization_definitions.set_of_books_id%TYPE)
841: po_requisitions_interface.transaction_id%TYPE,
842: x_org_id IN
843: org_organization_definitions.organization_id%TYPE,
844: x_chart_of_accts_id OUT NOCOPY
845: org_organization_definitions.chart_of_accounts_id%TYPE,
846: x_set_of_books_id OUT NOCOPY
847: org_organization_definitions.set_of_books_id%TYPE)
848: IS
849: BEGIN
843: org_organization_definitions.organization_id%TYPE,
844: x_chart_of_accts_id OUT NOCOPY
845: org_organization_definitions.chart_of_accounts_id%TYPE,
846: x_set_of_books_id OUT NOCOPY
847: org_organization_definitions.set_of_books_id%TYPE)
848: IS
849: BEGIN
850:
851: SELECT chart_of_accounts_id, set_of_books_id
849: BEGIN
850:
851: SELECT chart_of_accounts_id, set_of_books_id
852: INTO x_chart_of_accts_id, x_set_of_books_id
853: FROM org_organization_definitions
854: WHERE organization_id = x_org_id
855: AND nvl(disable_date, sysdate+1) > sysdate ;
856:
857: EXCEPTION
879: varchar2,
880: x_transaction_id IN
881: po_requisitions_interface.transaction_id%TYPE,
882: x_org_id IN
883: org_organization_definitions.organization_id%TYPE,
884: x_subinv IN
885: mtl_secondary_inventories.secondary_inventory_name%TYPE,
886: x_item_id IN
887: mtl_system_items.inventory_item_id%TYPE,
1283: po_requisitions_interface.transaction_id%TYPE)
1284:
1285: IS
1286:
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;
1284:
1285: IS
1286:
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;
1324: l_item_ccid := 0;
1325:
1326:
1327: /* Obtain chart_of_accounts_id and set_of_books from
1328: org_organization_definitions*/
1329: JA_AU_get_coa_sob(x_rowid,
1330: l_transaction_id,
1331: x_org_id,
1332: l_chart_of_accts_id,