[Home] [Help]
55: IS
56: SELECT destination_type_code,
57: destination_organization_id,
58: deliver_to_location_id
59: FROM po_distributions_interface
60: WHERE interface_header_id = po_autocreate_params.x_interface_header_id
61: AND interface_line_id = p_intf_line_id
62: ORDER BY interface_distribution_id;
63:
765: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Before insert into Distribution interface');
766: END IF;
767:
768: INSERT
769: INTO po_distributions_interface
770: (
771: interface_header_id,
772: interface_line_id,
773: interface_distribution_id,
823: amount_funded --
824: )
825: SELECT pli.interface_header_id,
826: pli.interface_line_id,
827: po_distributions_interface_s.nextval,
828: prd.distribution_num,
829: prd.code_combination_id,
830: prd.set_of_books_id,
831: /* Bug : 13695551 : For clm sourcing, we donot split, so we need to prorate distribution quantities for quantity and amount based lines */
910: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'insert into p_dists record for Option Line');
911: END IF;
912:
913: INSERT
914: INTO po_distributions_interface
915: (
916: interface_header_id,
917: interface_line_id,
918: interface_distribution_id,
924: destination_context
925: )
926: SELECT pli.interface_header_id,
927: pli.interface_line_id,
928: po_distributions_interface_s.nextval,
929: prl.deliver_to_location_id,
930: prl.to_person_id,
931: prl.destination_type_code,
932: prl.destination_organization_id,
951: l_progress:='100';
952:
953: SELECT COUNT(*)
954: INTO l_count_dist
955: FROM po_distributions_interface
956: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
957:
958: IF g_debug_stmt THEN
959: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Count from dist iterface is '||l_count_dist);
964: IF po_autocreate_params.g_is_clm_po ='Y' THEN
965:
966: l_progress :='110';
967:
968: UPDATE po_distributions_interface pdi
969: SET group_line_id =
970: (SELECT interface_line_id
971: FROM po_lines_interface pi
972: WHERE pi.requisition_line_id = pdi.group_line_id
1025: l_ship_to_org_id := NVL(l_ship_to_org_id, PO_AUTOCREATE_PARAMS.g_sys.master_inv_org_id);
1026: END IF;
1027:
1028: -- IF i.ship_to_organization_id IS NOT NULL
1029: -- SQL WHAT: insert minimal data into po_distributions_interface
1030: -- SQL WHY: this is required because the global interface cursor
1031: -- joins to the distributions interface table and uses
1032: -- some of the following fields for defaulting purposes
1033: l_progress:='123';
1031: -- joins to the distributions interface table and uses
1032: -- some of the following fields for defaulting purposes
1033: l_progress:='123';
1034: INSERT
1035: INTO po_distributions_interface
1036: (
1037: interface_header_id ,
1038: interface_line_id ,
1039: interface_distribution_id ,
1044: VALUES
1045: (
1046: i.interface_header_id ,
1047: i.interface_line_id ,
1048: PO_DISTRIBUTIONS_INTERFACE_S.nextval ,
1049: 'EXPENSE' ,
1050: i.ship_to_location_id ,
1051: l_ship_to_org_id
1052: );
4939:
4940: --Line Stucture Enabled does not check for funtion security here.
4941: IF(l_auction_header_id IS NOT NULL AND PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => l_auction_header_id) = 'Y') THEN
4942:
4943: INSERT INTO po_distributions_interface
4944: (interface_header_id,
4945: interface_line_id,
4946: interface_distribution_id,
4947: distribution_num,
4989: amount_funded
4990: )
4991: SELECT phi.interface_header_id,
4992: PLI.interface_line_id,
4993: po_distributions_interface_s.NEXTVAL,
4994: ROWNUM ,
4995: prd.code_combination_id,
4996: prd.set_of_books_id,
4997: phi.rate,