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.JTF_RESOURCE_UTL dependencies on JTF_OBJECTS_B

Line 415: -- the table jtf_objects_vl to jtf_objects_b from FROM clause.

411:
412: -- fix for performance bug # 4956628
413: -- SQL ID : 14841989 from SQL Repository
414: -- mofified the below cusror to change
415: -- the table jtf_objects_vl to jtf_objects_b from FROM clause.
416:
417: CURSOR c_resource_category IS
418: SELECT jo.object_code
419: FROM jtf_objects_b jo,

Line 419: FROM jtf_objects_b jo,

415: -- the table jtf_objects_vl to jtf_objects_b from FROM clause.
416:
417: CURSOR c_resource_category IS
418: SELECT jo.object_code
419: FROM jtf_objects_b jo,
420: jtf_object_usages jou
421: WHERE jo.object_code = jou.object_code
422: AND jou.object_user_code = 'RESOURCE_CATEGORIES'
423: AND upper(jo.object_code) = upper(p_category)

Line 1437: (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,

1433: END validate_sales_credit_type;
1434:
1435:
1436: PROCEDURE check_object_existence
1437: (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1438: P_SELECT_ID IN VARCHAR2,
1439: P_OBJECT_USER_CODE IN VARCHAR2,
1440: X_FOUND OUT NOCOPY BOOLEAN ,
1441: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 1444: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,

1440: X_FOUND OUT NOCOPY BOOLEAN ,
1441: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1442: ) AS
1443:
1444: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1445: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1446: IS
1447: SELECT a.select_id
1448: ,a.from_table

Line 1450: FROM jtf_objects_B a,

1446: IS
1447: SELECT a.select_id
1448: ,a.from_table
1449: ,a.where_clause
1450: FROM jtf_objects_B a,
1451: jtf_object_usages b
1452: WHERE b.OBJECT_USER_CODE = l_object_user_code
1453: AND b.object_code = a.object_code
1454: and A.object_code = l_object_code;

Line 1474: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;

1470: WHERE resource_id = c_resource_id;
1471:
1472: l_temp varchar2(1);
1473:
1474: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1475: l_select_id number;
1476:
1477: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1478: l_select_clause VARCHAR2(4000);

Line 1504: --open the cursor to get the related values from jtf_objects_b

1500: THEN
1501: if object_code_cur%ISOPEN THEN
1502: close object_code_cur;
1503: end if;
1504: --open the cursor to get the related values from jtf_objects_b
1505: open object_dtls_cur(l_object_code, ll_object_user_code);
1506: fetch object_dtls_cur INTO object_dtls_rec;
1507: IF(object_dtls_cur%FOUND)
1508: THEN

Line 1533: --create the sql staement based on the values fetched from jtf_objects_b

1529: CLOSE c_res_existence;
1530: return;
1531: END IF;
1532: else
1533: --create the sql staement based on the values fetched from jtf_objects_b
1534: IF object_dtls_rec.where_clause IS NOT NULL
1535: THEN
1536: /* BINDVAR_SCAN_IGNORE [1] */
1537: l_select_clause := 'SELECT '|| object_dtls_rec.select_id ||' '

Line 1626: (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,

1622: END check_object_existence;
1623:
1624:
1625: PROCEDURE check_object_existence_migr
1626: (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1627: P_SELECT_ID IN VARCHAR2,
1628: P_OBJECT_USER_CODE IN VARCHAR2,
1629: P_RS_ID_PUB_FLAG IN VARCHAR2,
1630: X_FOUND OUT NOCOPY BOOLEAN,

Line 1634: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,

1630: X_FOUND OUT NOCOPY BOOLEAN,
1631: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1632: ) AS
1633:
1634: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1635: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1636: IS
1637: SELECT a.select_id
1638: ,a.from_table

Line 1640: FROM jtf_objects_B a,

1636: IS
1637: SELECT a.select_id
1638: ,a.from_table
1639: ,a.where_clause
1640: FROM jtf_objects_B a,
1641: jtf_object_usages b
1642: WHERE b.OBJECT_USER_CODE = l_object_user_code
1643: AND b.object_code = a.object_code
1644: and A.object_code = l_object_code;

Line 1671: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;

1667: where per.party_id = hz.party_id);
1668:
1669: object_code_rec object_code_cur%rowtype;
1670:
1671: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1672: l_select_id number;
1673:
1674: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1675: l_select_clause VARCHAR2(4000);

Line 1704: --open the cursor to get the related values from jtf_objects_b

1700: THEN
1701: if object_code_cur%ISOPEN then
1702: close object_code_cur;
1703: end if;
1704: --open the cursor to get the related values from jtf_objects_b
1705: open object_dtls_cur(l_object_code, ll_object_user_code);
1706: fetch object_dtls_cur INTO object_dtls_rec;
1707: IF(object_dtls_cur%FOUND)
1708: THEN

Line 1714: --create the sql staement based on the values fetched from jtf_objects_b

1710: close object_dtls_cur;
1711: end if;
1712: x_return_status := fnd_api.g_ret_sts_success;
1713:
1714: --create the sql staement based on the values fetched from jtf_objects_b
1715:
1716: IF (P_OBJECT_CODE <> 'EMPLOYEE' and P_OBJECT_CODE <> 'PARTY') THEN
1717: IF object_dtls_rec.where_clause IS NOT NULL
1718: THEN