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_RELATION_PVT dependencies on AHL_MR_HEADERS_B

Line 185: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;

181: AND NVL(TYPE_CODE,'X')=DECODE(NVL(C_TYPE_CODE,'X'),'ACTIVITY','PROGRAM','PROGRAM','ACTIVITY','X');
182:
183:
184: check_flag VARCHAR2(1):='N';
185: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
186: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
187: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
188: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
189: BEGIN

Line 187: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;

183:
184: check_flag VARCHAR2(1):='N';
185: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
186: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
187: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
188: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
189: BEGIN
190: x_return_status:=FND_API.G_RET_STS_SUCCESS;
191:

Line 188: l_title AHL_MR_HEADERS_B.TITLE%TYPE;

184: check_flag VARCHAR2(1):='N';
185: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
186: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
187: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
188: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
189: BEGIN
190: x_return_status:=FND_API.G_RET_STS_SUCCESS;
191:
192: IF G_DEBUG='Y' THEN

Line 200: FROM AHL_MR_HEADERS_B

196:
197: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM
198: THEN
199: SELECT TYPE_CODE INTO L_TYPE_CODE
200: FROM AHL_MR_HEADERS_B
201: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
202: END IF;
203:
204: IF p_x_mr_relation_rec.RELATED_MR_TITLE IS NULL OR p_x_mr_relation_rec.RELATED_MR_TITLE=FND_API.G_MISS_CHAR

Line 232: FROM AHL_MR_HEADERS_B

228:
229: IF title_to_relmr_header_id%NOTFOUND
230: THEN
231: SELECT TITLE INTO l_title
232: FROM AHL_MR_HEADERS_B
233: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
234:
235: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATED_TITLE_INVAL');
236: FND_MESSAGE.SET_TOKEN('FIELD',l_title,false);

Line 314: FROM AHL_MR_HEADERS_B

310: as
311: CURSOR Check_mr_header_stat(C_MR_HEADER_ID IN NUMBER)
312: IS
313: SELECT MR_STATUS_CODE,TITLE,TYPE_CODE
314: FROM AHL_MR_HEADERS_B
315: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
316:
317: l_head_rec Check_mr_header_stat%rowtype;
318: l_rel_head_rec Check_mr_header_stat%rowtype;

Line 319: L_TITLE AHL_MR_HEADERS_B.TITLE%type;

315: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
316:
317: l_head_rec Check_mr_header_stat%rowtype;
318: l_rel_head_rec Check_mr_header_stat%rowtype;
319: L_TITLE AHL_MR_HEADERS_B.TITLE%type;
320: L_MR_TITLE AHL_MR_HEADERS_B.TITLE%type;
321: l_counter number;
322:
323: CURSOR CHECK_UNIQ(c_mr_header_id NUMBER,c_related_mr_header_id NUMBER,c_relationship_code VARCHAR2)

Line 320: L_MR_TITLE AHL_MR_HEADERS_B.TITLE%type;

316:
317: l_head_rec Check_mr_header_stat%rowtype;
318: l_rel_head_rec Check_mr_header_stat%rowtype;
319: L_TITLE AHL_MR_HEADERS_B.TITLE%type;
320: L_MR_TITLE AHL_MR_HEADERS_B.TITLE%type;
321: l_counter number;
322:
323: CURSOR CHECK_UNIQ(c_mr_header_id NUMBER,c_related_mr_header_id NUMBER,c_relationship_code VARCHAR2)
324: IS

Line 344: FROM AHL_MR_HEADERS_B

340:
341: CURSOR Check_Unplanned_MR(c_related_mr_header_id NUMBER)
342: IS
343: SELECT TITLE
344: FROM AHL_MR_HEADERS_B
345: WHERE MR_HEADER_ID=C_RELATED_MR_HEADER_ID
346: AND IMPLEMENT_STATUS_CODE = 'OPTIONAL_DO_NOT_IMPLEMENT';
347:
348:

Line 388: FROM ahl_mr_headers_b

384: c_mr_header_id number
385: )
386: IS
387: SELECT 'x'
388: FROM ahl_mr_headers_b
389: WHERE mr_header_id = c_mr_header_id AND
390: program_type_code = 'MO_PROC';
391:
392: l_dummy_char VARCHAR2(1);

Line 399: FROM ahl_mr_headers_b

395: --sukhwsin::Complex Assembly Maintenance Changes - starts
396: --Cursor to get Implementation status code for MR
397: CURSOR get_mr_impl_status(c_mr_header_id NUMBER) IS
398: SELECT implement_status_code, title, version_number
399: FROM ahl_mr_headers_b
400: WHERE mr_header_id = c_mr_header_id;
401: --Local Variable Declation for Complex Assembly Changes
402: l_mr_version_number ahl_mr_headers_b.version_number%TYPE;
403: l_implement_sts_code ahl_mr_headers_b.implement_status_code%TYPE;

Line 402: l_mr_version_number ahl_mr_headers_b.version_number%TYPE;

398: SELECT implement_status_code, title, version_number
399: FROM ahl_mr_headers_b
400: WHERE mr_header_id = c_mr_header_id;
401: --Local Variable Declation for Complex Assembly Changes
402: l_mr_version_number ahl_mr_headers_b.version_number%TYPE;
403: l_implement_sts_code ahl_mr_headers_b.implement_status_code%TYPE;
404: --sukhwsin::Complex Assembly Maintenance Changes - ends
405: l_object_version_number number;
406: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_MR_RELATION';

Line 403: l_implement_sts_code ahl_mr_headers_b.implement_status_code%TYPE;

399: FROM ahl_mr_headers_b
400: WHERE mr_header_id = c_mr_header_id;
401: --Local Variable Declation for Complex Assembly Changes
402: l_mr_version_number ahl_mr_headers_b.version_number%TYPE;
403: l_implement_sts_code ahl_mr_headers_b.implement_status_code%TYPE;
404: --sukhwsin::Complex Assembly Maintenance Changes - ends
405: l_object_version_number number;
406: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_MR_RELATION';
407: l_mr_header_id NUMBER:=0;

Line 550: select TITLE into l_mr_title from AHL_MR_HEADERS_B where mr_header_id = p_mr_relation_rec.mr_header_id;

546: l_result := AHL_MR_LOOP_CHAIN_RELNS_PVT.IS_MR_IN_LOOP_OR_CHAIN(p_mr_relation_rec.mr_header_id);
547: l_result1 := AHL_MR_LOOP_CHAIN_RELNS_PVT.IS_MR_IN_LOOP_OR_CHAIN(p_mr_relation_rec.related_mr_header_id);
548: IF l_result IN ('LOOP','CHAIN') OR l_result1 IN ('LOOP','CHAIN') THEN
549: IF l_result IN ('LOOP','CHAIN') THEN
550: select TITLE into l_mr_title from AHL_MR_HEADERS_B where mr_header_id = p_mr_relation_rec.mr_header_id;
551: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_LOOP_OR_CHAIN');
552: FND_MESSAGE.SET_TOKEN('RECORD', l_mr_title, false);
553: FND_MSG_PUB.ADD;
554:

Line 581: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

577: OPEN CHECK_ACCOM_TRIGGER(p_mr_relation_rec.mr_header_id);
578: FETCH CHECK_ACCOM_TRIGGER into l_rel_rec;
579:
580: IF CHECK_ACCOM_TRIGGER%FOUND THEN
581: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;
582: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ACCOM_TRIGGER');
583: FND_MESSAGE.SET_TOKEN('TITLE', l_mr_title, false);
584: FND_MSG_PUB.ADD;
585: END IF;

Line 698: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

694:
695: l_result := AHL_MR_LOOP_CHAIN_RELNS_PVT.IS_MR_IN_LOOP_OR_CHAIN(p_mr_relation_rec.mr_header_id);
696: l_result1 := AHL_MR_LOOP_CHAIN_RELNS_PVT.IS_MR_IN_LOOP_OR_CHAIN(p_mr_relation_rec.related_mr_header_id);
697:
698: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;
699: l_title := p_mr_relation_rec.RELATED_MR_TITLE;
700:
701:
702: IF l_result = 'LOOP' OR l_result1 ='LOOP' THEN

Line 782: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

778: OPEN CHECK_GROUP_MR(p_mr_relation_rec.mr_header_id);
779: FETCH CHECK_GROUP_MR into l_rel_rec;
780:
781: IF CHECK_GROUP_MR%FOUND THEN
782: select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;
783: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_GROUP_MR');
784: FND_MESSAGE.SET_TOKEN('TITLE', l_mr_title, false);
785: FND_MSG_PUB.ADD;
786: END IF;

Line 855: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;

851: l_msg_data VARCHAR2(2000);
852: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
853: l_mr_header_id NUMBER:=0;
854: l_mr_relation_rec MR_RELATION_REC;
855: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
856: BEGIN
857:
858:
859: SAVEPOINT PROCESS_MR_RELATION;