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 1582: INSERT INTO po_req_distributions_all --

1578: l_org_context_changed := 'Y';
1579: l_old_line_requesting_ou_id := l_line_requesting_ou_id;
1580: END IF;
1581:
1582: INSERT INTO po_req_distributions_all --
1583: (DISTRIBUTION_ID ,
1584: LAST_UPDATE_DATE ,
1585: LAST_UPDATED_BY ,
1586: REQUISITION_LINE_ID ,

Line 1646: SELECT po_req_distributions_s.nextval,

1642: AWARD_ID ,
1643: OKE_CONTRACT_LINE_ID ,
1644: OKE_CONTRACT_DELIVERABLE_ID
1645: )
1646: SELECT po_req_distributions_s.nextval,
1647: LAST_UPDATE_DATE ,
1648: LAST_UPDATED_BY ,
1649: new_req_line_id_rslt_tbl(l_create_dist_index),
1650: SET_OF_BOOKS_ID ,

Line 1718: FROM po_req_distributions_all --

1714: TAX_RECOVERY_OVERRIDE_FLAG ,
1715: AWARD_ID ,
1716: OKE_CONTRACT_LINE_ID ,
1717: OKE_CONTRACT_DELIVERABLE_ID
1718: FROM po_req_distributions_all --
1719: WHERE requisition_line_id=
1720: requisition_line_id_rslt_tbl(l_create_dist_index);
1721:
1722: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1874: FROM po_req_distributions_all prd, --

1870: req_line_id_round_tbl,
1871: min_dist_id_round_tbl,
1872: sum_req_line_qty_round_tbl,
1873: req_line_qty_round_tbl
1874: FROM po_req_distributions_all prd, --
1875: po_req_split_lines_gt prs
1876: WHERE prd.requisition_line_id = prs.new_req_line_id
1877: AND prs.record_status in ('S','N')
1878: GROUP BY prd.requisition_line_id;

Line 1916: UPDATE po_req_distributions_all --

1912: -- with the excess/less of the sum of quantities of all
1913: -- the distribution lines.
1914: --sql why : To take care of rounding issue.
1915: FORALL l_qty_rounding_index in 1.. req_line_id_round_tbl.COUNT
1916: UPDATE po_req_distributions_all --
1917: SET req_line_quantity = req_line_quantity+
1918: (req_line_qty_round_tbl(l_qty_rounding_index)-
1919: sum_req_line_qty_round_tbl(l_qty_rounding_index))
1920: WHERE distribution_id=

Line 2550: -- PO_REQ_DISTRIBUTIONS

2546: --Name: handle_funds_reversal
2547: --Pre-reqs:
2548: -- None.
2549: --Modifies:
2550: -- PO_REQ_DISTRIBUTIONS
2551: --Locks:
2552: -- None.
2553: --Function:
2554: -- Make a call to encumbrance api to reverse the funds reservation

Line 2703: FROM po_req_distributions prd,

2699:
2700: SELECT prd.distribution_id
2701: BULK COLLECT INTO
2702: l_before_dist_ids_tbl
2703: FROM po_req_distributions prd,
2704: po_req_split_lines_gt prs
2705: WHERE prd.requisition_line_id = prs.requisition_line_id
2706: AND (prs.bid_number = prs.min_bid_number
2707: OR

Line 2747: FROM po_req_distributions prd,

2743:
2744: SELECT prd.distribution_id
2745: BULK COLLECT INTO
2746: l_after_dist_ids_tbl
2747: FROM po_req_distributions prd,
2748: po_req_split_lines_gt prs
2749: WHERE prd.requisition_line_id = prs.new_req_line_id
2750: AND prs.record_status in ('S','N')
2751: AND nvl(prd.prevent_encumbrance_flag,'N') <> 'Y'

Line 2921: -- PO_REQ_DISTRIBUTIONS

2917: --Name: handle_tax_adjustments
2918: --Pre-reqs:
2919: -- None.
2920: --Modifies:
2921: -- PO_REQ_DISTRIBUTIONS
2922: --Locks:
2923: -- None.
2924: --Function:
2925: -- Handle tax adjustments.

Line 3016: FROM po_req_distributions prd, po_req_split_lines_gt prs

3012: BULK COLLECT INTO
3013: sum_new_line_r_tax_tbl,
3014: sum_new_line_nr_tax_tbl,
3015: min_dist_id_tax_tbl
3016: FROM po_req_distributions prd, po_req_split_lines_gt prs
3017: WHERE prd.requisition_line_id = prs.new_req_line_id
3018: AND prs.record_status in ('S','N')
3019: GROUP BY prs.requisition_line_id,
3020: prd.code_combination_id;

Line 3045: FROM po_req_distributions prd, po_req_split_lines_gt prs

3041: BULK COLLECT INTO
3042: req_line_id_tax_tbl,
3043: sum_orig_line_r_tax_tbl,
3044: sum_orig_line_nr_tax_tbl
3045: FROM po_req_distributions prd, po_req_split_lines_gt prs
3046: WHERE prd.requisition_line_id = prs.requisition_line_id
3047: AND (prs.bid_number = prs.min_bid_number OR
3048: -- when called from autocreate req modify bid number would be null
3049: prs.bid_number IS NULL)

Line 3110: UPDATE PO_REQ_DISTRIBUTIONS

3106: -- NONRECOVERABLE TAX of all
3107: -- the distribution lines.
3108: --sql why : To take care of TAX rounding issue.
3109: FORALL l_tax_rounding_index in 1.. req_line_id_tax_tbl.COUNT
3110: UPDATE PO_REQ_DISTRIBUTIONS
3111: SET recoverable_tax = recoverable_tax+
3112: (sum_orig_line_r_tax_tbl(l_tax_rounding_index) -
3113: sum_new_line_r_tax_tbl(l_tax_rounding_index)),
3114: nonrecoverable_tax = nonrecoverable_tax+