APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 663: FROM AHL_MR_HEADERS_APP_V

659:
660: CURSOR get_mr_title(c_mr_header_id NUMBER)
661: IS
662: SELECT title,object_version_number
663: FROM AHL_MR_HEADERS_APP_V
664: WHERE mr_header_id= c_mr_header_id;
665:
666: CURSOR get_mr_header(c_title VARCHAR2)
667: IS

Line 669: FROM AHL_MR_HEADERS_APP_V

665:
666: CURSOR get_mr_header(c_title VARCHAR2)
667: IS
668: SELECT mr_header_id,title,object_version_number
669: FROM AHL_MR_HEADERS_APP_V
670: WHERE UPPER(TITLE)=UPPER(LTRIM(RTRIM(c_title)))
671: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
672:
673: CURSOR get_titlecount(c_title VARCHAR2)

Line 676: FROM AHL_MR_HEADERS_APP_V

672:
673: CURSOR get_titlecount(c_title VARCHAR2)
674: IS
675: SELECT COUNT(*)
676: FROM AHL_MR_HEADERS_APP_V
677: WHERE UPPER(TITLE)=UPPER(c_title)
678: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
679:
680: CURSOR get_prec_mrheader_info(c_mr_header_id NUMBER)

Line 683: FROM AHL_MR_HEADERS_APP_V

679:
680: CURSOR get_prec_mrheader_info(c_mr_header_id NUMBER)
681: IS
682: SELECT mr_header_id,title,object_version_number,revision
683: FROM AHL_MR_HEADERS_APP_V
684: WHERE MR_HEADER_ID=C_MR_HEADER_ID
685: AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);
686:
687: CURSOR get_mrItemId(c_billing_item VARCHAR2)

Line 982: from AHL_MR_HEADERS_APP_V

978: IF p_x_mr_header_rec.version_number=FND_API.G_MISS_NUM OR
979: p_x_mr_header_rec.version_number IS NULL
980: THEN
981: select version_number into p_x_mr_header_rec.version_number
982: from AHL_MR_HEADERS_APP_V
983: where mr_header_id=p_x_mr_header_rec.mr_header_id;
984: END IF;
985:
986: END IF;

Line 1056: SELECT * FROM AHL_MR_HEADERS_APP_V

1052: )
1053: as
1054: Cursor GetMrdet(C_MR_HEADER_ID NUMBER)
1055: IS
1056: SELECT * FROM AHL_MR_HEADERS_APP_V
1057: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
1058: l_mr_rec GetMrdet%rowtype;
1059: l_counter NUMBER:=0;
1060: BEGIN

Line 1169: FROM AHL_MR_HEADERS_APP_V

1165:
1166: CURSOR get_mr_title(c_mr_header_id number)
1167: IS
1168: SELECT title,object_version_number
1169: FROM AHL_MR_HEADERS_APP_V
1170: WHERE mr_header_id= c_mr_header_id;
1171:
1172: CURSOR
1173: check_prog_subtype(C_PROGRAM_TYPE_CODE VARCHAR2,C_PROGRAM_SUBTYPE_CODE VARCHAR2)

Line 1239: FROM AHL_MR_HEADERS_APP_V

1235: TITLE,
1236: VERSION_NUMBER,
1237: MR_STATUS_CODE,
1238: EFFECTIVE_FROM
1239: FROM AHL_MR_HEADERS_APP_V
1240: WHERE MR_HEADER_ID=C_MR_HEADER_ID
1241: AND object_version_number=p_mr_header_rec.object_Version_number;
1242:
1243: l_mr_rec GetHeaderInfo%ROWTYPE;

Line 1249: FROM AHL_MR_HEADERS_APP_V

1245:
1246: Cursor GetHeaderInfo1(C_TITLE VARCHAR2,C_VERSION_NUMBER NUMBER)
1247: IS
1248: SELECT MR_HEADER_ID,TITLE,VERSION_NUMBER,MR_STATUS_CODE,EFFECTIVE_FROM
1249: FROM AHL_MR_HEADERS_APP_V
1250: WHERE upper(TITLE)=upper(C_TITLE)
1251: and version_number=c_version_number-1;
1252:
1253: l_mr_rec1 GetHeaderInfo1%ROWTYPE;

Line 1804: FROM AHL_MR_HEADERS_APP_V

1800:
1801: -- Title Should not Repeat in Create mode
1802:
1803: SELECT COUNT(*) INTO l_title_counter
1804: FROM AHL_MR_HEADERS_APP_V
1805: WHERE upper(ltrim(rtrim(TITLE)))=upper(ltrim(rtrim(l_mr_header_rec.title)));
1806: IF l_title_counter >0 then
1807: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TITLE_INVALID');
1808: FND_MSG_PUB.ADD;