[Home] [Help]
340: -- Now that conterms can be added at any revision of the PO
341: -- We need to check if the conterms flag has changed before
342: -- checking the contract amendments
343:
344: l_archived_conterms_flag := PO_CONTERMS_UTL_GRP.get_archive_conterms_flag (
345: p_po_header_id => l_po_header_id);
346:
347: IF nvl(l_conterms_yn,'N') = 'Y' AND
348: nvl(l_archived_conterms_flag,'N') = 'N' THEN
371:
372: l_k_terms_changed := OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED(
373: p_api_version => 1.0,
374: p_doc_id => l_po_header_id,
375: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
376: x_return_status => l_return_status,
377: x_msg_data => l_msg_data,
378: x_msg_count => l_msg_count);
379:
406:
407: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
408: p_api_version => 1.0,
409: p_doc_id => l_po_header_id,
410: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
411: x_return_status => l_return_status,
412: x_msg_data => l_msg_data,
413: x_msg_count => l_msg_count);
414:
433: l_api_name := 'OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended';
434: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended(
435: p_api_version => 1.0,
436: p_doc_id => l_po_header_id,
437: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
438: x_return_status => l_return_status,
439: x_msg_data => l_msg_data,
440: x_msg_count => l_msg_count);
441:
629: End if;
630: OKC_TERMS_UTIl_GRP.Get_Last_Update_Date(
631: p_api_version => 1.0,
632: p_doc_id => p_po_header_id,
633: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(p_po_doc_subtype),
634: x_deliverable_changed_date => l_deliv_upd_date,
635: x_terms_changed_date => l_articles_upd_date,
636: x_return_status => x_return_status,
637: x_msg_data => x_msg_data,
902: END IF;--debug on
903: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
904: p_api_version => 1.0,
905: p_bus_doc_id => p_po_header_id,
906: p_bus_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
907: p_bus_doc_version => l_po_revision_num,
908: p_event_code => 'PO_SIGNED',
909: p_event_date => p_signed_date,
910: p_sync_flag => FND_API.G_TRUE,
965: END IF;-- fnd debug
966: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
967: p_api_version => 1.0,
968: p_bus_doc_id => p_po_header_id,
969: p_bus_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
970: p_bus_doc_version => l_po_revision_num,
971: p_bus_doc_date_events_tbl => l_event_tbl,
972: x_msg_data => x_msg_data,
973: x_msg_count => x_msg_count,
999: -- Migrate PO:
1000: -- Replaced the pvt api with the grp one as this one checks if the
1001: -- previous revision has conterms in the first place as this is possible
1002: -- now with migrate PO
1003: PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision(
1004: p_api_version => 1.0,
1005: p_init_msg_list => FND_API.G_FALSE,
1006: p_header_id => p_po_header_id,
1007: p_revision_num => l_po_revision_num,
1032:
1033: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1034: p_api_version => 1.0,
1035: p_bus_doc_id => p_po_header_id,
1036: p_bus_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1037: -- Bug 3652222, should pass last signed revision
1038: -- p_bus_doc_version => (l_po_revision_num -1),
1039: p_bus_doc_version => l_last_signed_revision,
1040: x_msg_data => x_msg_data,
1281:
1282: result :=OKC_TERMS_UTIL_GRP.Deviation_From_Standard(
1283: p_api_version => 1.0,
1284: p_doc_id => l_po_header_id,
1285: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1286: x_return_status => l_return_status,
1287: x_msg_data => l_msg_data,
1288: x_msg_count => l_msg_count);
1289: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1430: --Call contracts to find out if contract template expired
1431: result :=OKC_TERMS_UTIl_GRP.IS_TEMPLATE_EXPIRED(
1432: p_api_version => 1.0,
1433: p_doc_id => l_po_header_id,
1434: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1435: x_return_status => l_return_status,
1436: x_msg_data => l_msg_data,
1437: x_msg_count => l_msg_count);
1438: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1581: --Call contracts to find out if contract articles attached
1582: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST(
1583: p_api_version => 1.0,
1584: p_doc_id => l_po_header_id,
1585: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1586: x_return_status => l_return_status,
1587: x_msg_data => l_msg_data,
1588: x_msg_count => l_msg_count);
1589: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1733: --Call contracts to find out if contract articles were amended in this revision
1734: result :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(
1735: p_api_version => 1.0,
1736: p_doc_id => l_po_header_id,
1737: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1738: x_return_status => l_return_status,
1739: x_msg_data => l_msg_data,
1740: x_msg_count => l_msg_count);
1741: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1888: --Call contracts to find out if contract deliverables were amended in this revision
1889: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Exist(
1890: p_api_version => 1.0,
1891: p_doc_id => l_po_header_id,
1892: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1893: x_return_status => l_return_status,
1894: x_msg_data => l_msg_data,
1895: x_msg_count => l_msg_count);
1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
2044: --Call contracts to find out if contract deliverables were amended in this revision
2045: result :=OKC_TERMS_UTIL_GRP.Is_Deliverable_Amended(
2046: p_api_version => 1.0,
2047: p_doc_id => l_po_header_id,
2048: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
2049: x_return_status => l_return_status,
2050: x_msg_data => l_msg_data,
2051: x_msg_count => l_msg_count);
2052: IF l_return_status = FND_API.G_RET_STS_SUCCESS then