110: l_return_status VARCHAR2(1);
111: l_document_id NUMBER;
112: l_doc_revision_id NUMBER;
113: l_aso_object_type_code VARCHAR2(30);
114: l_association_tbl AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
115: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
116:
117: l_pre_V_msg_count NUMBER;
118: l_pre_V_msg_data VARCHAR2(2000);
350: /* End ; Date : Dec 10 2001 */
351: /*---------------------------------------------------------*/
352:
353: -- Call the Private API
354: AHL_DI_ASSO_DOC_ASO_PVT.CREATE_ASSOCIATION
355: (
356: p_api_version => 1.0,
357: p_init_msg_list => l_init_msg_list,
358: p_commit => p_commit,
579: l_return_status VARCHAR2(1);
580: l_aso_object_type_code VARCHAR2(30);
581: l_document_id NUMBER;
582: l_doc_revision_id NUMBER;
583: l_association_tbl AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
584: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
585:
586: l_pre_V_msg_count NUMBER;
587: l_pre_V_msg_data VARCHAR2(2000);
884: /* End ; Date : Dec 10 2001 */
885: /*---------------------------------------------------------*/
886:
887: -- Call the Private API
888: AHL_DI_ASSO_DOC_ASO_PVT.MODIFY_ASSOCIATION
889: (
890: p_api_version => 1.0,
891: p_init_msg_list => l_init_msg_list,
892: p_commit => p_commit,
1066: l_return_status VARCHAR2(1);
1067: l_aso_object_type_code VARCHAR2(30);
1068: l_document_id NUMBER;
1069: l_doc_revision_id NUMBER;
1070: l_association_tbl AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
1071: l_association_tblc AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
1072: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
1073: l_pre_V_msg_count NUMBER;
1074: l_pre_V_msg_data VARCHAR2(2000);
1067: l_aso_object_type_code VARCHAR2(30);
1068: l_document_id NUMBER;
1069: l_doc_revision_id NUMBER;
1070: l_association_tbl AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
1071: l_association_tblc AHL_DI_ASSO_DOC_ASO_PVT.association_tbl;
1072: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
1073: l_pre_V_msg_count NUMBER;
1074: l_pre_V_msg_data VARCHAR2(2000);
1075: l_pre_V_return_status VARCHAR2(1);
1285: IF p_x_association_tblm.COUNT > 0
1286: THEN
1287:
1288: -- Call the Private API
1289: AHL_DI_ASSO_DOC_ASO_PVT.MODIFY_ASSOCIATION
1290: (
1291: p_api_version => 1.0,
1292: p_init_msg_list => l_init_msg_list,
1293: p_commit => p_commit,
1500: -- Call the Private API
1501: IF p_x_association_tblC.COUNT > 0
1502: THEN
1503: x_return_status := 'S';
1504: AHL_DI_ASSO_DOC_ASO_PVT.CREATE_ASSOCIATION
1505: (
1506: p_api_version => 1.0,
1507: p_init_msg_list => l_init_msg_list,
1508: p_commit => p_commit,