APPS.AHL_FMP_PROGTYPE_SUBTYPE_PVT dependencies on AHL_PROG_TYPE_SUBTYPES

Line 13: SELECT * FROM AHL_PROG_TYPE_SUBTYPES

9: (p_x_prog_type_subtype_tbl IN OUT NOCOPY AHL_FMP_PROGTYPE_SUBTYPE_PVT.p_x_prog_type_subtype_tbl)
10: AS
11: Cursor CurGetProgTypeDet(C_PROG_TYPE_SUBTYPE_ID NUMBER)
12: IS
13: SELECT * FROM AHL_PROG_TYPE_SUBTYPES
14: WHERE PROG_TYPE_SUBTYPE_ID=C_PROG_TYPE_SUBTYPE_ID;
15: l_prog_subtype_rec CurGetProgTypeDet%rowtype;
16: BEGIN
17: IF p_x_prog_type_subtype_tbl.count >0

Line 283: FROM AHL_PROG_TYPE_SUBTYPES

279:
280: CURSOR check_prog_subtype(C_PROGRAM_TYPE_CODE VARCHAR2,C_PROGRAM_SUBTYPE_CODE VARCHAR2)
281: IS
282: SELECT count(*)
283: FROM AHL_PROG_TYPE_SUBTYPES
284: WHERE
285: UPPER(PROGRAM_TYPE_CODE)=UPPER(C_PROGRAM_TYPE_CODE) AND
286: UPPER(PROGRAM_SUBTYPE_CODE)=UPPER(C_PROGRAM_SUBTYPE_CODE);
287:

Line 425: FROM AHL_PROG_TYPE_SUBTYPES

421: --pdoki commented for bug 6892047
422: /*CURSOR check_prog_subtype(C_PROGRAM_TYPE_CODE VARCHAR2,C_PROGRAM_SUBTYPE_CODE VARCHAR2)
423: IS
424: SELECT count(*)
425: FROM AHL_PROG_TYPE_SUBTYPES
426: WHERE
427: UPPER(PROGRAM_TYPE_CODE)=UPPER(C_PROGRAM_TYPE_CODE) AND
428: UPPER(PROGRAM_SUBTYPE_CODE)=UPPER(C_PROGRAM_SUBTYPE_CODE);*/
429:

Line 487: FROM AHL_PROG_TYPE_SUBTYPES

483: l_cnt_mrs_subtype :=0;
484: SELECT COUNT(MR_HEADER_ID) INTO l_cnt_mrs_subtype
485: FROM AHL_MR_HEADERS_B
486: WHERE PROGRAM_TYPE_CODE = (SELECT PROGRAM_TYPE_CODE
487: FROM AHL_PROG_TYPE_SUBTYPES
488: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)
489: AND PROGRAM_SUBTYPE_CODE = (SELECT PROGRAM_SUBTYPE_CODE
490: FROM AHL_PROG_TYPE_SUBTYPES
491: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)

Line 490: FROM AHL_PROG_TYPE_SUBTYPES

486: WHERE PROGRAM_TYPE_CODE = (SELECT PROGRAM_TYPE_CODE
487: FROM AHL_PROG_TYPE_SUBTYPES
488: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)
489: AND PROGRAM_SUBTYPE_CODE = (SELECT PROGRAM_SUBTYPE_CODE
490: FROM AHL_PROG_TYPE_SUBTYPES
491: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)
492: AND TRUNC(NVL(EFFECTIVE_TO,SYSDATE + 1)) > TRUNC(SYSDATE);
493: if l_cnt_mrs_subtype > 0 then
494: SELECT PROGRAM_SUBTYPE_CODE into l_prog_sub_type

Line 495: FROM AHL_PROG_TYPE_SUBTYPES

491: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID)
492: AND TRUNC(NVL(EFFECTIVE_TO,SYSDATE + 1)) > TRUNC(SYSDATE);
493: if l_cnt_mrs_subtype > 0 then
494: SELECT PROGRAM_SUBTYPE_CODE into l_prog_sub_type
495: FROM AHL_PROG_TYPE_SUBTYPES
496: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID;
497:
498: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_DEL_SUBTYP_MR');
499: FND_MESSAGE.SET_TOKEN('RECORD',l_prog_sub_type,false);

Line 659: DELETE from AHL_PROG_TYPE_SUBTYPES

655: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: END IF;
657:
658: if p_x_prog_type_subtype_tabl(i).DML_operation='D' then
659: DELETE from AHL_PROG_TYPE_SUBTYPES
660: where PROG_TYPE_SUBTYPE_ID =p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID
661: and OBJECT_VERSION_NUMBER=p_x_prog_type_subtype_tabl(i).OBJECT_VERSION_NUMBER;
662:
663: if sql%rowcount=0 then

Line 671: AHL_PROG_TYPE_SUBTYPES_PKG.UPDATE_ROW (

667: elsif p_x_prog_type_subtype_tabl(i).DML_operation='U' then
668: IF x_return_status=FND_API.G_RET_STS_SUCCESS
669: THEN
670:
671: AHL_PROG_TYPE_SUBTYPES_PKG.UPDATE_ROW (
672: X_PROG_TYPE_SUBTYPE_ID =>p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID,
673: X_OBJECT_VERSION_NUMBER =>p_x_prog_type_subtype_tabl(i).object_version_number,
674: X_PROGRAM_TYPE_CODE =>p_x_prog_type_subtype_tabl(i).PROGRAM_TYPE_CODE,
675: X_PROGRAM_SUBTYPE_CODE =>p_x_prog_type_subtype_tabl(i).PROGRAM_SUBTYPE_CODE,

Line 702: select AHL_PROG_TYPE_SUBTYPES_S.nextval

698: IF x_return_status=FND_API.G_RET_STS_SUCCESS
699: THEN
700:
701:
702: select AHL_PROG_TYPE_SUBTYPES_S.nextval
703: into p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID
704: from dual;
705:
706: AHL_PROG_TYPE_SUBTYPES_PKG.INSERT_ROW (

Line 706: AHL_PROG_TYPE_SUBTYPES_PKG.INSERT_ROW (

702: select AHL_PROG_TYPE_SUBTYPES_S.nextval
703: into p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID
704: from dual;
705:
706: AHL_PROG_TYPE_SUBTYPES_PKG.INSERT_ROW (
707: X_PROG_TYPE_SUBTYPE_ID =>p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID,
708: X_OBJECT_VERSION_NUMBER =>1,
709: X_PROGRAM_TYPE_CODE =>p_x_prog_type_subtype_tabl(i).PROGRAM_TYPE_CODE,
710: X_PROGRAM_SUBTYPE_CODE =>p_x_prog_type_subtype_tabl(i).PROGRAM_SUBTYPE_CODE,