APPS.OKC_CDRL_PVT dependencies on OKC_DELIVERABLE_PROCESS_PVT

Line 67: AND att.entity_name = OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME

63: ,doc.datatype_id
64: FROM fnd_attached_documents att
65: ,fnd_documents doc
66: WHERE att.document_id = doc.document_id
67: AND att.entity_name = OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
68: AND att.pk1_value = cdrl_id;
69:
70: TYPE id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
71: attach_doc_id_tbl id_tbl_type;

Line 541: okc_deliverable_process_pvt.copy_deliverable_udas(

537:
538: -- copy uda data
539: FOR i IN 1..old_del_id_tbl.Count
540: LOOP
541: okc_deliverable_process_pvt.copy_deliverable_udas(
542: old_del_id_tbl(i),
543: new_del_id_tbl(i),
544: l_return_status,
545: l_msg_count,

Line 560: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(

556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'120: Inside loop'||to_char(old_del_id_tbl(i)));
558: END IF;
559: -- check if attachments exists
560: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(
561: p_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
562: ,p_pk1_value => old_del_id_tbl(i)
563: ) THEN
564: fnd_attached_documents2_pkg.copy_attachments(

Line 561: p_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME

557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'120: Inside loop'||to_char(old_del_id_tbl(i)));
558: END IF;
559: -- check if attachments exists
560: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(
561: p_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
562: ,p_pk1_value => old_del_id_tbl(i)
563: ) THEN
564: fnd_attached_documents2_pkg.copy_attachments(
565: X_from_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,

Line 565: X_from_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,

561: p_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
562: ,p_pk1_value => old_del_id_tbl(i)
563: ) THEN
564: fnd_attached_documents2_pkg.copy_attachments(
565: X_from_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
566: X_from_pk1_value => To_Char(old_del_id_tbl(i)),
567: X_to_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
568: X_to_pk1_value => to_char(new_del_id_tbl(i)),
569: X_CREATED_BY => FND_GLOBAL.User_id,

Line 567: X_to_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,

563: ) THEN
564: fnd_attached_documents2_pkg.copy_attachments(
565: X_from_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
566: X_from_pk1_value => To_Char(old_del_id_tbl(i)),
567: X_to_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
568: X_to_pk1_value => to_char(new_del_id_tbl(i)),
569: X_CREATED_BY => FND_GLOBAL.User_id,
570: X_LAST_UPDATE_LOGIN => Fnd_Global.Login_Id
571: );

Line 2021: okc_deliverable_process_pvt.copy_deliverable_udas(

2017: x_msg_data VARCHAR2(1000);
2018: x_errorcode NUMBER;
2019: BEGIN
2020: l_new_id :=OKC_DELIVERABLE_ID_S.NEXTVAL;
2021: okc_deliverable_process_pvt.copy_deliverable_udas(
2022: p_old_deliverable_id,
2023: l_new_id,
2024: x_return_status,
2025: x_msg_count,