APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 610: FROM AHL_MR_HEADERS_APP_V

606:
607: CURSOR get_mr_title(c_mr_header_id NUMBER)
608: IS
609: SELECT title,object_version_number
610: FROM AHL_MR_HEADERS_APP_V
611: WHERE mr_header_id= c_mr_header_id;
612:
613: CURSOR get_mr_header(c_title VARCHAR2)
614: IS

Line 616: FROM AHL_MR_HEADERS_APP_V

612:
613: CURSOR get_mr_header(c_title VARCHAR2)
614: IS
615: SELECT mr_header_id,title,object_version_number
616: FROM AHL_MR_HEADERS_APP_V
617: WHERE UPPER(TITLE)=UPPER(LTRIM(RTRIM(c_title)))
618: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
619:
620: CURSOR get_titlecount(c_title VARCHAR2)

Line 623: FROM AHL_MR_HEADERS_APP_V

619:
620: CURSOR get_titlecount(c_title VARCHAR2)
621: IS
622: SELECT COUNT(*)
623: FROM AHL_MR_HEADERS_APP_V
624: WHERE UPPER(TITLE)=UPPER(c_title)
625: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
626:
627: CURSOR get_prec_mrheader_info(c_mr_header_id NUMBER)

Line 630: FROM AHL_MR_HEADERS_APP_V

626:
627: CURSOR get_prec_mrheader_info(c_mr_header_id NUMBER)
628: IS
629: SELECT mr_header_id,title,object_version_number,revision
630: FROM AHL_MR_HEADERS_APP_V
631: WHERE MR_HEADER_ID=C_MR_HEADER_ID
632: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
633:
634: CURSOR get_mrItemId(c_billing_item VARCHAR2)

Line 911: from AHL_MR_HEADERS_APP_V

907: IF p_x_mr_header_rec.version_number=FND_API.G_MISS_NUM OR
908: p_x_mr_header_rec.version_number IS NULL
909: THEN
910: select version_number into p_x_mr_header_rec.version_number
911: from AHL_MR_HEADERS_APP_V
912: where mr_header_id=p_x_mr_header_rec.mr_header_id;
913: END IF;
914:
915: END IF;

Line 927: SELECT * FROM AHL_MR_HEADERS_APP_V

923: )
924: as
925: Cursor GetMrdet(C_MR_HEADER_ID NUMBER)
926: IS
927: SELECT * FROM AHL_MR_HEADERS_APP_V
928: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
929: l_mr_rec GetMrdet%rowtype;
930: l_counter NUMBER:=0;
931: BEGIN

Line 1039: FROM AHL_MR_HEADERS_APP_V

1035:
1036: CURSOR get_mr_title(c_mr_header_id number)
1037: IS
1038: SELECT title,object_version_number
1039: FROM AHL_MR_HEADERS_APP_V
1040: WHERE mr_header_id= c_mr_header_id;
1041:
1042: CURSOR
1043: check_prog_subtype(C_PROGRAM_TYPE_CODE VARCHAR2,C_PROGRAM_SUBTYPE_CODE VARCHAR2)

Line 1109: FROM AHL_MR_HEADERS_APP_V

1105: TITLE,
1106: VERSION_NUMBER,
1107: MR_STATUS_CODE,
1108: EFFECTIVE_FROM
1109: FROM AHL_MR_HEADERS_APP_V
1110: WHERE MR_HEADER_ID=C_MR_HEADER_ID
1111: AND object_version_number=p_mr_header_rec.object_Version_number;
1112:
1113: l_mr_rec GetHeaderInfo%ROWTYPE;

Line 1119: FROM AHL_MR_HEADERS_APP_V

1115:
1116: Cursor GetHeaderInfo1(C_TITLE VARCHAR2,C_VERSION_NUMBER NUMBER)
1117: IS
1118: SELECT MR_HEADER_ID,TITLE,VERSION_NUMBER,MR_STATUS_CODE,EFFECTIVE_FROM
1119: FROM AHL_MR_HEADERS_APP_V
1120: WHERE upper(TITLE)=upper(C_TITLE)
1121: and version_number=c_version_number-1;
1122:
1123: l_mr_rec1 GetHeaderInfo1%ROWTYPE;

Line 1594: FROM AHL_MR_HEADERS_APP_V

1590:
1591: -- Title Should not Repeat in Create mode
1592:
1593: SELECT COUNT(*) INTO l_title_counter
1594: FROM AHL_MR_HEADERS_APP_V
1595: WHERE upper(ltrim(rtrim(TITLE)))=upper(ltrim(rtrim(l_mr_header_rec.title)));
1596: IF l_title_counter >0 then
1597: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TITLE_INVALID');
1598: FND_MSG_PUB.ADD;