[Home] [Help]
10: /********************************************************************
11: PROCEDURE NAME: default_po_dist_interface()
12:
13: DESCRIPTION: This API defaults the distribution in
14: po_distributions_interface table. This uses account
15: generator to build the accounts.
16: Referenced by: This is called from po_interface_s.setup_interface_tables.
17: from the file POXBWP1B.pls
18:
449: END IF;
450: -- get the account ids
451: -- we dont need to call account gen. for a blanket as we dont
452: -- need a distribution record. We still insert a distribution
453: -- record into po_distributions_interface for a blanket to
454: -- help programming.
455: -- Bug 5050208: Removed the item id condition as account generator
456: -- also generates accounts for 1 time items
457: if x_type_lookup_code <>'BLANKET' and
566:
567:
568: x_progress := '100';
569: /*******************************************************************
570: Insert into po_distributions_interface table.
571: *******************************************************************/
572:
573: INSERT INTO po_distributions_interface
574: (interface_header_id,
569: /*******************************************************************
570: Insert into po_distributions_interface table.
571: *******************************************************************/
572:
573: INSERT INTO po_distributions_interface
574: (interface_header_id,
575: interface_line_id,
576: interface_distribution_id,
577: distribution_num,
610: expenditure_item_date
611: )
612: values(x_interface_header_id,
613: x_interface_line_id,
614: po_distributions_interface_s.nextval,
615: 1, --prd.distribution_num,
616: x_charge_account_id, --prd.code_combination_id,
617: x_def_sob_id, --prd.set_of_books_id,
618: x_quantity,