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_ALL

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 942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;

938:
939: END jumpIntoFunction;
940:
941: PROCEDURE update_gms_distributions(p_origHeaderId IN NUMBER) IS
942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;

Line 943: l_forGMSProjectId po_req_distributions_all.project_id%type;

939: END jumpIntoFunction;
940:
941: PROCEDURE update_gms_distributions(p_origHeaderId IN NUMBER) IS
942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;

Line 944: l_forGMSTaskId po_req_distributions_all.task_id%type;

940:
941: PROCEDURE update_gms_distributions(p_origHeaderId IN NUMBER) IS
942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;

Line 945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;

941: PROCEDURE update_gms_distributions(p_origHeaderId IN NUMBER) IS
942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
949: l_GMSAPIStatus varchar2(40);

Line 946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;

942: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
949: l_GMSAPIStatus varchar2(40);
950: l_progress VARCHAR2(4) := '000';

Line 947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;

943: l_forGMSProjectId po_req_distributions_all.project_id%type;
944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
949: l_GMSAPIStatus varchar2(40);
950: l_progress VARCHAR2(4) := '000';
951:

Line 948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;

944: l_forGMSTaskId po_req_distributions_all.task_id%type;
945: l_forGMSAwardId po_req_distributions_all.req_award_id%type;
946: l_forGMSExpenditureOrgId po_req_distributions_all.expenditure_organization_id%type;
947: l_forGMSExpenditureType po_req_distributions_all.expenditure_type%type;
948: l_forGMSExpenditureDate po_req_distributions_all.expenditure_item_date%type;
949: l_GMSAPIStatus varchar2(40);
950: l_progress VARCHAR2(4) := '000';
951:
952: cursor allDists(p_origHeaderId NUMBER) is

Line 960: from po_req_distributions_all prd,

956: req_award_id,
957: expenditure_organization_id,
958: expenditure_type,
959: expenditure_item_date
960: from po_req_distributions_all prd,
961: po_requisition_lines_all prl
962: where prl.requisition_header_id = p_origHeaderId
963: and prl.requisition_line_id = prd.requisition_line_id;
964:

Line 1262: UPDATE po_req_distributions_all

1258: l_progress := '060';
1259:
1260: -- flip the line ids in dists
1261: FORALL idx IN 1..p_tempLineIds.COUNT
1262: UPDATE po_req_distributions_all
1263: SET requisition_line_id = p_origLineIds(idx)
1264: WHERE requisition_line_id = p_tempLineIds(idx);
1265:
1266: l_progress := '070';

Line 1270: UPDATE po_req_distributions_all

1266: l_progress := '070';
1267:
1268: -- flip the dist ids
1269: FORALL idx IN 1..p_tempDistIds.COUNT
1270: UPDATE po_req_distributions_all
1271: SET distribution_id = p_origDistIds(idx),
1272: encumbered_flag='N', encumbered_amount=0
1273: WHERE distribution_id = p_tempDistIds(idx);
1274:

Line 3636: po_req_distributions_all prd

3632: BEGIN
3633: select count(*) into l_enc_dist_count
3634: from po_requisition_headers_all prh,
3635: po_requisition_lines_all prl,
3636: po_req_distributions_all prd
3637: where prh.requisition_header_id = p_req_header_id
3638: and prh.requisition_header_id = prl.requisition_header_id
3639: and prl.requisition_line_id = prd.requisition_line_id
3640: and nvl(prd.encumbered_flag,'N') = 'Y';

Line 4158: FROM po_req_distributions_all

4154: END IF ;
4155:
4156: SELECT Round(Nvl(funded_value,0),15)
4157: INTO p_funded_value
4158: FROM po_req_distributions_all
4159: WHERE distribution_id = p_distribution_id ;
4160:
4161: EXCEPTION
4162: WHEN OTHERS THEN

Line 4327: from po_req_distributions_all

4323:
4324: x_award_set_id NUMBER ;
4325: Cursor c_award_set_id is
4326: select award_id
4327: from po_req_distributions_all
4328: where distribution_id = X_distribution_id ;
4329:
4330: BEGIN
4331: -- ==============================================================

Line 4344: UPDATE PO_REQ_DISTRIBUTIONS_ALL SET award_id = NULL

4340: fetch c_award_set_id into x_award_set_id ;
4341: close c_award_set_id ;
4342:
4343: IF NVL(x_award_set_id, 0) > 0 THEN
4344: UPDATE PO_REQ_DISTRIBUTIONS_ALL SET award_id = NULL
4345: where distribution_id = X_distribution_id ;
4346:
4347: X_status:='S';
4348: END IF ;

Line 4576: FROM po_req_distributions_all

4572: x_pjt_id_dummy NUMBER;
4573: l_api_name CONSTANT VARCHAR2(100) := 'val_req_line_pjts';
4574: CURSOR C_Proj IS
4575: SELECT DISTINCT project_id
4576: FROM po_req_distributions_all
4577: WHERE REQUISITION_LINE_ID = x_line_id;
4578:
4579:
4580: BEGIN

Line 4651: FROM po_req_distributions_all

4647: l_api_name CONSTANT VARCHAR2(100) := 'get_req_line_invalid_pjts';
4648:
4649: CURSOR C_Proj IS
4650: SELECT DISTINCT project_id
4651: FROM po_req_distributions_all
4652: WHERE REQUISITION_LINE_ID = p_req_line_id;
4653:
4654: BEGIN
4655:

Line 5705: FROM PO_REQ_DISTRIBUTIONS_ALL PRD,

5701: SELECT PRD.DISTRIBUTION_ID,
5702: GLCC.CONCATENATED_SEGMENTS CHARGE_ACC,
5703: PRD.CLM_MISC_LOA ,
5704: PRD.ACRN
5705: FROM PO_REQ_DISTRIBUTIONS_ALL PRD,
5706: GL_CODE_COMBINATIONS_KFV GLCC
5707: WHERE PRD.DISTRIBUTION_ID IN
5708: (
5709: SELECT DISTRIBUTION_ID

Line 5710: FROM PO_REQ_DISTRIBUTIONS_ALL

5706: GL_CODE_COMBINATIONS_KFV GLCC
5707: WHERE PRD.DISTRIBUTION_ID IN
5708: (
5709: SELECT DISTRIBUTION_ID
5710: FROM PO_REQ_DISTRIBUTIONS_ALL
5711: WHERE REQUISITION_LINE_ID IN
5712: (
5713: SELECT REQUISITION_LINE_ID
5714: FROM PO_REQUISITION_LINES_ALL