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_RETROACTIVE_PRICING_PVT dependencies on PO_RELEASES

Line 89: * Authorization_status, revision_num in po_headers and po_releases.

85:
86: /**
87: * Private Procedure: MassUpdate_Releases
88: * Modifies: Column price_override, retroactive_date in po_line_locations,
89: * Authorization_status, revision_num in po_headers and po_releases.
90: * Effects: Selects the agreements( blankets and contracts) as specified
91: * by the concurrent parameters and selects the execution docs
92: * refering these agreements for retroactive price updates.
93: * Get the new price based on the release/Std PO shipment values.

Line 99: * po_headers or po_releases with the new revision number and set

95: * new price. In either case, update retoractive_date in
96: * po_line_locations with the retroactive_date in po_lines so that
97: * this shipment will not be picked up again unless blanket line
98: * is retroactively changed. Once all the releases are done, update
99: * po_headers or po_releases with the new revision number and set
100: * authorization_status to "Requires Reapproval" and initiate
101: * Workflow if the document was already in Approved state.
102: * Returns:
103: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds

Line 114: -- Authorization_status, revision_num in po_headers and po_releases.

110: --Pre-reqs:
111: -- None.
112: --Modifies:
113: -- Column price_override, retroactive_date in po_line_locations,
114: -- Authorization_status, revision_num in po_headers and po_releases.
115: --Locks:
116: -- None.
117: --Function:
118: -- This API is called from the Approval Window or by the

Line 131: -- po_headers or po_releases with the new revision number and set

127: -- new price. In either case, update retoractive_date in
128: -- po_line_locations with the retroactive_date in po_lines so that
129: -- this shipment will not be picked up again unless blanket line
130: -- is retroactively changed. Once all the releases are done, update
131: -- po_headers or po_releases with the new revision number and set
132: -- authorization_status to "Requires Reapproval" and initiate
133: -- Workflow if the document was already in Approved state.
134: --Parameters:
135: --IN:

Line 192: po_releases_all por, --

188: por.po_release_id,
189: por.authorization_status, por.revision_num,
190: pora.revision_num
191: from po_line_locations poll,
192: po_releases_all por, --
193: po_releases_archive pora
194: where nvl(por.frozen_flag, 'N') = 'N'
195: and nvl(por.authorization_status, 'INCOMPLETE') IN
196: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 193: po_releases_archive pora

189: por.authorization_status, por.revision_num,
190: pora.revision_num
191: from po_line_locations poll,
192: po_releases_all por, --
193: po_releases_archive pora
194: where nvl(por.frozen_flag, 'N') = 'N'
195: and nvl(por.authorization_status, 'INCOMPLETE') IN
196: ('APPROVED', 'INCOMPLETE', 'REJECTED',
197: 'REQUIRES REAPPROVAL')

Line 317: po_releases_all por, --

313: por.po_release_id,
314: por.authorization_status, por.revision_num,
315: pora.revision_num
316: from po_line_locations poll,
317: po_releases_all por, --
318: po_releases_archive pora
319: where nvl(por.frozen_flag, 'N') = 'N'
320: and nvl(por.authorization_status, 'INCOMPLETE') IN
321: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 318: po_releases_archive pora

314: por.authorization_status, por.revision_num,
315: pora.revision_num
316: from po_line_locations poll,
317: po_releases_all por, --
318: po_releases_archive pora
319: where nvl(por.frozen_flag, 'N') = 'N'
320: and nvl(por.authorization_status, 'INCOMPLETE') IN
321: ('APPROVED', 'INCOMPLETE', 'REJECTED',
322: 'REQUIRES REAPPROVAL')

Line 1935: * Modifies: authorization_Status and revision_num in po_releases.

1931: end BUILD_ITEM_CURSOR;
1932:
1933: /**
1934: * Private Procedure: WrapUp_Releases
1935: * Modifies: authorization_Status and revision_num in po_releases.
1936: * Effects: If any release shipment is updated with the new price, then
1937: * revision_num must be incremented and authorization_Status
1938: * has to be updated to Requires approval if the status is
1939: * Approved. This is called from massupdate_releases procedure.

Line 2022: UPDATE po_releases por

2018: */
2019: -- Bug 5168776 Update the Revised Date also
2020: l_module := g_log_head||l_api_name||'.'||'010'||'.';
2021: FORALL doc_update_index in 1..g_po_release_id_table.COUNT
2022: UPDATE po_releases por
2023: SET por.revision_num = decode(por.revision_num,
2024: l_global_arch_rev_num_table(doc_update_index),
2025: por.revision_num +1,por.revision_num),
2026: por.revised_date = decode(por.revision_num,

Line 2770: * Modifies: Authorization_status of po_releases if the document was

2766:
2767:
2768: /**
2769: * Private Procedure: Launch_REL_Approval
2770: * Modifies: Authorization_status of po_releases if the document was
2771: * already approved.
2772: * Effects: Get the po_release_id from the global temp table po_retroprice_gt
2773: * which has all the document ids that have been updated with
2774: * new price. If the document is in the approved state, then

Line 2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;

2785: x_sub_check_status varchar2(1);
2786: x_msg_data varchar2(2000);
2787: x_online_report_id number;
2788: -- Bug 3318625
2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2790: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2791: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2792: begin
2793:

Line 2809: from po_releases_all

2805: if (g_rel_auth_table(i) in ('APPROVED', 'REQUIRES REAPPROVAL')) then
2806:
2807: select NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2808: into l_consigned_flag
2809: from po_releases_all
2810: where po_release_id = g_po_release_id_table(i);
2811:
2812: IF (g_rel_auth_table(i) = 'APPROVED' OR
2813: (g_rel_auth_table(i) = 'REQUIRES REAPPROVAL' AND

Line 2967: FROM po_releases_all por

2963: WHERE poh.po_header_id = p_doc_id;
2964: elsif (p_doc_type = 'RELEASE') then
2965: SELECT por.org_id
2966: into l_org_id
2967: FROM po_releases_all por
2968: WHERE por.po_release_id = p_doc_id;
2969: end if; /*If ((p_document_type = 'PO') OR (p_document_type = 'PA'))*/
2970:
2971: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 3655: FROM po_releases por,

3651: pod.po_distribution_id,
3652: pod.project_id,
3653: pod.task_id,
3654: pod.accrual_account_id distribute_account_id
3655: FROM po_releases por,
3656: po_headers_all poh, --
3657: po_lines pol,
3658: -- Bug 3393219, Consumption transaction owning org
3659: -- financials_system_parameters fsp,

Line 3772: FROM PO_RELEASES

3768: WHERE po_header_id = p_document_id;
3769: ELSE
3770: SELECT NVL(consigned_consumption_flag, 'N')
3771: INTO l_consigned_flag
3772: FROM PO_RELEASES
3773: WHERE po_release_id = p_document_id;
3774: END IF; /* IF (p_document_type = 'PO') */
3775:
3776: l_progress := '030';

Line 3782: -- For standard POs and PO releases(not consigned),

3778: PO_DEBUG.debug_var(l_log_head,l_progress,'l_consigned_flag', l_consigned_flag);
3779: END IF; /* IF g_debug_stmt */
3780:
3781: IF (l_consigned_flag = 'N') THEN
3782: -- For standard POs and PO releases(not consigned),
3783: -- call the new accounting events API
3784: l_progress := '040';
3785: IF g_debug_stmt THEN
3786: PO_DEBUG.debug_stmt(l_log_head,l_progress,

Line 4586: po_releases_all por

4582: por.org_id,
4583: null -- Bug 3880758
4584: from po_line_locations_all pll,
4585: -- Bug 3541961
4586: po_releases_all por
4587: where pll.line_location_id = p_po_line_loc_id
4588: -- Bug 3541961
4589: and pll.po_release_id = por.po_release_id;
4590:

Line 4822: po_releases_all por

4818: SELECT NVL(por.consigned_consumption_flag, 'N'),
4819: pll.ship_to_organization_id,
4820: NULL
4821: FROM po_line_locations_all pll,
4822: po_releases_all por
4823: WHERE pll.line_location_id = p_po_line_loc_id
4824: AND pll.po_release_id = por.po_release_id;
4825:
4826: BEGIN