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_PRD_PRINT_PVT dependencies on AHL_ENIGMA_JCG_DETAILS

Line 1433: Select OBJECT_VERSION_NUMBER,OBJECT_TYPE_CODE,OBJECT_ID from AHL_ENIGMA_JCG_DETAILS

1429: IS
1430:
1431: Cursor get_jcg_req_rec_csr(c_jcg_id NUMBER)
1432: IS
1433: Select OBJECT_VERSION_NUMBER,OBJECT_TYPE_CODE,OBJECT_ID from AHL_ENIGMA_JCG_DETAILS
1434: Where JCG_REQUEST_ID = c_jcg_id
1435: FOR UPDATE of STATUS_CODE;
1436:
1437: Cursor jcg_req_exists_csr(c_jcg_id NUMBER)

Line 1439: Select OBJECT_VERSION_NUMBER,OBJECT_TYPE_CODE,OBJECT_ID from AHL_ENIGMA_JCG_DETAILS

1435: FOR UPDATE of STATUS_CODE;
1436:
1437: Cursor jcg_req_exists_csr(c_jcg_id NUMBER)
1438: IS
1439: Select OBJECT_VERSION_NUMBER,OBJECT_TYPE_CODE,OBJECT_ID from AHL_ENIGMA_JCG_DETAILS
1440: where jcg_request_id = c_jcg_id
1441: FOR UPDATE of STATUS_CODE;
1442:
1443: Cursor get_other_jcg_req_id_csr(c_object_type VARCHAR2, c_object_id NUMBER, c_jcg_id NUMBER)

Line 1445: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS

1441: FOR UPDATE of STATUS_CODE;
1442:
1443: Cursor get_other_jcg_req_id_csr(c_object_type VARCHAR2, c_object_id NUMBER, c_jcg_id NUMBER)
1444: IS
1445: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1446: Where OBJECT_TYPE_CODE = c_object_type
1447: AND OBJECT_ID = c_object_id
1448: AND JCG_REQUEST_ID < c_jcg_id ;
1449:

Line 1452: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS

1448: AND JCG_REQUEST_ID < c_jcg_id ;
1449:
1450: Cursor get_other_jcg_non_s_csr(c_object_type VARCHAR2, c_object_id NUMBER, c_jcg_id NUMBER)
1451: IS
1452: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1453: Where OBJECT_TYPE_CODE = c_object_type
1454: AND OBJECT_ID = c_object_id
1455: AND STATUS_CODE IN ('E','P')
1456: AND JCG_REQUEST_ID < c_jcg_id ;

Line 1578: 'Before inserting a new row in AHL_ENIGMA_JCG_DETAILS.'

1574: IF (l_log_statement >= l_log_current_level)THEN
1575: fnd_log.string(
1576: l_log_statement,
1577: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1578: 'Before inserting a new row in AHL_ENIGMA_JCG_DETAILS.'
1579: );
1580: END IF;
1581:
1582: INSERT INTO AHL_ENIGMA_JCG_DETAILS ( JCG_REQUEST_ID,

Line 1582: INSERT INTO AHL_ENIGMA_JCG_DETAILS ( JCG_REQUEST_ID,

1578: 'Before inserting a new row in AHL_ENIGMA_JCG_DETAILS.'
1579: );
1580: END IF;
1581:
1582: INSERT INTO AHL_ENIGMA_JCG_DETAILS ( JCG_REQUEST_ID,
1583: OBJECT_TYPE_CODE,
1584: OBJECT_ID,
1585: STATUS_CODE,
1586: FILE_LOCATION,

Line 1599: VALUES (AHL_ENIGMA_JCG_DETAILS_S.NEXTVAL,

1595: CREATED_BY,
1596: LAST_UPDATE_LOGIN,
1597: SECURITY_GROUP_ID
1598: )
1599: VALUES (AHL_ENIGMA_JCG_DETAILS_S.NEXTVAL,
1600: p_object_type,
1601: p_object_id,
1602: p_status_code,
1603: p_file_location,

Line 1624: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;

1620: LOOP
1621: OPEN jcg_req_exists_csr (jcg_rec.jcg_request_id);
1622: FETCH jcg_req_exists_csr INTO l_ovn,l_object_type,l_object_id;
1623: IF(jcg_req_exists_csr%found)THEN
1624: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;
1625: END IF;
1626: CLOSE jcg_req_exists_csr;
1627: END LOOP;
1628: END IF;

Line 1636: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;

1632: LOOP
1633: OPEN jcg_req_exists_csr (jcg_rec.jcg_request_id);
1634: FETCH jcg_req_exists_csr INTO l_ovn,l_object_type,l_object_id;
1635: IF(jcg_req_exists_csr%found)THEN
1636: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;
1637: END IF;
1638: CLOSE jcg_req_exists_csr;
1639: END LOOP;
1640: END IF;

Line 1664: 'Before updating a new row in AHL_ENIGMA_JCG_DETAILS.'

1660: IF (l_log_statement >= l_log_current_level)THEN
1661: fnd_log.string(
1662: l_log_statement,
1663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1664: 'Before updating a new row in AHL_ENIGMA_JCG_DETAILS.'
1665: );
1666: END IF;
1667:
1668: UPDATE AHL_ENIGMA_JCG_DETAILS SET FILE_LOCATION = p_file_location,

Line 1668: UPDATE AHL_ENIGMA_JCG_DETAILS SET FILE_LOCATION = p_file_location,

1664: 'Before updating a new row in AHL_ENIGMA_JCG_DETAILS.'
1665: );
1666: END IF;
1667:
1668: UPDATE AHL_ENIGMA_JCG_DETAILS SET FILE_LOCATION = p_file_location,
1669: STATUS_CODE = p_status_code,
1670: OBJECT_VERSION_NUMBER = l_ovn+1,
1671: ERROR_MESSAGE = p_error_message,
1672: LAST_UPDATE_DATE = sysdate,

Line 1685: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;

1681: LOOP
1682: OPEN jcg_req_exists_csr (jcg_rec.jcg_request_id);
1683: FETCH jcg_req_exists_csr INTO l_ovn,l_object_type,l_object_id;
1684: IF(jcg_req_exists_csr%found)THEN
1685: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;
1686: END IF;
1687: CLOSE jcg_req_exists_csr;
1688: END LOOP;
1689: END IF;

Line 1697: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;

1693: LOOP
1694: OPEN jcg_req_exists_csr (jcg_rec.jcg_request_id);
1695: FETCH jcg_req_exists_csr INTO l_ovn,l_object_type,l_object_id;
1696: IF(jcg_req_exists_csr%found)THEN
1697: DELETE FROM AHL_ENIGMA_JCG_DETAILS WHERE JCG_REQUEST_ID = jcg_rec.JCG_REQUEST_ID ;
1698: END IF;
1699: CLOSE jcg_req_exists_csr;
1700: END LOOP;
1701: END IF;

Line 1765: Select 'X' from AHL_ENIGMA_JCG_DETAILS

1761: IS
1762:
1763: Cursor check_job_card_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1764: IS
1765: Select 'X' from AHL_ENIGMA_JCG_DETAILS
1766: Where OBJECT_TYPE_CODE = c_object_type
1767: AND OBJECT_ID = c_object_id
1768: AND STATUS_CODE = 'S';
1769:

Line 1800: Select FILE_LOCATION from AHL_ENIGMA_JCG_DETAILS

1796: IS
1797:
1798: Cursor get_file_location_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1799: IS
1800: Select FILE_LOCATION from AHL_ENIGMA_JCG_DETAILS
1801: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1802: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1803: Where OBJECT_TYPE_CODE = c_object_type
1804: AND OBJECT_ID = c_object_id

Line 1802: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS

1798: Cursor get_file_location_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1799: IS
1800: Select FILE_LOCATION from AHL_ENIGMA_JCG_DETAILS
1801: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1802: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1803: Where OBJECT_TYPE_CODE = c_object_type
1804: AND OBJECT_ID = c_object_id
1805: AND STATUS_CODE = 'S'
1806: ));

Line 1836: Select STATUS_CODE from AHL_ENIGMA_JCG_DETAILS

1832: IS
1833:
1834: Cursor get_latest_status_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1835: IS
1836: Select STATUS_CODE from AHL_ENIGMA_JCG_DETAILS
1837: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1838: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1839: Where OBJECT_TYPE_CODE = c_object_type
1840: AND OBJECT_ID = c_object_id

Line 1838: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS

1834: Cursor get_latest_status_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1835: IS
1836: Select STATUS_CODE from AHL_ENIGMA_JCG_DETAILS
1837: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1838: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1839: Where OBJECT_TYPE_CODE = c_object_type
1840: AND OBJECT_ID = c_object_id
1841: ));
1842:

Line 1871: Select ERROR_MESSAGE from AHL_ENIGMA_JCG_DETAILS

1867: IS
1868:
1869: Cursor get_jcg_error_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1870: IS
1871: Select ERROR_MESSAGE from AHL_ENIGMA_JCG_DETAILS
1872: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1873: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1874: Where OBJECT_TYPE_CODE = c_object_type
1875: AND OBJECT_ID = c_object_id

Line 1873: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS

1869: Cursor get_jcg_error_csr(c_object_type VARCHAR2, c_object_id NUMBER)
1870: IS
1871: Select ERROR_MESSAGE from AHL_ENIGMA_JCG_DETAILS
1872: where JCG_REQUEST_ID = (Select max(JCG_REQUEST_ID) from (
1873: Select JCG_REQUEST_ID from AHL_ENIGMA_JCG_DETAILS
1874: Where OBJECT_TYPE_CODE = c_object_type
1875: AND OBJECT_ID = c_object_id
1876: AND STATUS_CODE = 'E'
1877: ));

Line 4018: FROM ahl_enigma_jcg_details

4014: l_bpel_process_end_point varchar2(2000);
4015:
4016: CURSOR get_jcg_details(p_jcg_id IN NUMBER) IS
4017: SELECT JCG_REQUEST_ID,OBJECT_TYPE_CODE,OBJECT_ID,SPLIT_FLAG
4018: FROM ahl_enigma_jcg_details
4019: WHERE JCG_REQUEST_ID = p_jcg_id;
4020:
4021: l_object_type_code VARCHAR2(30);
4022: l_object_id NUMBER;

Line 4482: FROM ahl_enigma_jcg_details

4478: l_pdf_table PDF_TABLE_TYPE;
4479:
4480: CURSOR get_jcg_details(p_jcg_id IN NUMBER) IS
4481: SELECT JCG_REQUEST_ID,OBJECT_TYPE_CODE,OBJECT_ID,SPLIT_FLAG,CONCURRENT_REQUEST_ID
4482: FROM ahl_enigma_jcg_details
4483: WHERE JCG_REQUEST_ID = p_jcg_id;
4484:
4485: l_jcg_details_rec get_jcg_details%rowtype;
4486: l_pdf_resp_count integer;

Line 4495: select 'x' from ahl_enigma_jcg_details

4491: l_x_jcg_id NUMBER;
4492:
4493: cursor does_more_recent_jcg_exist(p_jcg_id in number,p_object_type_code in varchar2,p_object_id in number,
4494: p_concurrent_request_id in number) is
4495: select 'x' from ahl_enigma_jcg_details
4496: where object_type_code = p_object_type_code
4497: and object_id = p_object_id
4498: and jcg_request_id > p_jcg_id
4499: AND concurrent_request_id > p_concurrent_request_id;

Line 4781: FROM ahl_enigma_jcg_details

4777: l_resp_id NUMBER;
4778:
4779: CURSOR get_jcg_details(p_jcg_id IN NUMBER) IS
4780: SELECT JCG_REQUEST_ID,OBJECT_TYPE_CODE,OBJECT_ID,SPLIT_FLAG,CONCURRENT_REQUEST_ID
4781: FROM ahl_enigma_jcg_details
4782: WHERE JCG_REQUEST_ID = p_jcg_id;
4783:
4784: l_jcg_details_rec get_jcg_details%rowtype;
4785: l_error_msg VARCHAR2(4000);