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 462: from ahl_mr_headers_b

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

Line 582: from ahl_mr_headers_b

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

Line 708: from ahl_mr_headers_b

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

Line 833: from ahl_mr_headers_b

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

Line 959: from ahl_mr_headers_b

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

Line 1081: from ahl_mr_headers_b

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

Line 1369: from ahl_mr_headers_b

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

Line 1404: UPDATE AHL_MR_HEADERS_B

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