APPS.AHL_FMP_MR_APPROVAL_PVT dependencies on AHL_MR_HEADERS_B

Line 35: from ahl_mr_headers_b

31: title,
32: effective_from,
33: Version_number,
34: mr_status_code
35: from ahl_mr_headers_b
36: where mr_header_id=c_mr_header_id;
37: l_mr_rec GetMrHeaderDet%rowtype;
38: BEGIN
39: IF G_DEBUG='Y' THEN

Line 335: from ahl_mr_headers_b

331: title,
332: effective_from,
333: effective_to,
334: Version_number
335: from ahl_mr_headers_b
336: where mr_header_id=c_mr_header_id;
337: l_mr_header_rec GetMrHeaderDet%rowtype;
338: BEGIN
339: IF G_DEBUG='Y' THEN

Line 463: from ahl_mr_headers_b

459:
460: cursor GetMrHeaderDet(c_mr_header_id number)
461: is
462: select mr_header_id,title,effective_from,VERSION_NUMBER
463: from ahl_mr_headers_b
464: where mr_header_id=c_mr_header_id;
465:
466: l_mr_header_rec GetMrHeaderDet%rowtype;
467:

Line 583: from ahl_mr_headers_b

579:
580: cursor GetMrHeaderDet(c_mr_header_id number)
581: is
582: select mr_header_id,title,effective_from,version_number
583: from ahl_mr_headers_b
584: where mr_header_id=c_mr_header_id;
585:
586: l_mr_header_rec GetMrHeaderDet%rowtype;
587:

Line 709: from ahl_mr_headers_b

705: l_error_msg VARCHAR2(2000);
706: cursor GetMrHeaderDet(c_mr_header_id number)
707: is
708: select mr_header_id,title,effective_from,VERSION_NUMBER
709: from ahl_mr_headers_b
710: where mr_header_id=c_mr_header_id;
711: l_mr_header_rec GetMrHeaderDet%rowtype;
712: BEGIN
713: IF G_DEBUG='Y' THEN

Line 834: from ahl_mr_headers_b

830: l_error_msg VARCHAR2(2000);
831: cursor GetMrHeaderDet(c_mr_header_id number)
832: is
833: select mr_header_id,title,effective_from,version_number
834: from ahl_mr_headers_b
835: where mr_header_id=c_mr_header_id;
836: l_mr_header_rec GetMrHeaderDet%rowtype;
837: BEGIN
838:

Line 960: from ahl_mr_headers_b

956: l_subject VARCHAR2(500);
957: cursor GetMrHeaderDet(c_mr_header_id number)
958: is
959: select mr_header_id,title,effective_from,version_number
960: from ahl_mr_headers_b
961: where mr_header_id=c_mr_header_id;
962: l_mr_header_rec GetMrHeaderDet%rowtype;
963: BEGIN
964: IF G_DEBUG='Y' THEN

Line 1082: from ahl_mr_headers_b

1078: l_subject VARCHAR2(500);
1079: cursor GetMrHeaderDet(c_mr_header_id number)
1080: is
1081: select mr_header_id,title,effective_from,VERSION_NUMBER
1082: from ahl_mr_headers_b
1083: where mr_header_id=c_mr_header_id;
1084: l_mr_header_rec GetMrHeaderDet%rowtype;
1085: BEGIN
1086: IF G_DEBUG='Y' THEN

Line 1370: from ahl_mr_headers_b

1366: l_subject VARCHAR2(500);
1367: cursor GetMrHeaderDet(c_mr_header_id number)
1368: is
1369: select mr_header_id,title,effective_from
1370: from ahl_mr_headers_b
1371: where mr_header_id=c_mr_header_id;
1372:
1373: l_mr_header_rec GetMrHeaderDet%rowtype;
1374: l_return_status VARCHAR2(1);

Line 1405: UPDATE AHL_MR_HEADERS_B

1401: l_status_date := SYSDATE;
1402: -- Update approval object table as following
1403: -- FMPMR Code
1404:
1405: UPDATE AHL_MR_HEADERS_B
1406: SET MR_STATUS_CODE = 'DRAFT',
1407: object_version_number =l_object_version_number+1
1408: WHERE mr_header_id = l_object_id
1409: and object_Version_number=l_object_version_number;