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 1622: UPDATE AHL_MR_HEADERS_B

1618: END IF;
1619:
1620: IF l_ACTIVE='Y'
1621: THEN
1622: UPDATE AHL_MR_HEADERS_B
1623: SET MR_STATUS_CODE=l_upd_mr_status_code,
1624: OBJECT_VERSION_number=object_version_number+1
1625: WHERE MR_HEADER_ID=p_source_mr_header_id
1626: And OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1651: UPDATE AHL_MR_HEADERS_B

1647: p_application_usg_code =>G_APPLN_USAGE
1648: );
1649: END IF;
1650: ELSE
1651: UPDATE AHL_MR_HEADERS_B
1652: SET MR_STATUS_CODE=L_UPD_MR_STATUS_CODE,
1653: OBJECT_VERSION_number=OBJECT_VERSION_number+1
1654: WHERE MR_HEADER_ID=p_source_mr_header_id
1655: AND OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1762: FROM AHL_MR_HEADERS_B

1758: EFFECTIVE_FROM,
1759: TITLE,
1760: MR_STATUS_CODE,
1761: APPLICATION_USG_CODE
1762: FROM AHL_MR_HEADERS_B
1763: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
1764:
1765: CURSOR GetPrevMR_headerid(C_VERSION_NUMBER NUMBER,C_TITLE VARCHAR2,C_APP_CODE VARCHAR2)
1766: IS

Line 1772: FROM AHL_MR_HEADERS_B

1768: VERSION_NUMBER,
1769: EFFECTIVE_FROM,
1770: TITLE,
1771: MR_STATUS_CODE
1772: FROM AHL_MR_HEADERS_B
1773: WHERE TITLE=C_TITLE
1774: AND VERSION_NUMBER=C_VERSION_NUMBER-1
1775: AND APPLICATION_USG_CODE=C_APP_CODE;
1776:

Line 1840: UPDATE AHL_MR_HEADERS_B

1836: THEN
1837: l_status:='COMPLETE';
1838: END IF;
1839: l_check_flag3:='N';
1840: UPDATE AHL_MR_HEADERS_B
1841: SET MR_STATUS_CODE=DECODE(MR_STATUS_CODE,'APPROVAL_PENDING','APPROVAL_REJECTED','TERMINATE_PENDING','COMPLETE')
1842: WHERE MR_HEADER_ID=P_MR_HEADER_ID;
1843: END IF;
1844:

Line 1861: UPDATE AHL_MR_HEADERS_B

1857: IF l_check_flag='Y' and l_mr_rec.version_number=1
1858: THEN
1859: IF l_mr_rec.MR_STATUS_CODE='APPROVAL_PENDING'
1860: THEN
1861: UPDATE AHL_MR_HEADERS_B
1862: SET MR_STATUS_CODE=l_status,
1863: EFFECTIVE_FROM=L_FR_DATE,
1864: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1865: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 1868: UPDATE AHL_MR_HEADERS_B

1864: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1865: WHERE MR_HEADER_ID=P_MR_HEADER_ID;
1866: ELSIF l_mr_rec.MR_STATUS_CODE='TERMINATE_PENDING'
1867: THEN
1868: UPDATE AHL_MR_HEADERS_B
1869: SET MR_STATUS_CODE=l_status,
1870: EFFECTIVE_TO=nvl(EFFECTIVE_TO,L_TO_DATE),
1871: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1872: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 1941: UPDATE AHL_MR_HEADERS_B

1937: THEN
1938:
1939: IF l_mr_rec.MR_STATUS_CODE='APPROVAL_PENDING'
1940: THEN
1941: UPDATE AHL_MR_HEADERS_B
1942: SET MR_STATUS_CODE=l_status,
1943: EFFECTIVE_FROM=L_FR_DATE,
1944: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1945: WHERE MR_HEADER_ID=P_MR_HEADER_ID;

Line 1947: UPDATE AHL_MR_HEADERS_B

1943: EFFECTIVE_FROM=L_FR_DATE,
1944: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1945: WHERE MR_HEADER_ID=P_MR_HEADER_ID;
1946:
1947: UPDATE AHL_MR_HEADERS_B
1948: SET EFFECTIVE_TO=L_TO_DATE,
1949: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1950: WHERE MR_HEADER_ID=l_prev_mr_rec.MR_HEADER_ID;
1951:

Line 1995: UPDATE AHL_MR_HEADERS_B

1991: */
1992:
1993: ELSIF l_mr_rec.MR_STATUS_CODE='TERMINATE_PENDING'
1994: THEN
1995: UPDATE AHL_MR_HEADERS_B
1996: SET MR_STATUS_CODE=l_status,
1997: EFFECTIVE_TO=NVL(EFFECTIVE_TO,l_to_date),
1998: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1999: WHERE MR_HEADER_ID=P_MR_HEADER_ID;