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

Line 242: -- po_multi_mod_requests table data for validation

238: -- procedure to perform the validations and store the results in the object type po_multi_mod_val_results.
239: --Parameters:
240: --IN:
241: --p_multi_mod_requests
242: -- po_multi_mod_requests table data for validation
243: --p_multi_mod_docs
244: -- po_multi_mod_docs table data for validation
245: --p_multi_mod_changes
246: -- po_multi_mod_changes table data for validation

Line 263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;

259: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
260: )
261: is
262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;

Line 264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;

260: )
261: is
262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;

Line 265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;

261: is
262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;

Line 266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;

262: l_validation_set PO_TBL_VARCHAR2000;
263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;

Line 267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;

263: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%type;
264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;
271: l_multi_mod_docs PO_MULTI_MOD_DOCS_VAL_TYPE ;

Line 268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;

264: l_novation_effective_date PO_MULTI_MOD_REQUESTS.novation_effective_date%TYPE;
265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;
271: l_multi_mod_docs PO_MULTI_MOD_DOCS_VAL_TYPE ;
272: l_multi_mod_changes PO_MULTI_MOD_CHANGES_VAL_TYPE;

Line 269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;

265: l_acceptance_reqd_flag PO_MULTI_MOD_REQUESTS.acceptance_required_flag%TYPE;
266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;
271: l_multi_mod_docs PO_MULTI_MOD_DOCS_VAL_TYPE ;
272: l_multi_mod_changes PO_MULTI_MOD_CHANGES_VAL_TYPE;
273: d_mod CONSTANT VARCHAR2(100) := D_validate_multi_mod;

Line 270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;

266: l_acceptance_due_date PO_MULTI_MOD_REQUESTS.acceptance_due_date%TYPE;
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;
271: l_multi_mod_docs PO_MULTI_MOD_DOCS_VAL_TYPE ;
272: l_multi_mod_changes PO_MULTI_MOD_CHANGES_VAL_TYPE;
273: d_mod CONSTANT VARCHAR2(100) := D_validate_multi_mod;
274: d_position NUMBER := 0;

Line 303: --populate po_multi_mod_requests parameters

299: DELETE FROM po_multi_mod_val_results
300: WHERE multi_mod_request_id = p_multi_mod_request_id;
301: END IF;
302:
303: --populate po_multi_mod_requests parameters
304: d_position := 30;
305: BEGIN
306: SELECT multi_mod_request_type
307: ,NVL(novation_effective_date, sysdate)

Line 322: FROM po_multi_mod_requests

318: ,l_clm_noofcopies
319: ,l_exemption_reason
320: ,l_initiate_approval_flag
321: ,l_clm_contract_officer
322: FROM po_multi_mod_requests
323: WHERE multi_mod_request_id = p_multi_mod_request_id;
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_multi_mod_request_type := null;

Line 518: -- po_multi_mod_requests table data for validation

514: --IN:
515: --p_validation_set
516: -- Specifies the validations to perform.
517: --p_multi_mod_requests
518: -- po_multi_mod_requests table data for validation
519: --p_multi_mod_docs
520: -- po_multi_mod_docs table data for validation
521: --p_multi_mod_changes
522: -- po_multi_mod_changes table data for validation

Line 911: -- Request id from po_multi_mod_requests

907: -- Checks if atleast one document is selected for change.
908: --Parameters:
909: --IN:
910: --p_request_id
911: -- Request id from po_multi_mod_requests
912: --p_multi_mod_doc_id_tbl
913: -- Table type having the multi_mod_doc_id for the pertaining request_id
914: --p_validation_type
915: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 997: -- Request id from po_multi_mod_requests

993: -- Checks if exemption reason is specified when the initiate approval flag is unchecked
994: --Parameters:
995: --IN:
996: --p_request_id
997: -- Request id from po_multi_mod_requests
998: --p_exemption_reason
999: -- exemption reason from po_multi_mod_requests
1000: --p_initiate_app_flag
1001: -- initiate approval flag from po_multi_mod_requests

Line 999: -- exemption reason from po_multi_mod_requests

995: --IN:
996: --p_request_id
997: -- Request id from po_multi_mod_requests
998: --p_exemption_reason
999: -- exemption reason from po_multi_mod_requests
1000: --p_initiate_app_flag
1001: -- initiate approval flag from po_multi_mod_requests
1002: --p_validation_type
1003: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 1001: -- initiate approval flag from po_multi_mod_requests

997: -- Request id from po_multi_mod_requests
998: --p_exemption_reason
999: -- exemption reason from po_multi_mod_requests
1000: --p_initiate_app_flag
1001: -- initiate approval flag from po_multi_mod_requests
1002: --p_validation_type
1003: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
1004: --OUT:
1005: --x_result_type

Line 1090: -- Request id from po_multi_mod_requests

1086: -- Checks if new vendor contact is provided if the bi-lateral signature is enforced
1087: --Parameters:
1088: --IN:
1089: --p_request_id
1090: -- Request id from po_multi_mod_requests
1091: --p_acceptance_reqd_flag
1092: -- will hold the value of the bilateral indicator flag
1093: --p_multi_mod_doc_id_tbl
1094: -- Table type having the multi_mod_doc_id for the pertaining request id

Line 1252: -- Request id from po_multi_mod_requests

1248: -- checks if acceptance due date is provided when bi-lateral signature is enabled
1249: --Parameters:
1250: --IN:
1251: --p_request_id
1252: -- Request id from po_multi_mod_requests
1253: --p_acceptance_reqd_flag
1254: -- Indicates if bi-lateral signature is required
1255: --p_acceptance_due_date
1256: -- The date by which the document needs to be acknowledged

Line 1432: -- Request id from po_multi_mod_requests

1428: -- Checks if the new vendor name provided is not same as old vendor name in case of vendor_name_change
1429: --Parameters:
1430: --IN:
1431: --p_request_id
1432: -- Request id from po_multi_mod_requests
1433: --p_change_id_tbl
1434: --p_change_type_tbl
1435: --p_old_vendor_name_tbl
1436: --p_new_vendor_name_tbl

Line 1537: -- Request id from po_multi_mod_requests

1533: -- Checks if the new vendor id provided is not same as old vendor id in case of vendor_change
1534: --Parameters:
1535: --IN:
1536: --p_request_id
1537: -- Request id from po_multi_mod_requests
1538: --p_change_id_tbl
1539: --p_change_type_tbl
1540: --p_old_vendor_id_tbl
1541: --p_new_vendor_id_tbl

Line 1640: -- Request id from po_multi_mod_requests

1636: -- Checks if the new vendor is on hold
1637: --Parameters:
1638: --IN:
1639: --p_request_id
1640: -- Request id from po_multi_mod_requests
1641: --p_change_id_tbl
1642: --p_change_type_tbl
1643: --p_new_vendor_id_tbl
1644: --p_validation_type

Line 1751: -- Request id from po_multi_mod_requests

1747: -- Checks if the clause change that has been done as part of a multi mod request is valid
1748: --Parameters:
1749: --IN:
1750: --p_request_id
1751: -- Request id from po_multi_mod_requests
1752: --p_validation_type
1753: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
1754: --OUT:
1755: --x_result_type

Line 1830: -- Request id from po_multi_mod_requests

1826: -- Checks if atleast one change has been done as part of this multi mod request.There should either be a address change or clause change or vendor change
1827: --Parameters:
1828: --IN:
1829: --p_request_id
1830: -- Request id from po_multi_mod_requests
1831: --p_change_id_tbl
1832: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
1833: --p_validation_type
1834: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 1942: -- Request id from po_multi_mod_requests

1938: -- Checks whether the new vendor site has been provided for each of the existing old vendor sites
1939: --Parameters:
1940: --IN:
1941: --p_request_id
1942: -- Request id from po_multi_mod_requests
1943: --p_change_id_tbl
1944: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
1945: --p_change_type_tbl
1946: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes

Line 2054: -- Request id from po_multi_mod_requests

2050: -- Checks whether the new vendor site has a active CCR registration
2051: --Parameters:
2052: --IN:
2053: --p_request_id
2054: -- Request id from po_multi_mod_requests
2055: --p_change_id_tbl
2056: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
2057: --p_change_type_tbl
2058: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes

Line 2273: FROM po_multi_mod_requests

2269: uda_key_draft_id
2270: INTO l_uda_template_id,
2271: l_uda_key_po_header_id,
2272: l_uda_key_draft_id
2273: FROM po_multi_mod_requests
2274: WHERE multi_mod_request_id = p_request_id;
2275:
2276: -- Prepare l_external_attr_value_pairs
2277: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

Line 2535: -- Request id from po_multi_mod_requests

2531: -- Checks if there has been any address change made
2532: --Parameters:
2533: --IN:
2534: --p_request_id
2535: -- Request id from po_multi_mod_requests
2536: --End of Comments
2537: -------------------------------------------------------------------------------
2538: FUNCTION has_address_changed(p_request_id IN NUMBER)
2539:

Line 2576: po_multi_mod_requests multimod

2572: NVL(n_ext_attr16,0) + NVL(n_ext_attr17,0) + NVL(n_ext_attr18,0) +
2573: NVL(n_ext_attr19,0) + NVL(n_ext_attr20,0)),0) attr_sum
2574: INTO l_sum_check
2575: FROM po_headers_all_ext_b ext,
2576: po_multi_mod_requests multimod
2577: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2578: AND ext.draft_id = multimod.uda_key_draft_id
2579: AND multimod.multi_mod_request_id = p_request_id
2580: AND ext.attr_group_id = l_addr_attr_group_id

Line 2620: -- Request id from po_multi_mod_requests

2616: -- Checks if there has been any clause change made
2617: --Parameters:
2618: --IN:
2619: --p_request_id
2620: -- Request id from po_multi_mod_requests
2621: --End of Comments
2622: -------------------------------------------------------------------------------
2623: FUNCTION has_clause_changed(p_request_id IN NUMBER)
2624: RETURN VARCHAR2

Line 2678: -- Request id from po_multi_mod_requests

2674: -- Checks if there has been any vendor change made
2675: --Parameters:
2676: --IN:
2677: --p_request_id
2678: -- Request id from po_multi_mod_requests
2679: --p_change_id_tbl
2680: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
2681: --End of Comments
2682: -------------------------------------------------------------------------------

Line 2690: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%TYPE;

2686: IS
2687: l_has_vendor_changed VARCHAR2(1) := 'N';
2688: d_mod CONSTANT VARCHAR2(100) := D_has_vendor_changed;
2689: d_position NUMBER := 0;
2690: l_multi_mod_request_type PO_MULTI_MOD_REQUESTS.multi_mod_request_type%TYPE;
2691: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
2692:
2693: BEGIN
2694:

Line 2704: FROM po_multi_mod_requests

2700: d_position := 10;
2701: BEGIN
2702: SELECT multi_mod_request_type
2703: INTO l_multi_mod_request_type
2704: FROM po_multi_mod_requests
2705: WHERE multi_mod_request_id = p_request_id;
2706: EXCEPTION
2707: WHEN no_data_found THEN
2708: l_multi_mod_request_type := null;

Line 2748: -- Request id from po_multi_mod_requests

2744: -- changes.
2745: --Parameters:
2746: --IN:
2747: --p_request_id
2748: -- Request id from po_multi_mod_requests
2749: --x_result_type
2750: -- Result type of the validation.
2751: --x_results
2752: -- Validation results. Errors and warnings.

Line 2836: -- Request id from po_multi_mod_requests

2832: -- changes at that particular address.
2833: --Parameters:
2834: --IN:
2835: --p_request_id
2836: -- Request id from po_multi_mod_requests
2837: --x_result_type
2838: -- Result type of the validation.
2839: --x_results
2840: -- Validation results. Errors and warnings.

Line 2894: po_multi_mod_requests multimod,

2890: BULK COLLECT INTO l_document_number_tbl,
2891: l_address_code_tbl, l_modification_number_tbl,
2892: l_sum_check_tbl
2893: FROM po_headers_all_ext_b ext,
2894: po_multi_mod_requests multimod,
2895: po_entity_locks pel,
2896: po_multi_mod_docs pmmd,
2897: po_headers_all pha,
2898: po_doc_style_headers pdsh,

Line 2967: -- Request id from po_multi_mod_requests

2963: -- are not enabled for the document style.
2964: --Parameters:
2965: --IN:
2966: --p_request_id
2967: -- Request id from po_multi_mod_requests
2968: --x_result_type
2969: -- Result type of the validation.
2970: --x_results
2971: -- Validation results. Errors and warnings.

Line 3053: -- Request id from po_multi_mod_requests

3049: -- Checks if there are IDVs selected for supplier change and aslo checks if all the awards corresponding to the IDV are selected as well.
3050: --Parameters:
3051: --IN:
3052: --p_request_id
3053: -- Request id from po_multi_mod_requests
3054: --p_document_id_tbl
3055: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes
3056: --p_multi_mod_doc_id_tbl
3057: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

Line 3175: -- Request id from po_multi_mod_requests

3171: -- Checks if there are IDVs selected for supplier change and aslo checks if all the awards corresponding to the IDV are selected as well.
3172: --Parameters:
3173: --IN:
3174: --p_request_id
3175: -- Request id from po_multi_mod_requests
3176: --p_document_id_tbl
3177: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes
3178: --p_multi_mod_doc_id_tbl
3179: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

Line 3300: -- Request id from po_multi_mod_requests

3296: -- Performs all the receipts related checks that should be made and reported as receipts related exceptions
3297: --Parameters:
3298: --IN:
3299: --p_request_id
3300: -- Request id from po_multi_mod_requests
3301: --p_document_id_tbl
3302: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes
3303: --p_multi_mod_doc_id_tbl
3304: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

Line 3663: -- Request id from po_multi_mod_requests

3659: -- Performs all the Invoices related checks that should be made and reported as Invoices related Exceptions
3660: --Parameters:
3661: --IN:
3662: --p_request_id
3663: -- Request id from po_multi_mod_requests
3664: --p_document_id_tbl
3665: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes
3666: --p_multi_mod_doc_id_tbl
3667: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

Line 4376: -- sets the validation status of the po_multi_mod_requests

4372: --Start of Comments
4373: --Name: set_validation_status
4374: --Pre-reqs: None.
4375: --Function:
4376: -- sets the validation status of the po_multi_mod_requests
4377: --Parameters:
4378: --IN:
4379: --p_vendor_id
4380: --End of Comments

Line 4400: UPDATE po_multi_mod_requests

4396: END IF;
4397:
4398: d_position := 10;
4399:
4400: UPDATE po_multi_mod_requests
4401: SET validation_status = p_validation_status
4402: ,last_update_date = sysdate
4403: ,last_update_login = fnd_global.login_id
4404: ,last_updated_by = fnd_global.user_id

Line 4426: -- Request id from po_multi_mod_requests

4422: -- Call the PA validate_novation_projects API to perform the project related validations for novation
4423: --Parameters:
4424: --IN:
4425: --p_request_id
4426: -- Request id from po_multi_mod_requests
4427: --p_document_id_tbl
4428: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes
4429: --p_multi_mod_doc_id_tbl
4430: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

Line 4645: UPDATE po_multi_mod_requests

4641: , fnd_global.conc_request_id
4642: );
4643: END LOOP;
4644: /*bug 13094620 - the selection changed flag has to be reset once the supplier change exceptions program has been regenerated.*/
4645: UPDATE po_multi_mod_requests
4646: SET selection_changed_flag = null
4647: WHERE multi_mod_request_id = p_multi_mod_request_id
4648: and selection_changed_flag is not null;
4649: commit;