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_CHANGES

Line 246: -- po_multi_mod_changes table data for validation

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
247: --p_validation_type
248: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
249: --OUT:
250: --x_result_type

Line 272: l_multi_mod_changes PO_MULTI_MOD_CHANGES_VAL_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;
275:
276: BEGIN

Line 372: --populate po_multi_mod_changes records into p_multi_mod_docs object type

368: IF PO_LOG.d_stmt THEN
369: PO_LOG.stmt(d_mod,d_position,'l_multi_mod_docs-count',l_multi_mod_docs.multi_mod_doc_id.COUNT);
370: END IF;
371:
372: --populate po_multi_mod_changes records into p_multi_mod_docs object type
373: d_position := 50;
374: BEGIN
375: SELECT multi_mod_change_id
376: ,multi_mod_request_id

Line 402: FROM po_multi_mod_changes

398: ,l_multi_mod_changes.new_vendor_site_id
399: ,l_multi_mod_changes.new_vendor_contact_id
400: ,l_multi_mod_changes.old_remit_to_addr
401: ,l_multi_mod_changes.new_remit_to_addr
402: FROM po_multi_mod_changes
403: WHERE multi_mod_request_id = p_multi_mod_request_id;
404: EXCEPTION
405: WHEN OTHERS THEN
406: null;

Line 522: -- po_multi_mod_changes table data for validation

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
523: --p_validation_type
524: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
525: --OUT:
526: --x_result_type

Line 543: ,p_multi_mod_changes IN PO_MULTI_MOD_CHANGES_VAL_TYPE

539: ,p_exemption_reason IN VARCHAR2
540: ,p_initiate_approval_flag IN VARCHAR2
541: ,p_clm_contract_officer IN NUMBER
542: ,p_multi_mod_docs IN PO_MULTI_MOD_DOCS_VAL_TYPE
543: ,p_multi_mod_changes IN PO_MULTI_MOD_CHANGES_VAL_TYPE
544: ,p_validation_type IN VARCHAR2
545: ,x_result_type OUT NOCOPY VARCHAR2
546: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
547: )

Line 1098: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes

1094: -- Table type having the multi_mod_doc_id for the pertaining request id
1095: --p_document_id_tbl
1096: -- Table type having the document_ids of the documents selected for change for the pertaining request id
1097: --p_change_id_tbl
1098: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
1099: --p_change_type_tbl
1100: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
1101: --p_org_id_tbl
1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes

Line 1100: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes

1096: -- Table type having the document_ids of the documents selected for change for the pertaining request id
1097: --p_change_id_tbl
1098: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
1099: --p_change_type_tbl
1100: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
1101: --p_org_id_tbl
1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1103: --p_old_vendor_site_id_tbl
1104: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes

1098: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes
1099: --p_change_type_tbl
1100: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
1101: --p_org_id_tbl
1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1103: --p_old_vendor_site_id_tbl
1104: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1105: --p_new_vendor_site_id_tbl
1106: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 1104: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

1100: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
1101: --p_org_id_tbl
1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1103: --p_old_vendor_site_id_tbl
1104: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1105: --p_new_vendor_site_id_tbl
1106: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
1107: --p_validation_type
1108: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 1106: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

1102: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1103: --p_old_vendor_site_id_tbl
1104: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1105: --p_new_vendor_site_id_tbl
1106: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
1107: --p_validation_type
1108: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
1109: --OUT:
1110: --x_result_type

Line 1832: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes

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'
1835: --OUT:
1836: --x_result_type

Line 1944: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes

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
1947: --p_org_id_tbl
1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes

Line 1946: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes

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
1947: --p_org_id_tbl
1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1949: --p_old_vendor_site_id_tbl
1950: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes

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
1947: --p_org_id_tbl
1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1949: --p_old_vendor_site_id_tbl
1950: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1951: --p_new_vendor_site_id_tbl
1952: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 1950: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

1946: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
1947: --p_org_id_tbl
1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1949: --p_old_vendor_site_id_tbl
1950: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1951: --p_new_vendor_site_id_tbl
1952: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
1953: --p_validation_type
1954: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 1952: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

1948: -- Table type having all the org_ids for a particular request_id in po_multi_mod_changes
1949: --p_old_vendor_site_id_tbl
1950: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
1951: --p_new_vendor_site_id_tbl
1952: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
1953: --p_validation_type
1954: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
1955: --OUT:
1956: --x_result_type

Line 2056: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes

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
2059: --p_old_vendor_site_id_tbl
2060: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 2058: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes

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
2059: --p_old_vendor_site_id_tbl
2060: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
2061: --p_new_vendor_site_id_tbl
2062: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

Line 2060: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes

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
2059: --p_old_vendor_site_id_tbl
2060: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
2061: --p_new_vendor_site_id_tbl
2062: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
2063: --p_validation_type
2064: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'

Line 2062: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes

2058: -- Table type having all the change_types for a particular request_id in po_multi_mod_changes
2059: --p_old_vendor_site_id_tbl
2060: -- Table type having all the old_vendor_site_ids for a particular request_id in po_multi_mod_changes
2061: --p_new_vendor_site_id_tbl
2062: -- Table type having all the new_vendor_site_ids for a particular request_id in po_multi_mod_changes
2063: --p_validation_type
2064: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
2065: --OUT:
2066: --x_result_type

Line 2119: FROM po_multi_mod_changes

2115:
2116: BEGIN
2117: SELECT old_vendor_id, new_vendor_id
2118: INTO l_old_vendor_id, l_new_vendor_id
2119: FROM po_multi_mod_changes
2120: WHERE multi_mod_request_id = p_request_id
2121: AND change_type = 'VENDOR';
2122: EXCEPTION
2123: WHEN no_data_found THEN

Line 2680: -- Table type having all the multi_mod_change_ids for a particular request_id in po_multi_mod_changes

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: -------------------------------------------------------------------------------
2683: FUNCTION has_vendor_changed(p_request_id IN NUMBER
2684: ,p_change_id_tbl IN PO_TBL_NUMBER)

Line 3055: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes

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
3058: --OUT:
3059: --x_result_type

Line 3057: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

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
3058: --OUT:
3059: --x_result_type
3060: -- Identifies if the validation was a success or failure
3061: --x_results

Line 3177: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes

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
3180: --OUT:
3181: --x_result_type

Line 3179: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

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
3180: --OUT:
3181: --x_result_type
3182: -- Identifies if the validation was a success or failure
3183: --x_results

Line 3302: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes

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
3305: --OUT:
3306: --x_result_type

Line 3304: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

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
3305: --OUT:
3306: --x_result_type
3307: -- Identifies if the validation was a success or failure
3308: --x_results

Line 3490: FROM po_multi_mod_changes

3486: d_position := 100;
3487: BEGIN
3488: SELECT old_vendor_id
3489: INTO l_vendor_id
3490: FROM po_multi_mod_changes
3491: WHERE multi_mod_request_id = p_request_id
3492: AND change_type = 'VENDOR';
3493: EXCEPTION
3494: WHEN no_data_found THEN

Line 3665: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes

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
3668: --OUT:
3669: --x_result_type

Line 3667: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

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
3668: --OUT:
3669: --x_result_type
3670: -- Identifies if the validation was a success or failure
3671: --x_results

Line 3831: FROM po_multi_mod_changes

3827: d_position := 70;
3828: BEGIN
3829: SELECT old_vendor_id
3830: INTO l_vendor_id
3831: FROM po_multi_mod_changes
3832: WHERE multi_mod_request_id = p_request_id
3833: AND change_type = 'VENDOR';
3834: EXCEPTION
3835: WHEN no_data_found THEN

Line 4428: -- Table type having all the document_ids for a particular request_id in po_multi_mod_changes

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
4431: --OUT:
4432: --x_result_type

Line 4430: -- Table type having all the p_multi_mod_doc_ids for a particular request_id in po_multi_mod_changes

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
4431: --OUT:
4432: --x_result_type
4433: -- Identifies if the validation was a success or failure
4434: --x_results

Line 4479: FROM po_multi_mod_changes

4475: --get the vendor_id and call the projects api for validations
4476: BEGIN
4477: SELECT old_vendor_id
4478: INTO l_vendor_id
4479: FROM po_multi_mod_changes
4480: WHERE multi_mod_request_id = p_request_id
4481: AND change_type = 'VENDOR';
4482: EXCEPTION
4483: WHEN no_data_found THEN