APPS.AHL_FMP_MR_RELATION_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 241: FROM AHL_MR_RELATIONSHIPS

237: BEGIN
238: x_return_status:=FND_API.G_RET_STS_SUCCESS;
239:
240: SELECT COUNT(*) INTO l_counter
241: FROM AHL_MR_RELATIONSHIPS
242: START WITH RELATED_MR_HEADER_ID=P_RELATED_MR_HEADER_ID
243: CONNECT BY PRIOR RELATED_MR_HEADER_ID=MR_HEADER_ID;
244: EXCEPTION
245: WHEN l_cyclic_loop THEN

Line 292: from AHL_MR_RELATIONSHIPS

288:
289: CURSOR CHECK_UNIQ(c_mr_header_id NUMBER,c_related_mr_header_id NUMBER,c_relationship_code VARCHAR2)
290: IS
291: select *
292: from AHL_MR_RELATIONSHIPS
293: where MR_HEADER_ID=C_MR_HEADER_ID
294: and RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID
295: and relationship_code=c_relationship_code;
296:

Line 634: delete AHL_MR_RELATIONSHIPS

630:
631: IF nvl(x_return_status,'X')='S'
632: THEN
633: IF p_x_mr_relation_tbl(i).DML_OPERATION='D' then
634: delete AHL_MR_RELATIONSHIPS
635: where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
636: and OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;
637:
638: if sql%rowcount=0 then

Line 649: update AHL_mr_RELATIONSHIPS

645:
646: IF x_return_status=FND_API.G_RET_STS_SUCCESS
647: THEN
648:
649: update AHL_mr_RELATIONSHIPS
650: set MR_HEADER_ID = p_x_mr_relation_tbl(i).MR_HEADER_ID,
651: RELATED_MR_HEADER_ID = p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
652: RELATIONSHIP_CODE = p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
653: MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,

Line 686: SELECT AHL_MR_RELATIONSHIPS_S.NEXTVAL

682:
683: ELSIF p_x_mr_relation_tbl(i).DML_operation='C'
684: then
685:
686: SELECT AHL_MR_RELATIONSHIPS_S.NEXTVAL
687: INTO p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
688: FROM DUAL;
689:
690: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;

Line 694: insert into AHl_mr_RELATIONSHIPS(

690: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;
691:
692: IF x_return_status=FND_API.G_RET_STS_SUCCESS
693: THEN
694: insert into AHl_mr_RELATIONSHIPS(
695: MR_RELATIONSHIP_ID,
696: OBJECT_VERSION_NUMBER,
697: LAST_UPDATE_DATE,
698: LAST_UPDATED_BY,