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.OKC_XPRT_IMPORT_PVT dependencies on FND_PROFILE

Line 536: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

532:
533:
534: BEGIN
535:
536: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
537:
538: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
539:
540: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN

Line 582: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

578: last_update_login = FND_GLOBAL.LOGIN_ID,
579: last_update_date = SYSDATE,
580: last_updated_by = FND_GLOBAL.USER_ID
581: WHERE org_id = p_org_id
582: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
583: intent,
584: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
585: )
586: AND status_code = 'PENDINGPUB';

Line 584: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

580: last_updated_by = FND_GLOBAL.USER_ID
581: WHERE org_id = p_org_id
582: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
583: intent,
584: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
585: )
586: AND status_code = 'PENDINGPUB';
587:
588: -- Check If any rules are to be processed else exit

Line 1338: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

1334: last_update_login = FND_GLOBAL.LOGIN_ID,
1335: last_update_date = SYSDATE,
1336: last_updated_by = FND_GLOBAL.USER_ID
1337: WHERE org_id = p_org_id
1338: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1339: intent,
1340: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1341: )
1342: AND status_code = 'PENDINGPUB';

Line 1340: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

1336: last_updated_by = FND_GLOBAL.USER_ID
1337: WHERE org_id = p_org_id
1338: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1339: intent,
1340: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1341: )
1342: AND status_code = 'PENDINGPUB';
1343:
1344: -- Check If any rules are to be processed else exit

Line 1615: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

1611:
1612:
1613: BEGIN
1614:
1615: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
1616:
1617: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
1618:
1619: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN

Line 1661: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

1657: last_update_login = FND_GLOBAL.LOGIN_ID,
1658: last_update_date = SYSDATE,
1659: last_updated_by = FND_GLOBAL.USER_ID
1660: WHERE org_id = p_org_id
1661: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1662: intent,
1663: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1664: )
1665: AND status_code = 'PENDINGDISABLE';

Line 1663: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

1659: last_updated_by = FND_GLOBAL.USER_ID
1660: WHERE org_id = p_org_id
1661: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1662: intent,
1663: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1664: )
1665: AND status_code = 'PENDINGDISABLE';
1666:
1667: -- Check If any rules are to be processed else exit

Line 2218: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',

2214: last_update_login = FND_GLOBAL.LOGIN_ID,
2215: last_update_date = SYSDATE,
2216: last_updated_by = FND_GLOBAL.USER_ID
2217: WHERE org_id = p_org_id
2218: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
2219: intent,
2220: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
2221: )
2222: AND status_code = 'PENDINGDISABLE';

Line 2220: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')

2216: last_updated_by = FND_GLOBAL.USER_ID
2217: WHERE org_id = p_org_id
2218: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
2219: intent,
2220: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
2221: )
2222: AND status_code = 'PENDINGDISABLE';
2223:
2224: -- Check If any rules are to be processed else exit

Line 2635: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

2631: BEGIN
2632:
2633:
2634:
2635: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
2636:
2637: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
2638:
2639: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN