[Home] [Help]
77: accrual_account_id ,
78: variance_account_id,
79: encumbered_flag,
80: budget_account_id
81: FROM po_distributions_interface pdi
82: WHERE pdi.interface_header_id = po_autocreate_params.g_interface_header_id
83: AND pdi.interface_line_id = p_intf_line_id
84: ORDER BY pdi.interface_distribution_id;
85:
387: l_uom_conversion_rate := x_conversion_rate;
388: l_currency_conversion_rate := NVL(PO_AUTOCREATE_PARAMS.g_rate_for_req_fields,1); --
389:
390: l_progress := '190';
391: --update po_distributions interface
392: UPDATE po_distributions_interface
393: SET po_distribution_id = po_distributions_s.NEXTVAL,
394: distribution_num = x_distribution_num + rownum
395: WHERE interface_header_id = p_lines.intf_header_id_tbl(i)
388: l_currency_conversion_rate := NVL(PO_AUTOCREATE_PARAMS.g_rate_for_req_fields,1); --
389:
390: l_progress := '190';
391: --update po_distributions interface
392: UPDATE po_distributions_interface
393: SET po_distribution_id = po_distributions_s.NEXTVAL,
394: distribution_num = x_distribution_num + rownum
395: WHERE interface_header_id = p_lines.intf_header_id_tbl(i)
396: AND interface_line_id = p_lines.intf_line_id_tbl(i);
414: l_progress := '220';
415: BEGIN
416: SELECT pdi.amount_ordered
417: INTO l_amount_ordered
418: FROM po_distributions_interface pdi,
419: po_line_locations_draft_all poll
420: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
421: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
422: AND poll.line_location_id = p_lines.line_loc_id_tbl(i)
456:
457: l_progress := '250';
458: SELECT COUNT(*)
459: INTO l_dist_count
460: FROM po_distributions_interface pdi,
461: po_line_locations_draft_all poll
462: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
463: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
464: AND poll.draft_id =po_autocreate_params.g_draft_id
702: pdi.clm_defence_funding,
703: pdi.clm_fms_case_number,
704: pdi.clm_agency_acct_identifier,
705: 'NEW'
706: FROM po_distributions_interface pdi,
707: po_line_locations_draft_all poll
708: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
709: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
710: AND poll.draft_id =po_autocreate_params.g_draft_id
1731: Name: update_award_distributions
1732: Pre-reqs:
1733: None
1734: Modifies:
1735: PO_DISTRIBUTIONS_INTERFACE
1736: GMS_AWARD_DISTRIBUTIONS
1737: Locks:
1738: None
1739: Function:
1814: ELSE
1815: l_progress:='020';
1816: --SQL WHAT: For distributions with award_id references, select
1817: -- the columns that Grants needs from the
1818: -- po_distributions_interface table
1819: --SQL WHY : Need to call GMS API to update award distribution
1820: -- lines table.
1821: SELECT po_distribution_id,
1822: distribution_num,
1829: l_gms_po_interface_obj.project_id,
1830: l_gms_po_interface_obj.task_id,
1831: l_gms_po_interface_obj.award_set_id_in,
1832: l_gms_po_interface_obj.award_set_id_out
1833: FROM PO_DISTRIBUTIONS_INTERFACE
1834: WHERE interface_header_id = l_intf_header_id
1835: AND interface_line_id = l_intf_line_id
1836: AND award_id IS NOT NULL;
1837: END IF; -- if p_table_type = 'ALL'
1866: WHERE po_distribution_id = l_gms_po_interface_obj.distribution_id(i)
1867: AND draft_id =po_autocreate_params.g_draft_id;
1868: ELSE
1869: l_progress := '050';
1870: --SQL WHAT: Update po_distributions_interface table with the new
1871: -- award_id's
1872: --SQL WHY : award_id's in PO tables need to be synchronized with
1873: -- award_id's in GMS tables.
1874: FORALL i IN 1..l_gms_po_interface_obj.distribution_id.COUNT
1871: -- award_id's
1872: --SQL WHY : award_id's in PO tables need to be synchronized with
1873: -- award_id's in GMS tables.
1874: FORALL i IN 1..l_gms_po_interface_obj.distribution_id.COUNT
1875: UPDATE po_distributions_interface
1876: SET award_id = l_gms_po_interface_obj.award_set_id_out(i)
1877: WHERE po_distribution_id = l_gms_po_interface_obj.distribution_id(i);
1878: END IF; -- if p_table_type = 'ALL'
1879: --