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 88: * Authorization_status, revision_num in po_headers and po_releases.

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

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

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

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

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

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

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

Line 191: po_releases_all por, --

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

Line 192: po_releases_archive pora

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

Line 304: po_releases_all por, --

300: por.po_release_id,
301: por.authorization_status, por.revision_num,
302: pora.revision_num
303: from po_line_locations poll,
304: po_releases_all por, --
305: po_releases_archive pora
306: where nvl(por.frozen_flag, 'N') = 'N'
307: and nvl(por.authorization_status, 'INCOMPLETE') IN
308: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 305: po_releases_archive pora

301: por.authorization_status, por.revision_num,
302: pora.revision_num
303: from po_line_locations poll,
304: po_releases_all por, --
305: po_releases_archive pora
306: where nvl(por.frozen_flag, 'N') = 'N'
307: and nvl(por.authorization_status, 'INCOMPLETE') IN
308: ('APPROVED', 'INCOMPLETE', 'REJECTED',
309: 'REQUIRES REAPPROVAL')

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

1902: end BUILD_ITEM_CURSOR;
1903:
1904: /**
1905: * Private Procedure: WrapUp_Releases
1906: * Modifies: authorization_Status and revision_num in po_releases.
1907: * Effects: If any release shipment is updated with the new price, then
1908: * revision_num must be incremented and authorization_Status
1909: * has to be updated to Requires approval if the status is
1910: * Approved. This is called from massupdate_releases procedure.

Line 1993: UPDATE po_releases por

1989: */
1990: -- Bug 5168776 Update the Revised Date also
1991: l_module := g_log_head||l_api_name||'.'||'010'||'.';
1992: FORALL doc_update_index in 1..g_po_release_id_table.COUNT
1993: UPDATE po_releases por
1994: SET por.revision_num = decode(por.revision_num,
1995: l_global_arch_rev_num_table(doc_update_index),
1996: por.revision_num +1,por.revision_num),
1997: por.revised_date = decode(por.revision_num,

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

2676:
2677:
2678: /**
2679: * Private Procedure: Launch_REL_Approval
2680: * Modifies: Authorization_status of po_releases if the document was
2681: * already approved.
2682: * Effects: Get the po_release_id from the global temp table po_retroprice_gt
2683: * which has all the document ids that have been updated with
2684: * new price. If the document is in the approved state, then

Line 2699: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;

2695: x_sub_check_status varchar2(1);
2696: x_msg_data varchar2(2000);
2697: x_online_report_id number;
2698: -- Bug 3318625
2699: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2700: begin
2701:
2702: /* Get po_header_id for the documents that are in the Approved STate.
2703: * Call submission checks and initiate approval.

Line 2717: from po_releases_all

2713: if (g_rel_auth_table(i) in ('APPROVED', 'REQUIRES REAPPROVAL')) then
2714:
2715: select NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2716: into l_consigned_flag
2717: from po_releases_all
2718: where po_release_id = g_po_release_id_table(i);
2719:
2720: IF (g_rel_auth_table(i) = 'APPROVED' OR
2721: (g_rel_auth_table(i) = 'REQUIRES REAPPROVAL' AND

Line 2855: FROM po_releases_all por

2851: WHERE poh.po_header_id = p_doc_id;
2852: elsif (p_doc_type = 'RELEASE') then
2853: SELECT por.org_id
2854: into l_org_id
2855: FROM po_releases_all por
2856: WHERE por.po_release_id = p_doc_id;
2857: end if; /*If ((p_document_type = 'PO') OR (p_document_type = 'PA'))*/
2858:
2859: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 3534: FROM po_releases por,

3530: pod.po_distribution_id,
3531: pod.project_id,
3532: pod.task_id,
3533: pod.accrual_account_id distribute_account_id
3534: FROM po_releases por,
3535: po_headers_all poh, --
3536: po_lines pol,
3537: -- Bug 3393219, Consumption transaction owning org
3538: -- financials_system_parameters fsp,

Line 3651: FROM PO_RELEASES

3647: WHERE po_header_id = p_document_id;
3648: ELSE
3649: SELECT NVL(consigned_consumption_flag, 'N')
3650: INTO l_consigned_flag
3651: FROM PO_RELEASES
3652: WHERE po_release_id = p_document_id;
3653: END IF; /* IF (p_document_type = 'PO') */
3654:
3655: l_progress := '030';

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

3657: PO_DEBUG.debug_var(l_log_head,l_progress,'l_consigned_flag', l_consigned_flag);
3658: END IF; /* IF g_debug_stmt */
3659:
3660: IF (l_consigned_flag = 'N') THEN
3661: -- For standard POs and PO releases(not consigned),
3662: -- call the new accounting events API
3663: l_progress := '040';
3664: IF g_debug_stmt THEN
3665: PO_DEBUG.debug_stmt(l_log_head,l_progress,

Line 4465: po_releases_all por

4461: por.org_id,
4462: null -- Bug 3880758
4463: from po_line_locations_all pll,
4464: -- Bug 3541961
4465: po_releases_all por
4466: where pll.line_location_id = p_po_line_loc_id
4467: -- Bug 3541961
4468: and pll.po_release_id = por.po_release_id;
4469:

Line 4701: po_releases_all por

4697: SELECT NVL(por.consigned_consumption_flag, 'N'),
4698: pll.ship_to_organization_id,
4699: NULL
4700: FROM po_line_locations_all pll,
4701: po_releases_all por
4702: WHERE pll.line_location_id = p_po_line_loc_id
4703: AND pll.po_release_id = por.po_release_id;
4704:
4705: BEGIN