eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_HEADERS_B

Line 48: l_appln_code AHL_MR_HEADERS_B.APPLICATION_USG_CODE%TYPE;

44: And mr_header_id >C_MR_HEADER_ID
45: And version_number>C_VERSION_NUMBER;
46:
47: l_status VARCHAR2(30);
48: l_appln_code AHL_MR_HEADERS_B.APPLICATION_USG_CODE%TYPE;
49: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
50: l_version_number NUMBER:=0;
51: l_counter NUMBER:=0;
52: l_check_flag VARCHAR2(1):='N';

Line 49: l_title AHL_MR_HEADERS_B.TITLE%TYPE;

45: And version_number>C_VERSION_NUMBER;
46:
47: l_status VARCHAR2(30);
48: l_appln_code AHL_MR_HEADERS_B.APPLICATION_USG_CODE%TYPE;
49: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
50: l_version_number NUMBER:=0;
51: l_counter NUMBER:=0;
52: l_check_flag VARCHAR2(1):='N';
53: BEGIN

Line 184: l_program_type_code AHL_MR_HEADERS_B.program_type_code%type;

180: select mr_header_id
181: from AHL_MR_HEADERS_APP_V
182: where mr_header_id=p_source_mr_header_id;
183:
184: l_program_type_code AHL_MR_HEADERS_B.program_type_code%type;
185: CURSOR CurGetHeaderdet
186: Is
187: SELECT
188: MR_HEADER_ID,

Line 670: ahl_mr_headers_b mr

666: rel.ATTRIBUTE13,
667: rel.ATTRIBUTE14,
668: rel.ATTRIBUTE15
669: FROM ahl_mr_loop_chain_relns rel,
670: ahl_mr_headers_b mr
671: WHERE mr.mr_header_id = rel.mr_header_id
672: AND rel.mr_relationship_id IN
673: (
674: SELECT rel.MR_RELATIONSHIP_ID

Line 717: ahl_mr_headers_b mr

713: rel.ATTRIBUTE13,
714: rel.ATTRIBUTE14,
715: rel.ATTRIBUTE15
716: FROM ahl_mr_loop_chain_relns rel,
717: ahl_mr_headers_b mr
718: WHERE mr.mr_header_id = rel.mr_header_id
719: AND rel.mr_relationship_id IN
720: (SELECT mr_relationship_id
721: FROM ahl_mr_loop_chain_relns

Line 1478: from ahl_mr_headers_b

1474: -- pdoki added for SBE Project, Start.
1475: -- Copies the SB rules from a source MR (original) to destination MR (revised).
1476: select PROGRAM_TYPE_CODE
1477: into l_program_type_code
1478: from ahl_mr_headers_b
1479: where mr_header_id = p_source_mr_header_id;
1480:
1481: IF l_program_type_code = 'SERV_BLTN' THEN
1482:

Line 2016: UPDATE AHL_MR_HEADERS_B

2012: END IF;
2013:
2014: IF l_ACTIVE='Y'
2015: THEN
2016: UPDATE AHL_MR_HEADERS_B
2017: SET MR_STATUS_CODE=l_upd_mr_status_code,
2018: OBJECT_VERSION_number=object_version_number+1
2019: WHERE MR_HEADER_ID=p_source_mr_header_id
2020: And OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 2045: UPDATE AHL_MR_HEADERS_B

2041: p_application_usg_code =>G_APPLN_USAGE
2042: );
2043: END IF;
2044: ELSE
2045: UPDATE AHL_MR_HEADERS_B
2046: SET MR_STATUS_CODE=L_UPD_MR_STATUS_CODE,
2047: OBJECT_VERSION_number=OBJECT_VERSION_number+1
2048: WHERE MR_HEADER_ID=p_source_mr_header_id
2049: AND OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 2156: FROM AHL_MR_HEADERS_B

2152: EFFECTIVE_FROM,
2153: TITLE,
2154: MR_STATUS_CODE,
2155: APPLICATION_USG_CODE
2156: FROM AHL_MR_HEADERS_B
2157: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
2158:
2159: CURSOR GetPrevMR_headerid(C_VERSION_NUMBER NUMBER,C_TITLE VARCHAR2,C_APP_CODE VARCHAR2)
2160: IS

Line 2166: FROM AHL_MR_HEADERS_B

2162: VERSION_NUMBER,
2163: EFFECTIVE_FROM,
2164: TITLE,
2165: MR_STATUS_CODE
2166: FROM AHL_MR_HEADERS_B
2167: WHERE TITLE=C_TITLE
2168: AND VERSION_NUMBER=C_VERSION_NUMBER-1
2169: AND APPLICATION_USG_CODE=C_APP_CODE;
2170:

Line 2263: UPDATE AHL_MR_HEADERS_B

2259: THEN
2260: l_status:='COMPLETE';
2261: END IF;
2262: l_check_flag3:='N';
2263: UPDATE AHL_MR_HEADERS_B
2264: SET MR_STATUS_CODE=DECODE(MR_STATUS_CODE,'APPROVAL_PENDING','APPROVAL_REJECTED','TERMINATE_PENDING','COMPLETE')
2265: WHERE MR_HEADER_ID=P_MR_HEADER_ID;
2266: END IF;
2267:

Line 2284: UPDATE AHL_MR_HEADERS_B

2280: IF l_check_flag='Y' and l_mr_rec.version_number=1
2281: THEN
2282: IF l_mr_rec.MR_STATUS_CODE='APPROVAL_PENDING'
2283: THEN
2284: UPDATE AHL_MR_HEADERS_B
2285: SET MR_STATUS_CODE=l_status,
2286: EFFECTIVE_FROM=L_FR_DATE,
2287: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2288: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 2319: UPDATE AHL_MR_HEADERS_B

2315: -- End of changes by SURRKUMA for Bug 13959709 on 14-MAY-12
2316:
2317: ELSIF l_mr_rec.MR_STATUS_CODE='TERMINATE_PENDING'
2318: THEN
2319: UPDATE AHL_MR_HEADERS_B
2320: SET MR_STATUS_CODE=l_status,
2321: EFFECTIVE_TO=nvl(EFFECTIVE_TO,L_TO_DATE),
2322: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2323: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 2392: UPDATE AHL_MR_HEADERS_B

2388: THEN
2389:
2390: IF l_mr_rec.MR_STATUS_CODE='APPROVAL_PENDING'
2391: THEN
2392: UPDATE AHL_MR_HEADERS_B
2393: SET MR_STATUS_CODE=l_status,
2394: EFFECTIVE_FROM=L_FR_DATE,
2395: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2396: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 2398: UPDATE AHL_MR_HEADERS_B

2394: EFFECTIVE_FROM=L_FR_DATE,
2395: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2396: WHERE MR_HEADER_ID=P_MR_HEADER_ID;
2397:
2398: UPDATE AHL_MR_HEADERS_B
2399: SET EFFECTIVE_TO=L_TO_DATE,
2400: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2401: WHERE MR_HEADER_ID=l_prev_mr_rec.MR_HEADER_ID;
2402:

Line 2506: UPDATE AHL_MR_HEADERS_B

2502: -- pdoki added for SBE Project, End.
2503:
2504: ELSIF l_mr_rec.MR_STATUS_CODE='TERMINATE_PENDING'
2505: THEN
2506: UPDATE AHL_MR_HEADERS_B
2507: SET MR_STATUS_CODE=l_status,
2508: EFFECTIVE_TO=NVL(EFFECTIVE_TO,l_to_date),
2509: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
2510: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 2537: UPDATE AHL_MR_HEADERS_B

2533: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
2534: THEN
2535:
2536: IF(TRUNC(NVL(l_to_date,SYSDATE)) > TRUNC(SYSDATE) )THEN
2537: UPDATE AHL_MR_HEADERS_B
2538: SET TERMINATION_REQUIRED_FLAG = 'Y'
2539: WHERE MR_HEADER_ID=l_prev_mr_rec.MR_HEADER_ID;
2540:
2541: AHL_UMP_UNITMAINT_PUB.Terminate_MR_Instances(