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_MULTI_MOD_PVT dependencies on PO_MULTI_MOD_REQUESTS

Line 148: -- po_multi_mod_changes and po_multi_mod_requests

144: -- None.
145: --Function:
146: -- Removes the multi_mod_request
147: -- Deletes entries from po_multi_mod_val_results, po_multi_mod_docs,
148: -- po_multi_mod_changes and po_multi_mod_requests
149: --Parameters:
150: --IN:
151: --p_multi_mod_request_id
152: -- The request id of the Multi-Mod Request

Line 181: --remove from po_multi_mod_requests table

177: -- remove changes made in multi mod request
178: DELETE FROM po_multi_mod_changes
179: WHERE multi_mod_request_id = p_multi_mod_request_id;
180:
181: --remove from po_multi_mod_requests table
182: DELETE FROM po_multi_mod_requests
183: WHERE multi_mod_request_id = p_multi_mod_request_id;
184:
185: --remove Contracts data

Line 182: DELETE FROM po_multi_mod_requests

178: DELETE FROM po_multi_mod_changes
179: WHERE multi_mod_request_id = p_multi_mod_request_id;
180:
181: --remove from po_multi_mod_requests table
182: DELETE FROM po_multi_mod_requests
183: WHERE multi_mod_request_id = p_multi_mod_request_id;
184:
185: --remove Contracts data
186: DELETE FROM po_multi_mod_clause_changes

Line 409: PROCEDURE default_and_merge_mod_data(p_multi_mod_request_record IN po_multi_mod_requests%ROWTYPE,

405: -- FND_API.G_RET_STS_ERROR if API fails
406: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
407: --End of Comments
408: -------------------------------------------------------------------------------
409: PROCEDURE default_and_merge_mod_data(p_multi_mod_request_record IN po_multi_mod_requests%ROWTYPE,
410: p_po_header_id IN NUMBER,
411: p_draft_id IN NUMBER,
412: p_style_id IN NUMBER,
413: p_doc_subtype IN VARCHAR,

Line 733: -- The dummy uda_key_po_header_id from po_multi_mod_requests against which the UDA attributes are stored

729: -- If the Multi-Mod Address Value is NULL, the base PO Address takes precedence.
730: --Parameters:
731: --IN:
732: --p_uda_key_po_header_id
733: -- The dummy uda_key_po_header_id from po_multi_mod_requests against which the UDA attributes are stored
734: --p_uda_key_draft_id
735: -- The dummy p_uda_key_draft_id from po_multi_mod_requests against which the UDA attributes are stored
736: --p_po_header_id
737: -- The header id of the new Modification

Line 735: -- The dummy p_uda_key_draft_id from po_multi_mod_requests against which the UDA attributes are stored

731: --IN:
732: --p_uda_key_po_header_id
733: -- The dummy uda_key_po_header_id from po_multi_mod_requests against which the UDA attributes are stored
734: --p_uda_key_draft_id
735: -- The dummy p_uda_key_draft_id from po_multi_mod_requests against which the UDA attributes are stored
736: --p_po_header_id
737: -- The header id of the new Modification
738: --p_draft_id
739: -- The draft id of the new Modification

Line 2436: FROM po_multi_mod_requests

2432: -- The OrgAssignChange flag is 'Y' if the request Type is Vendor Change and for Agreements
2433: IF (l_doc_type_code = 'PA') THEN
2434: SELECT Decode(multi_mod_request_type, l_change_type_vendor, 'Y', 'N')
2435: INTO l_org_assign_change_flag
2436: FROM po_multi_mod_requests
2437: WHERE multi_mod_request_id = p_multi_mod_request_id;
2438: END IF;
2439: -- Derive CommunicatePriceChange
2440: IF (l_doc_type_code = 'PO') THEN

Line 2568: l_multi_mod_request_record po_multi_mod_requests%ROWTYPE;

2564: l_is_uda_enabled VARCHAR2(5);
2565: l_clause_updated_yn VARCHAR2(1);
2566: l_conc_mod_enabled VARCHAR2(1) ;
2567:
2568: l_multi_mod_request_record po_multi_mod_requests%ROWTYPE;
2569: l_fpds_reporting VARCHAR2(25);
2570:
2571: l_entity_names_tbl PO_TBL_VARCHAR30;
2572: l_entity_pk1 PO_TBL_VARCHAR240;

Line 2598: debug(d_module, d_position, 'Fetch record from po_multi_mod_requests');

2594:
2595: debug(d_module, d_position, 'Entered create_modification for po_header_id: '|| p_po_header_id, FND_API.G_TRUE);
2596:
2597: d_position := 10;
2598: debug(d_module, d_position, 'Fetch record from po_multi_mod_requests');
2599:
2600: SELECT *
2601: INTO l_multi_mod_request_record
2602: FROM po_multi_mod_requests

Line 2602: FROM po_multi_mod_requests

2598: debug(d_module, d_position, 'Fetch record from po_multi_mod_requests');
2599:
2600: SELECT *
2601: INTO l_multi_mod_request_record
2602: FROM po_multi_mod_requests
2603: WHERE multi_mod_request_id = p_multi_mod_request_id;
2604:
2605: -- Populate Document-level variables required down the flow
2606: SELECT uda_template_id,

Line 2745: po_multi_mod_requests multimod

2741: NVL(n_ext_attr16,0) + NVL(n_ext_attr17,0) + NVL(n_ext_attr18,0) +
2742: NVL(n_ext_attr19,0) + NVL(n_ext_attr20,0)),0) attr_sum
2743: BULK COLLECT INTO l_entity_pk2, l_sum_check_tbl
2744: FROM po_headers_all_ext_b ext,
2745: po_multi_mod_requests multimod
2746: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2747: AND ext.draft_id = multimod.uda_key_draft_id
2748: AND ext.attr_group_id = l_addr_attr_group_id
2749: AND multimod.multi_mod_request_id = p_multi_mod_request_id

Line 2913: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE;

2909: l_progress VARCHAR2(500) := '000';
2910: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2911: l_approval_source VARCHAR2(50);
2912: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE;
2913: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE;
2914:
2915: BEGIN
2916: l_progress := 'Process_Response_Internal: 001';
2917:

Line 2944: FROM PO_MULTI_MOD_REQUESTS

2940: WHERE DRAFT_ID = l_draft_id;
2941:
2942: SELECT MULTI_MOD_REQUEST_TYPE
2943: INTO l_multi_mod_req_type
2944: FROM PO_MULTI_MOD_REQUESTS
2945: WHERE MULTI_MOD_REQUEST_ID = l_multi_mod_req_id;
2946:
2947: IF l_document_type = 'PA' THEN
2948: DELETE FROM po_asl_documents