eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 67: DELETE FROM po_req_distributions_all

63: l_progress := '020';
64:
65: -- delete the distributions
66: FORALL idx IN 1..l_line_ids.COUNT
67: DELETE FROM po_req_distributions_all
68: WHERE requisition_line_id = l_line_ids(idx)
69: RETURNING award_id
70: BULK COLLECT INTO l_award_ids;
71:

Line 909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;

905: END jumpIntoFunction;
906:
907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,
908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;

Line 910: l_forGMSProjectId po_req_distributions_all.project_id%type;

906:
907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,
908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;

Line 911: l_forGMSTaskId po_req_distributions_all.task_id%type;

907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,
908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;

Line 912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;

908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
916: l_GMSAPIStatus varchar2(40);

Line 913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;

909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
916: l_GMSAPIStatus varchar2(40);
917: l_progress VARCHAR2(4) := '000';

Line 914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;

910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
916: l_GMSAPIStatus varchar2(40);
917: l_progress VARCHAR2(4) := '000';
918: BEGIN

Line 915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;

911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
913: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
914: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
915: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
916: l_GMSAPIStatus varchar2(40);
917: l_progress VARCHAR2(4) := '000';
918: BEGIN
919: for eachdistribution in 1..p_origDistIds.count

Line 929: from po_req_distributions orig,

925: workingCopy.expenditure_type, workingCopy.expenditure_item_date
926: into l_forGMSReqDistributionId, l_forGMSProjectId, l_forGMSTaskId,
927: l_forGMSAwardId, l_forGMSExpenditureOrgId,
928: l_forGMSExpenditureType, l_forGMSExpenditureDate
929: from po_req_distributions orig,
930: po_req_distributions workingCopy
931: where orig.distribution_id = p_origDistIds(eachDistribution)
932: and workingCopy.distribution_id = p_tempDistIds(eachDistribution)
933: and ( nvl(orig.project_id,-999) <> nvl(workingCopy.project_id,-999)

Line 930: po_req_distributions workingCopy

926: into l_forGMSReqDistributionId, l_forGMSProjectId, l_forGMSTaskId,
927: l_forGMSAwardId, l_forGMSExpenditureOrgId,
928: l_forGMSExpenditureType, l_forGMSExpenditureDate
929: from po_req_distributions orig,
930: po_req_distributions workingCopy
931: where orig.distribution_id = p_origDistIds(eachDistribution)
932: and workingCopy.distribution_id = p_tempDistIds(eachDistribution)
933: and ( nvl(orig.project_id,-999) <> nvl(workingCopy.project_id,-999)
934: OR nvl(orig.task_id,-999) <> nvl(workingCopy.task_id,-999)

Line 1221: UPDATE po_req_distributions_all

1217: l_progress := '060';
1218:
1219: -- flip the line ids in dists
1220: FORALL idx IN 1..p_tempLineIds.COUNT
1221: UPDATE po_req_distributions_all
1222: SET requisition_line_id = p_origLineIds(idx)
1223: WHERE requisition_line_id = p_tempLineIds(idx);
1224:
1225: l_progress := '070';

Line 1229: UPDATE po_req_distributions_all

1225: l_progress := '070';
1226:
1227: -- flip the dist ids
1228: FORALL idx IN 1..p_tempDistIds.COUNT
1229: UPDATE po_req_distributions_all
1230: SET distribution_id = p_origDistIds(idx),
1231: encumbered_flag='N', encumbered_amount=0
1232: WHERE distribution_id = p_tempDistIds(idx);
1233: