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_CONTRACT_APPROVAL_PVT dependencies on FND_GLOBAL

Line 153: last_update_login = FND_GLOBAL.LOGIN_ID,

149: UPDATE oks_k_headers_b
150: SET object_version_number = object_version_number + 1,
151: renewal_status = 'ACT',
152: last_update_date = SYSDATE,
153: last_update_login = FND_GLOBAL.LOGIN_ID,
154: Last_updated_by = FND_GLOBAL.USER_ID
155: WHERE chr_id = p_contract_id;
156: END IF;
157: */

Line 154: Last_updated_by = FND_GLOBAL.USER_ID

150: SET object_version_number = object_version_number + 1,
151: renewal_status = 'ACT',
152: last_update_date = SYSDATE,
153: last_update_login = FND_GLOBAL.LOGIN_ID,
154: Last_updated_by = FND_GLOBAL.USER_ID
155: WHERE chr_id = p_contract_id;
156: END IF;
157: */
158: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN

Line 194: last_update_login = FND_GLOBAL.LOGIN_ID,

190: UPDATE oks_k_headers_b
191: SET object_version_number = object_version_number + 1,
192: renewal_status = 'REJ',
193: last_update_date = SYSDATE,
194: last_update_login = FND_GLOBAL.LOGIN_ID,
195: Last_updated_by = FND_GLOBAL.USER_ID
196: WHERE chr_id = p_contract_id;
197: END IF;
198: */

Line 195: Last_updated_by = FND_GLOBAL.USER_ID

191: SET object_version_number = object_version_number + 1,
192: renewal_status = 'REJ',
193: last_update_date = SYSDATE,
194: last_update_login = FND_GLOBAL.LOGIN_ID,
195: Last_updated_by = FND_GLOBAL.USER_ID
196: WHERE chr_id = p_contract_id;
197: END IF;
198: */
199: END IF;

Line 215: last_updated_by = FND_GLOBAL.USER_ID,

211: UPDATE oks_k_headers_b
212: SET renewal_status = 'COMPLETE',
213: object_version_number = object_version_number + 1,
214: last_update_date = SYSDATE,
215: last_updated_by = FND_GLOBAL.USER_ID,
216: last_update_login = FND_GLOBAL.LOGIN_ID
217: WHERE chr_id = p_contract_id;
218: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
219: -- Launch process workflow for existing service contracts created prior to r12

Line 216: last_update_login = FND_GLOBAL.LOGIN_ID

212: SET renewal_status = 'COMPLETE',
213: object_version_number = object_version_number + 1,
214: last_update_date = SYSDATE,
215: last_updated_by = FND_GLOBAL.USER_ID,
216: last_update_login = FND_GLOBAL.LOGIN_ID
217: WHERE chr_id = p_contract_id;
218: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
219: -- Launch process workflow for existing service contracts created prior to r12
220: -- as they would not have process workflow associated as they had been in the

Line 260: last_update_login = FND_GLOBAL.LOGIN_ID,

256: SET object_version_number = object_version_number + 1,
257: wf_item_key = l_wf_attributes.ITEM_KEY,
258: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
259: last_update_date = SYSDATE,
260: last_update_login = FND_GLOBAL.LOGIN_ID,
261: Last_updated_by = FND_GLOBAL.USER_ID
262: WHERE chr_id = l_wf_attributes.contract_id;
263: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,

Line 261: Last_updated_by = FND_GLOBAL.USER_ID

257: wf_item_key = l_wf_attributes.ITEM_KEY,
258: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
259: last_update_date = SYSDATE,
260: last_update_login = FND_GLOBAL.LOGIN_ID,
261: Last_updated_by = FND_GLOBAL.USER_ID
262: WHERE chr_id = l_wf_attributes.contract_id;
263: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,
265: ' Updated negotiation status to REJECTED');

Line 440: -- IF FND_GLOBAL.USER_ID <> -1 THEN

436: --
437: -- Modified for Bug 2046890
438: -- Below IF added because context does not set thru background processes
439: -- that's why need to bypass it
440: -- IF FND_GLOBAL.USER_ID <> -1 THEN
441: IF p_access_level = 'N' THEN
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);

Line 444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);

440: -- IF FND_GLOBAL.USER_ID <> -1 THEN
441: IF p_access_level = 'N' THEN
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
445: END IF;
446: if k_accesible( p_contract_id => p_contract_id,
447: p_user_id => fnd_global.user_id,
448: p_level => 'U'

Line 447: p_user_id => fnd_global.user_id,

443: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
445: END IF;
446: if k_accesible( p_contract_id => p_contract_id,
447: p_user_id => fnd_global.user_id,
448: p_level => 'U'
449: ) = OKC_API.G_FALSE
450: then
451: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 674: avalue => NVL(p_user_id,fnd_global.user_id));

670: begin
671: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
672: itemkey => L_KEY,
673: aname => 'USER_ID',
674: avalue => NVL(p_user_id,fnd_global.user_id));
675: exception
676: when others then
677: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
678: itemkey => L_KEY,

Line 683: avalue => NVL(p_user_id,fnd_global.user_id));

679: aname => 'USER_ID');
680: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
681: itemkey => L_KEY,
682: aname => 'USER_ID',
683: avalue => NVL(p_user_id,fnd_global.user_id));
684: end;
685: begin
686: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
687: itemkey => L_KEY,

Line 689: avalue => NVL(p_resp_id,fnd_global.resp_id));

685: begin
686: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
687: itemkey => L_KEY,
688: aname => 'RESP_ID',
689: avalue => NVL(p_resp_id,fnd_global.resp_id));
690: exception
691: when others then
692: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
693: itemkey => L_KEY,

Line 698: avalue => NVL(p_resp_id,fnd_global.resp_id));

694: aname => 'RESP_ID');
695: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
696: itemkey => L_KEY,
697: aname => 'RESP_ID',
698: avalue => NVL(p_resp_id,fnd_global.resp_id));
699: end;
700: begin
701: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
702: itemkey => L_KEY,

Line 704: avalue => NVL(p_resp_appl_id,fnd_global.RESP_APPL_id));

700: begin
701: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
702: itemkey => L_KEY,
703: aname => 'RESP_APPL_ID',
704: avalue => NVL(p_resp_appl_id,fnd_global.RESP_APPL_id));
705: exception
706: when others then
707: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
708: itemkey => L_KEY,

Line 713: avalue => NVL(p_resp_appl_id,fnd_global.RESP_APPL_id));

709: aname => 'RESP_APPL_ID');
710: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
711: itemkey => L_KEY,
712: aname => 'RESP_APPL_ID',
713: avalue => NVL(p_resp_appl_id,fnd_global.RESP_APPL_id));
714: end;
715: begin
716: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
717: itemkey => L_KEY,

Line 719: avalue => NVL(p_security_group_id,fnd_global.SECURITY_GROUP_id));

715: begin
716: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
717: itemkey => L_KEY,
718: aname => 'SECURITY_GROUP_ID',
719: avalue => NVL(p_security_group_id,fnd_global.SECURITY_GROUP_id));
720: exception
721: when others then
722: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
723: itemkey => L_KEY,

Line 728: avalue => NVL(p_security_group_id,fnd_global.SECURITY_GROUP_id));

724: aname => 'SECURITY_GROUP_ID');
725: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
726: itemkey => L_KEY,
727: aname => 'SECURITY_GROUP_ID',
728: avalue => NVL(p_security_group_id,fnd_global.SECURITY_GROUP_id));
729: end;
730: select value into L_NLS_VALUE
731: from NLS_SESSION_PARAMETERS
732: where PARAMETER='NLS_LANGUAGE';

Line 804: owner => fnd_global.user_name);

800: avalue => L_NLS_VALUE);
801: end;
802: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
803: itemkey => L_KEY,
804: owner => fnd_global.user_name);
805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
807: 'Starting approval wf');
808: END IF;

Line 1027: and orig_system_id=fnd_global.user_id

1023: /*
1024: select display_name
1025: from wf_roles
1026: where orig_system = 'FND_USR'
1027: and orig_system_id=fnd_global.user_id
1028: -- changed to boost perf
1029: */
1030: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
1031: union all

Line 1030: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null

1026: where orig_system = 'FND_USR'
1027: and orig_system_id=fnd_global.user_id
1028: -- changed to boost perf
1029: */
1030: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
1031: union all
1032: select
1033: PER.FULL_NAME display_name
1034: from

Line 1040: and USR.USER_ID = fnd_global.user_id

1036: FND_USER USR
1037: where trunc(SYSDATE)
1038: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
1039: and PER.PERSON_ID = USR.EMPLOYEE_ID
1040: and USR.USER_ID = fnd_global.user_id
1041: ;
1042:
1043: CURSOR k_process_csr(p_contract_id IN NUMBER ) IS
1044: SELECT wf_item_key FROM OKS_K_HEADERS_B

Line 1083: 'k_accesible with p_level=U User Id '||fnd_global.user_id);

1079: END IF;
1080: --
1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1083: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
1084: END IF;
1085: if k_accesible( p_contract_id => p_contract_id,
1086: p_user_id => fnd_global.user_id,
1087: p_level => 'U'

Line 1086: p_user_id => fnd_global.user_id,

1082: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1083: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
1084: END IF;
1085: if k_accesible( p_contract_id => p_contract_id,
1086: p_user_id => fnd_global.user_id,
1087: p_level => 'U'
1088: ) = OKC_API.G_FALSE
1089: then
1090: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1303: avalue => fnd_global.user_id);

1299: begin
1300: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1301: itemkey => L_KEY,
1302: aname => 'USER_ID',
1303: avalue => fnd_global.user_id);
1304: exception
1305: when others then
1306: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
1307: itemkey => L_KEY,

Line 1312: avalue => fnd_global.user_id);

1308: aname => 'USER_ID');
1309: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
1310: itemkey => L_KEY,
1311: aname => 'USER_ID',
1312: avalue => fnd_global.user_id);
1313: end;
1314: begin
1315: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1316: itemkey => L_KEY,

Line 1318: avalue => fnd_global.resp_id);

1314: begin
1315: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1316: itemkey => L_KEY,
1317: aname => 'RESP_ID',
1318: avalue => fnd_global.resp_id);
1319: exception
1320: when others then
1321: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
1322: itemkey => L_KEY,

Line 1327: avalue => fnd_global.resp_id);

1323: aname => 'RESP_ID');
1324: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
1325: itemkey => L_KEY,
1326: aname => 'RESP_ID',
1327: avalue => fnd_global.resp_id);
1328: end;
1329: begin
1330: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1331: itemkey => L_KEY,

Line 1333: avalue => fnd_global.RESP_APPL_id);

1329: begin
1330: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1331: itemkey => L_KEY,
1332: aname => 'RESP_APPL_ID',
1333: avalue => fnd_global.RESP_APPL_id);
1334: exception
1335: when others then
1336: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
1337: itemkey => L_KEY,

Line 1342: avalue => fnd_global.RESP_APPL_id);

1338: aname => 'RESP_APPL_ID');
1339: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
1340: itemkey => L_KEY,
1341: aname => 'RESP_APPL_ID',
1342: avalue => fnd_global.RESP_APPL_id);
1343: end;
1344: begin
1345: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1346: itemkey => L_KEY,

Line 1348: avalue => fnd_global.SECURITY_GROUP_id);

1344: begin
1345: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
1346: itemkey => L_KEY,
1347: aname => 'SECURITY_GROUP_ID',
1348: avalue => fnd_global.SECURITY_GROUP_id);
1349: exception
1350: when others then
1351: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
1352: itemkey => L_KEY,

Line 1357: avalue => fnd_global.SECURITY_GROUP_id);

1353: aname => 'SECURITY_GROUP_ID');
1354: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
1355: itemkey => L_KEY,
1356: aname => 'SECURITY_GROUP_ID',
1357: avalue => fnd_global.SECURITY_GROUP_id);
1358: end;
1359: select value into L_NLS_VALUE
1360: from NLS_SESSION_PARAMETERS
1361: where PARAMETER='NLS_LANGUAGE';

Line 1436: owner => fnd_global.user_name);

1432: -- start
1433: --
1434: wf_engine.SetItemOwner ( itemtype => l_wf_name_active,
1435: itemkey => L_KEY,
1436: owner => fnd_global.user_name);
1437: wf_engine.StartProcess( itemtype => l_wf_name_active,
1438: itemkey => L_KEY);
1439:
1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1494: last_update_login = FND_GLOBAL.LOGIN_ID,

1490: SET object_version_number = object_version_number + 1,
1491: wf_item_key = l_wf_attributes.ITEM_KEY,
1492: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
1493: last_update_date = SYSDATE,
1494: last_update_login = FND_GLOBAL.LOGIN_ID,
1495: Last_updated_by = FND_GLOBAL.USER_ID
1496: WHERE chr_id = l_wf_attributes.contract_id;
1497: ELSE
1498: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1495: Last_updated_by = FND_GLOBAL.USER_ID

1491: wf_item_key = l_wf_attributes.ITEM_KEY,
1492: renewal_status = l_wf_attributes.NEGOTIATION_STATUS,
1493: last_update_date = SYSDATE,
1494: last_update_login = FND_GLOBAL.LOGIN_ID,
1495: Last_updated_by = FND_GLOBAL.USER_ID
1496: WHERE chr_id = l_wf_attributes.contract_id;
1497: ELSE
1498: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1499: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

Line 1604: fnd_global.set_nls_context

1600: (L_NLS_VALUE12 = L_NLS_VALUE2) and
1601: (L_NLS_VALUE13 = L_NLS_VALUE3) and
1602: (L_NLS_VALUE14 = L_NLS_VALUE4)
1603: ) then
1604: fnd_global.set_nls_context
1605: (
1606: P_NLS_LANGUAGE => L_NLS_VALUE11,
1607: P_NLS_DATE_FORMAT => L_NLS_VALUE12,
1608: P_NLS_DATE_LANGUAGE => L_NLS_VALUE13,

Line 1611: fnd_global.apps_initialize

1607: P_NLS_DATE_FORMAT => L_NLS_VALUE12,
1608: P_NLS_DATE_LANGUAGE => L_NLS_VALUE13,
1609: P_NLS_NUMERIC_CHARACTERS => L_NLS_VALUE14);
1610: end if;
1611: fnd_global.apps_initialize
1612: (
1613: user_id =>
1614: wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'USER_ID'),
1615: resp_id =>

Line 2180: oks.last_update_login = FND_GLOBAL.LOGIN_ID,

2176: -1, decode(sign(months_between(p_date_signed - 1, l_sysdate)),
2177: -1, decode(sign(months_between(oks.start_date - 1, l_sysdate)),
2178: -1, l_active_status, l_signed_status), l_signed_status), l_expired_status),
2179: oks.last_update_date = l_sysdate,
2180: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2181: oks.last_updated_by = FND_GLOBAL.USER_ID;
2182: */
2183: UPDATE (SELECT l.sts_code, l.start_date, l.end_date, l.last_update_date, l.last_update_login, l.Last_updated_by
2184: FROM okc_k_lines_b l

Line 2181: oks.last_updated_by = FND_GLOBAL.USER_ID;

2177: -1, decode(sign(months_between(oks.start_date - 1, l_sysdate)),
2178: -1, l_active_status, l_signed_status), l_signed_status), l_expired_status),
2179: oks.last_update_date = l_sysdate,
2180: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2181: oks.last_updated_by = FND_GLOBAL.USER_ID;
2182: */
2183: UPDATE (SELECT l.sts_code, l.start_date, l.end_date, l.last_update_date, l.last_update_login, l.Last_updated_by
2184: FROM okc_k_lines_b l
2185: WHERE l.dnz_chr_id = p_contract_id) oks

Line 2193: oks.last_update_login = FND_GLOBAL.LOGIN_ID,

2189: -1, decode(sign(months_between(p_date_signed - 1, l_sysdate)),
2190: -1, decode(sign(months_between(oks.start_date - 1, l_sysdate)),
2191: -1, l_active_status, l_signed_status), l_signed_status), l_expired_status),
2192: oks.last_update_date = l_sysdate,
2193: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2194: oks.last_updated_by = FND_GLOBAL.USER_ID
2195: WHERE oks.sts_code IN (SELECT code
2196: FROM okc_statuses_b
2197: WHERE ste_code = 'ENTERED');

Line 2194: oks.last_updated_by = FND_GLOBAL.USER_ID

2190: -1, decode(sign(months_between(oks.start_date - 1, l_sysdate)),
2191: -1, l_active_status, l_signed_status), l_signed_status), l_expired_status),
2192: oks.last_update_date = l_sysdate,
2193: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2194: oks.last_updated_by = FND_GLOBAL.USER_ID
2195: WHERE oks.sts_code IN (SELECT code
2196: FROM okc_statuses_b
2197: WHERE ste_code = 'ENTERED');
2198: