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.PO_NEGOTIATIONS4_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 119: * po_requisition_lines_all and po_req_distributions_all table. This api also

115: * Also sets prevent encumbrace flag to 'Y' in the po_req_distributions table.
116: * Effects: This api split the requisition lines, if needed, depending on the
117: * allocation done by the sourcing user. This api uses a global temp. table
118: * to massage the input given by sourcing and inserts records into
119: * po_requisition_lines_all and po_req_distributions_all table. This api also
120: * handles the encumbrace effect of splitting requisition lines. This api would
121: * be called from ORacle sourcing workflow.
122: *
123: * Returns:

Line 223: l_project_id po_req_distributions_all.project_id%TYPE;

219: l_current_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
220: l_org_context_changed VARCHAR2(1) := 'N';
221:
222: -- bug 5249299
223: l_project_id po_req_distributions_all.project_id%TYPE;
224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;

Line 224: l_task_id po_req_distributions_all.task_id%TYPE;

220: l_org_context_changed VARCHAR2(1) := 'N';
221:
222: -- bug 5249299
223: l_project_id po_req_distributions_all.project_id%TYPE;
224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;

Line 225: l_award_id po_req_distributions_all.award_id%TYPE;

221:
222: -- bug 5249299
223: l_project_id po_req_distributions_all.project_id%TYPE;
224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;
229: l_award_set_id po_req_distributions_all.award_id%TYPE;

Line 226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;

222: -- bug 5249299
223: l_project_id po_req_distributions_all.project_id%TYPE;
224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;
229: l_award_set_id po_req_distributions_all.award_id%TYPE;
230: l_status VARCHAR2(1);

Line 227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;

223: l_project_id po_req_distributions_all.project_id%TYPE;
224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;
229: l_award_set_id po_req_distributions_all.award_id%TYPE;
230: l_status VARCHAR2(1);
231:

Line 228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;

224: l_task_id po_req_distributions_all.task_id%TYPE;
225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;
229: l_award_set_id po_req_distributions_all.award_id%TYPE;
230: l_status VARCHAR2(1);
231:
232: CURSOR l_req_dist_proj_csr(l_req_line_id number) IS

Line 229: l_award_set_id po_req_distributions_all.award_id%TYPE;

225: l_award_id po_req_distributions_all.award_id%TYPE;
226: l_expenditure_type po_req_distributions_all.expenditure_type%TYPE;
227: l_expenditure_item_date po_req_distributions_all.expenditure_item_date%TYPE;
228: l_distribution_id po_req_distributions_all.distribution_id%TYPE;
229: l_award_set_id po_req_distributions_all.award_id%TYPE;
230: l_status VARCHAR2(1);
231:
232: CURSOR l_req_dist_proj_csr(l_req_line_id number) IS
233: SELECT distribution_id,

Line 239: FROM po_req_distributions_all

235: task_id,
236: award_id,
237: expenditure_type,
238: expenditure_item_date
239: FROM po_req_distributions_all
240: WHERE requisition_line_id = l_req_line_id;
241:
242: l_req_dist_proj_rec l_req_dist_proj_csr%ROWTYPE;
243: -- bug 5249299

Line 1501: INSERT INTO po_req_distributions_all --

1497: l_org_context_changed := 'Y';
1498: l_old_line_requesting_ou_id := l_line_requesting_ou_id;
1499: END IF;
1500:
1501: INSERT INTO po_req_distributions_all --
1502: (DISTRIBUTION_ID ,
1503: LAST_UPDATE_DATE ,
1504: LAST_UPDATED_BY ,
1505: REQUISITION_LINE_ID ,

Line 1637: FROM po_req_distributions_all --

1633: TAX_RECOVERY_OVERRIDE_FLAG ,
1634: AWARD_ID ,
1635: OKE_CONTRACT_LINE_ID ,
1636: OKE_CONTRACT_DELIVERABLE_ID
1637: FROM po_req_distributions_all --
1638: WHERE requisition_line_id=
1639: requisition_line_id_rslt_tbl(l_create_dist_index);
1640:
1641: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1793: FROM po_req_distributions_all prd, --

1789: req_line_id_round_tbl,
1790: min_dist_id_round_tbl,
1791: sum_req_line_qty_round_tbl,
1792: req_line_qty_round_tbl
1793: FROM po_req_distributions_all prd, --
1794: po_req_split_lines_gt prs
1795: WHERE prd.requisition_line_id = prs.new_req_line_id
1796: AND prs.record_status in ('S','N')
1797: GROUP BY prd.requisition_line_id;

Line 1835: UPDATE po_req_distributions_all --

1831: -- with the excess/less of the sum of quantities of all
1832: -- the distribution lines.
1833: --sql why : To take care of rounding issue.
1834: FORALL l_qty_rounding_index in 1.. req_line_id_round_tbl.COUNT
1835: UPDATE po_req_distributions_all --
1836: SET req_line_quantity = req_line_quantity+
1837: (req_line_qty_round_tbl(l_qty_rounding_index)-
1838: sum_req_line_qty_round_tbl(l_qty_rounding_index))
1839: WHERE distribution_id=