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

Line 30: po_req_distributions.distribution_id%type INDEX BY BINARY_INTEGER;

26: TYPE record_status_tbl_type is TABLE OF
27: po_req_split_lines_gt.record_status%type INDEX BY BINARY_INTEGER;
28: TYPE row_id_tbl_type is TABLE OF rowid INDEX BY BINARY_INTEGER;
29: TYPE min_dist_id_tbl_type is TABLE OF
30: po_req_distributions.distribution_id%type INDEX BY BINARY_INTEGER;
31: TYPE org_id_tbl_type is TABLE OF
32: po_headers.org_id%type INDEX BY BINARY_INTEGER;
33: TYPE round_tax_tbl_type is TABLE OF
34: po_req_distributions.recoverable_tax%type INDEX BY BINARY_INTEGER;

Line 34: po_req_distributions.recoverable_tax%type INDEX BY BINARY_INTEGER;

30: po_req_distributions.distribution_id%type INDEX BY BINARY_INTEGER;
31: TYPE org_id_tbl_type is TABLE OF
32: po_headers.org_id%type INDEX BY BINARY_INTEGER;
33: TYPE round_tax_tbl_type is TABLE OF
34: po_req_distributions.recoverable_tax%type INDEX BY BINARY_INTEGER;
35: -- Bug 4723367 START
36: TYPE encumbrance_flag_tbl_type is TABLE OF
37: financials_system_parameters.req_encumbrance_flag%type
38: INDEX BY BINARY_INTEGER;

Line 115: * Also sets prevent encumbrace flag to 'Y' in the po_req_distributions table.

111: * Private Procedure: Split_RequisitionLines
112: * Requires: API message list has been initialized if p_init_msg_list is false.
113: * Modifies: Inserts new req lines and their distributions, For parent
114: * req lines, update requisition_lines table to modified_by_agent_flag='Y'.
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

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 1565: SELECT po_req_distributions_s.nextval,

1561: AWARD_ID ,
1562: OKE_CONTRACT_LINE_ID ,
1563: OKE_CONTRACT_DELIVERABLE_ID
1564: )
1565: SELECT po_req_distributions_s.nextval,
1566: LAST_UPDATE_DATE ,
1567: LAST_UPDATED_BY ,
1568: new_req_line_id_rslt_tbl(l_create_dist_index),
1569: SET_OF_BOOKS_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=

Line 2461: -- PO_REQ_DISTRIBUTIONS

2457: --Name: handle_funds_reversal
2458: --Pre-reqs:
2459: -- None.
2460: --Modifies:
2461: -- PO_REQ_DISTRIBUTIONS
2462: --Locks:
2463: -- None.
2464: --Function:
2465: -- Make a call to encumbrance api to reverse the funds reservation

Line 2613: FROM po_req_distributions prd,

2609:
2610: SELECT prd.distribution_id
2611: BULK COLLECT INTO
2612: l_before_dist_ids_tbl
2613: FROM po_req_distributions prd,
2614: po_req_split_lines_gt prs
2615: WHERE prd.requisition_line_id = prs.requisition_line_id
2616: AND (prs.bid_number = prs.min_bid_number
2617: OR

Line 2657: FROM po_req_distributions prd,

2653:
2654: SELECT prd.distribution_id
2655: BULK COLLECT INTO
2656: l_after_dist_ids_tbl
2657: FROM po_req_distributions prd,
2658: po_req_split_lines_gt prs
2659: WHERE prd.requisition_line_id = prs.new_req_line_id
2660: AND prs.record_status in ('S','N')
2661: AND nvl(prd.prevent_encumbrance_flag,'N') <> 'Y'

Line 2831: -- PO_REQ_DISTRIBUTIONS

2827: --Name: handle_tax_adjustments
2828: --Pre-reqs:
2829: -- None.
2830: --Modifies:
2831: -- PO_REQ_DISTRIBUTIONS
2832: --Locks:
2833: -- None.
2834: --Function:
2835: -- Handle tax adjustments.

Line 2926: FROM po_req_distributions prd, po_req_split_lines_gt prs

2922: BULK COLLECT INTO
2923: sum_new_line_r_tax_tbl,
2924: sum_new_line_nr_tax_tbl,
2925: min_dist_id_tax_tbl
2926: FROM po_req_distributions prd, po_req_split_lines_gt prs
2927: WHERE prd.requisition_line_id = prs.new_req_line_id
2928: AND prs.record_status in ('S','N')
2929: GROUP BY prs.requisition_line_id,
2930: prd.code_combination_id;

Line 2955: FROM po_req_distributions prd, po_req_split_lines_gt prs

2951: BULK COLLECT INTO
2952: req_line_id_tax_tbl,
2953: sum_orig_line_r_tax_tbl,
2954: sum_orig_line_nr_tax_tbl
2955: FROM po_req_distributions prd, po_req_split_lines_gt prs
2956: WHERE prd.requisition_line_id = prs.requisition_line_id
2957: AND (prs.bid_number = prs.min_bid_number OR
2958: -- when called from autocreate req modify bid number would be null
2959: prs.bid_number IS NULL)

Line 3020: UPDATE PO_REQ_DISTRIBUTIONS

3016: -- NONRECOVERABLE TAX of all
3017: -- the distribution lines.
3018: --sql why : To take care of TAX rounding issue.
3019: FORALL l_tax_rounding_index in 1.. req_line_id_tax_tbl.COUNT
3020: UPDATE PO_REQ_DISTRIBUTIONS
3021: SET recoverable_tax = recoverable_tax+
3022: (sum_orig_line_r_tax_tbl(l_tax_rounding_index) -
3023: sum_new_line_r_tax_tbl(l_tax_rounding_index)),
3024: nonrecoverable_tax = nonrecoverable_tax+