[Home] [Help]
347: '1000: Entered lock_entity'
348: );
349: END IF;
350:
351: -- Standard Start of API savepoint
352: SAVEPOINT g_lock_entity_grp;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call (l_api_version,
350:
351: -- Standard Start of API savepoint
352: SAVEPOINT g_lock_entity_grp;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call (l_api_version,
356: p_api_version,
357: l_api_name,
358: g_pkg_name
517: x_return_status := g_ret_sts_error;
518: END IF;
519: END IF;
520:
521: -- Standard check of p_commit
522: IF fnd_api.to_boolean (p_commit)
523: THEN
524: COMMIT WORK;
525: END IF;
664: AND target.orig_system_reference_id1 = SOURCE.DELIVERABLE_ID
665: AND klock.entity_name = 'DELIVERABLE'
666: AND klock.entity_pk1 = TO_CHAR (SOURCE.orig_system_reference_id1);
667: BEGIN
668: -- Standard Start of API savepoint
669: SAVEPOINT g_rebuild_locks_grp;
670: -- Release the locks from Source Document Type and Doc ID
671: -- Delete the locks from Build_from_doc_type and build_to_doc_id
672: release_locks (p_api_version => 1,
757: FORALL i IN l_new_dlvbl_id_tbl.first..l_new_dlvbl_id_tbl.LAST
758: UPDATE OKC_DELIVERABLES
759: SET orig_system_reference_id1 = l_new_dlvbl_id_tbl(i)
760: WHERE deliverable_id = l_upd_dlvbl_id_tbl(i);
761: -- Standard check of p_commit
762: IF fnd_api.to_boolean (p_commit)
763: THEN
764: COMMIT WORK;
765: END IF;
785: DELETE FROM okc_k_entity_locks
786: WHERE lock_by_document_type = p_doc_type
787: AND lock_by_document_id = p_doc_id;
788:
789: -- Standard check of p_commit
790: IF fnd_api.to_boolean (p_commit)
791: THEN
792: COMMIT WORK;
793: END IF;
858: '1000: Entered unlock_entity'
859: );
860: END IF;
861:
862: -- Standard Start of API savepoint
863: SAVEPOINT g_unlock_entity_grp;
864:
865: -- Standard call to check for call compatibility.
866: IF NOT fnd_api.compatible_api_call (l_api_version,
861:
862: -- Standard Start of API savepoint
863: SAVEPOINT g_unlock_entity_grp;
864:
865: -- Standard call to check for call compatibility.
866: IF NOT fnd_api.compatible_api_call (l_api_version,
867: p_api_version,
868: l_api_name,
869: g_pkg_name
1063: )
1064: IS
1065: CURSOR l_get_art_csr
1066: IS
1067: SELECT sav_sae_id, (SELECT standard_yn
1068: FROM okc_articles_all
1069: WHERE article_id = sav_sae_id) standard_yn,
1070: kart.attribute_category, kart.attribute1, kart.attribute2,
1071: kart.attribute3, kart.attribute4, kart.attribute5,
1065: CURSOR l_get_art_csr
1066: IS
1067: SELECT sav_sae_id, (SELECT standard_yn
1068: FROM okc_articles_all
1069: WHERE article_id = sav_sae_id) standard_yn,
1070: kart.attribute_category, kart.attribute1, kart.attribute2,
1071: kart.attribute3, kart.attribute4, kart.attribute5,
1072: kart.attribute6, kart.attribute7, kart.attribute8,
1073: kart.attribute9, kart.attribute10, kart.attribute11,
1174: x_return_status := g_ret_sts_error;
1175: RAISE fnd_api.g_exc_error;
1176: END IF;
1177:
1178: IF l_doc_clause_rec.standard_yn = 'N'
1179: THEN
1180: -- Copying Non-Standard Article and get the new article_id and article_Version_id
1181: okc_articles_grp.copy_article
1182: (p_api_version => 1,
1176: END IF;
1177:
1178: IF l_doc_clause_rec.standard_yn = 'N'
1179: THEN
1180: -- Copying Non-Standard Article and get the new article_id and article_Version_id
1181: okc_articles_grp.copy_article
1182: (p_api_version => 1,
1183: p_init_msg_list => fnd_api.g_false,
1184: p_validation_level => fnd_api.g_valid_level_full,
1184: p_validation_level => fnd_api.g_valid_level_full,
1185: p_commit => fnd_api.g_false,
1186: p_article_version_id => l_doc_clause_rec.article_version_id,
1187: p_new_article_title => NULL,
1188: p_create_standard_yn => 'N',
1189: x_article_version_id => x_article_version_id,
1190: x_article_id => x_article_id,
1191: x_article_number => x_article_number,
1192: x_return_status => x_return_status,
2471: '1000: Entered revert_changes'
2472: );
2473: END IF;
2474:
2475: -- Standard Start of API savepoint
2476: SAVEPOINT g_revert_changes_grp;
2477:
2478: -- Standard call to check for call compatibility.
2479: IF NOT fnd_api.compatible_api_call (l_api_version,
2474:
2475: -- Standard Start of API savepoint
2476: SAVEPOINT g_revert_changes_grp;
2477:
2478: -- Standard call to check for call compatibility.
2479: IF NOT fnd_api.compatible_api_call (l_api_version,
2480: p_api_version,
2481: l_api_name,
2482: g_pkg_name
2549: -- Delete the lock from the table
2550: DELETE FROM okc_k_entity_locks
2551: WHERE k_entity_lock_id = p_K_ENTITY_LOCK_ID;
2552:
2553: -- Standard check of p_commit
2554: IF fnd_api.to_boolean (p_commit)
2555: THEN
2556: COMMIT WORK;
2557: END IF;
2640: l_document_number VARCHAR2(240);
2641:
2642: BEGIN
2643:
2644: IF p_document_type IN ( 'PO_STANDARD_MOD' , 'PA_BLANKET_MOD' , 'PA_CONTRACT_MOD' ) THEN
2645: l_from_table := 'PO_DRAFTS' ;
2646: l_pk1_col_name := 'DRAFT_ID';
2647: l_doc_num_col_name := 'MODIFICATION_NUMBER';
2648: END IF;
3444: '100: p_update_to_doc_id : ' || p_update_to_doc_id
3445: );
3446: END IF;
3447:
3448: -- Standard Start of API savepoint
3449: SAVEPOINT g_rebuild_ids_grp;
3450:
3451: X_RETURN_STATUS := G_RET_STS_SUCCESS;
3452:
3540: RAISE FND_API.G_EXC_ERROR ;
3541: END IF;
3542:
3543:
3544: -- Standard check of p_commit
3545: IF fnd_api.to_boolean (p_commit)
3546: THEN
3547: COMMIT WORK;
3548: END IF;