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.AR_CMGT_WF_ENGINE dependencies on FND_GLOBAL

Line 516: last_updated_by = fnd_global.user_id,

512:
513: UPDATE ar_cmgt_credit_requests
514: set credit_analyst_id = l_resource_id,
515: last_update_date = sysdate,
516: last_updated_by = fnd_global.user_id,
517: last_update_login = fnd_global.login_id
518: WHERE credit_request_id = itemkey
519: AND credit_analyst_id IS NULL;
520:

Line 517: last_update_login = fnd_global.login_id

513: UPDATE ar_cmgt_credit_requests
514: set credit_analyst_id = l_resource_id,
515: last_update_date = sysdate,
516: last_updated_by = fnd_global.user_id,
517: last_update_login = fnd_global.login_id
518: WHERE credit_request_id = itemkey
519: AND credit_analyst_id IS NULL;
520:
521: UPDATE ar_cmgt_case_folders

Line 525: last_updated_by = fnd_global.user_id,

521: UPDATE ar_cmgt_case_folders
522: set credit_analyst_id = l_resource_id,
523: last_updated = sysdate,
524: last_update_date = sysdate,
525: last_updated_by = fnd_global.user_id,
526: last_update_login = fnd_global.login_id
527: WHERE credit_request_id = itemkey
528: AND credit_analyst_id IS NULL;
529:

Line 526: last_update_login = fnd_global.login_id

522: set credit_analyst_id = l_resource_id,
523: last_updated = sysdate,
524: last_update_date = sysdate,
525: last_updated_by = fnd_global.user_id,
526: last_update_login = fnd_global.login_id
527: WHERE credit_request_id = itemkey
528: AND credit_analyst_id IS NULL;
529:
530: l_failure_function := WF_ENGINE.getItemAttrText(

Line 806: last_updated_by = fnd_global.user_id,

802:
803: UPDATE ar_cmgt_credit_requests
804: SET credit_analyst_id = l_credit_analyst_id,
805: last_update_date = sysdate,
806: last_updated_by = fnd_global.user_id,
807: last_update_login = fnd_global.login_id
808: WHERE credit_request_id = itemkey;
809:
810:

Line 807: last_update_login = fnd_global.login_id

803: UPDATE ar_cmgt_credit_requests
804: SET credit_analyst_id = l_credit_analyst_id,
805: last_update_date = sysdate,
806: last_updated_by = fnd_global.user_id,
807: last_update_login = fnd_global.login_id
808: WHERE credit_request_id = itemkey;
809:
810:
811: WF_ENGINE.setItemAttrText(itemType => 'ARCMGTAP',

Line 836: last_updated_by = fnd_global.user_id,

832: update ar_cmgt_case_folders
833: set credit_analyst_id = l_credit_analyst_id,
834: last_updated = sysdate,
835: last_update_date = sysdate,
836: last_updated_by = fnd_global.user_id,
837: last_update_login = fnd_global.login_id
838: WHERE case_folder_id = l_case_folder_id;
839:
840: -- Also upadate data records with credit_analyst_id

Line 837: last_update_login = fnd_global.login_id

833: set credit_analyst_id = l_credit_analyst_id,
834: last_updated = sysdate,
835: last_update_date = sysdate,
836: last_updated_by = fnd_global.user_id,
837: last_update_login = fnd_global.login_id
838: WHERE case_folder_id = l_case_folder_id;
839:
840: -- Also upadate data records with credit_analyst_id
841: update ar_cmgt_case_folders

Line 845: last_updated_by = fnd_global.user_id,

841: update ar_cmgt_case_folders
842: set credit_analyst_id = l_credit_analyst_id,
843: last_updated = sysdate,
844: last_update_date = sysdate,
845: last_updated_by = fnd_global.user_id,
846: last_update_login = fnd_global.login_id
847: WHERE credit_request_id = itemkey
848: AND type = 'DATA';
849: END IF;

Line 846: last_update_login = fnd_global.login_id

842: set credit_analyst_id = l_credit_analyst_id,
843: last_updated = sysdate,
844: last_update_date = sysdate,
845: last_updated_by = fnd_global.user_id,
846: last_update_login = fnd_global.login_id
847: WHERE credit_request_id = itemkey
848: AND type = 'DATA';
849: END IF;
850: resultout := 'COMPLETE:SUCESS';

Line 1007: last_updated_by = fnd_global.user_id,

1003: THEN
1004: UPDATE ar_cmgt_credit_requests
1005: SET status = 'IN_PROCESS',
1006: last_update_date = sysdate,
1007: last_updated_by = fnd_global.user_id,
1008: last_update_login = fnd_global.login_id
1009: WHERE credit_request_id = itemkey;
1010:
1011: END IF;

Line 1008: last_update_login = fnd_global.login_id

1004: UPDATE ar_cmgt_credit_requests
1005: SET status = 'IN_PROCESS',
1006: last_update_date = sysdate,
1007: last_updated_by = fnd_global.user_id,
1008: last_update_login = fnd_global.login_id
1009: WHERE credit_request_id = itemkey;
1010:
1011: END IF;
1012:

Line 1029: last_updated_by = fnd_global.user_id,

1025: THEN
1026: UPDATE ar_cmgt_credit_requests
1027: SET status = 'SUBMIT',
1028: last_update_date = sysdate,
1029: last_updated_by = fnd_global.user_id,
1030: last_update_login = fnd_global.login_id
1031: WHERE credit_request_id = itemkey;
1032:
1033: END IF;

Line 1030: last_update_login = fnd_global.login_id

1026: UPDATE ar_cmgt_credit_requests
1027: SET status = 'SUBMIT',
1028: last_update_date = sysdate,
1029: last_updated_by = fnd_global.user_id,
1030: last_update_login = fnd_global.login_id
1031: WHERE credit_request_id = itemkey;
1032:
1033: END IF;
1034:

Line 1059: last_updated_by = fnd_global.user_id,

1055: UPDATE ar_cmgt_case_folders
1056: SET status = 'SUBMITTED',
1057: last_updated = sysdate,
1058: last_update_date = sysdate,
1059: last_updated_by = fnd_global.user_id,
1060: last_update_login = fnd_global.login_id
1061: WHERE case_folder_id = l_case_folder_id;
1062:
1063: END IF;

Line 1060: last_update_login = fnd_global.login_id

1056: SET status = 'SUBMITTED',
1057: last_updated = sysdate,
1058: last_update_date = sysdate,
1059: last_updated_by = fnd_global.user_id,
1060: last_update_login = fnd_global.login_id
1061: WHERE case_folder_id = l_case_folder_id;
1062:
1063: END IF;
1064:

Line 2270: ' last_updated_by = fnd_global.user_id, '||

2266: l_sql_statement :=
2267: ' UPDATE hz_customer_profiles ' ||
2268: ' set credit_classification = :1 ,'||
2269: ' last_update_date = sysdate ,'||
2270: ' last_updated_by = fnd_global.user_id, '||
2271: ' last_update_login = fnd_global.login_id '||
2272: ' where party_id = :2 '||
2273: ' and cust_account_id = :3 '||
2274: ' and site_use_id IS NULL' ;

Line 2271: ' last_update_login = fnd_global.login_id '||

2267: ' UPDATE hz_customer_profiles ' ||
2268: ' set credit_classification = :1 ,'||
2269: ' last_update_date = sysdate ,'||
2270: ' last_updated_by = fnd_global.user_id, '||
2271: ' last_update_login = fnd_global.login_id '||
2272: ' where party_id = :2 '||
2273: ' and cust_account_id = :3 '||
2274: ' and site_use_id IS NULL' ;
2275: EXECUTE IMMEDIATE l_sql_statement using

Line 2285: ' last_updated_by = fnd_global.user_id, '||

2281: l_sql_statement :=
2282: ' UPDATE hz_customer_profiles ' ||
2283: ' set credit_classification = :1, '||
2284: ' last_update_date = sysdate ,'||
2285: ' last_updated_by = fnd_global.user_id, '||
2286: ' last_update_login = fnd_global.login_id '||
2287: ' where party_id = :2 '||
2288: ' and cust_account_id = :3 '||
2289: ' and site_use_id = :4 ';

Line 2286: ' last_update_login = fnd_global.login_id '||

2282: ' UPDATE hz_customer_profiles ' ||
2283: ' set credit_classification = :1, '||
2284: ' last_update_date = sysdate ,'||
2285: ' last_updated_by = fnd_global.user_id, '||
2286: ' last_update_login = fnd_global.login_id '||
2287: ' where party_id = :2 '||
2288: ' and cust_account_id = :3 '||
2289: ' and site_use_id = :4 ';
2290: EXECUTE IMMEDIATE l_sql_statement using

Line 2303: last_updated_by = fnd_global.user_id,

2299: THEN
2300: UPDATE hz_cust_profile_amts
2301: set trx_credit_limit = p_reco_value2,
2302: last_update_date = sysdate,
2303: last_updated_by = fnd_global.user_id,
2304: last_update_login = fnd_global.login_id
2305: WHERE cust_account_profile_id = (
2306: select cust_account_profile_id
2307: from hz_customer_profiles

Line 2304: last_update_login = fnd_global.login_id

2300: UPDATE hz_cust_profile_amts
2301: set trx_credit_limit = p_reco_value2,
2302: last_update_date = sysdate,
2303: last_updated_by = fnd_global.user_id,
2304: last_update_login = fnd_global.login_id
2305: WHERE cust_account_profile_id = (
2306: select cust_account_profile_id
2307: from hz_customer_profiles
2308: WHERE party_id = p_party_id

Line 2317: last_updated_by = fnd_global.user_id,

2313: THEN
2314: UPDATE hz_cust_profile_amts
2315: set trx_credit_limit = p_reco_value2,
2316: last_update_date = sysdate,
2317: last_updated_by = fnd_global.user_id,
2318: last_update_login = fnd_global.login_id
2319: WHERE cust_account_profile_id = (
2320: select cust_account_profile_id
2321: from hz_customer_profiles

Line 2318: last_update_login = fnd_global.login_id

2314: UPDATE hz_cust_profile_amts
2315: set trx_credit_limit = p_reco_value2,
2316: last_update_date = sysdate,
2317: last_updated_by = fnd_global.user_id,
2318: last_update_login = fnd_global.login_id
2319: WHERE cust_account_profile_id = (
2320: select cust_account_profile_id
2321: from hz_customer_profiles
2322: WHERE party_id = p_party_id

Line 2334: last_updated_by = fnd_global.user_id,

2330: THEN
2331: UPDATE hz_cust_profile_amts
2332: set overall_credit_limit = p_reco_value2,
2333: last_update_date = sysdate,
2334: last_updated_by = fnd_global.user_id,
2335: last_update_login = fnd_global.login_id
2336: WHERE cust_account_profile_id = (
2337: select cust_account_profile_id
2338: from hz_customer_profiles

Line 2335: last_update_login = fnd_global.login_id

2331: UPDATE hz_cust_profile_amts
2332: set overall_credit_limit = p_reco_value2,
2333: last_update_date = sysdate,
2334: last_updated_by = fnd_global.user_id,
2335: last_update_login = fnd_global.login_id
2336: WHERE cust_account_profile_id = (
2337: select cust_account_profile_id
2338: from hz_customer_profiles
2339: WHERE party_id = p_party_id

Line 2348: last_updated_by = fnd_global.user_id,

2344: THEN
2345: UPDATE hz_cust_profile_amts
2346: set overall_credit_limit = p_reco_value2,
2347: last_update_date = sysdate,
2348: last_updated_by = fnd_global.user_id,
2349: last_update_login = fnd_global.login_id
2350: WHERE cust_account_profile_id = (
2351: select cust_account_profile_id
2352: from hz_customer_profiles

Line 2349: last_update_login = fnd_global.login_id

2345: UPDATE hz_cust_profile_amts
2346: set overall_credit_limit = p_reco_value2,
2347: last_update_date = sysdate,
2348: last_updated_by = fnd_global.user_id,
2349: last_update_login = fnd_global.login_id
2350: WHERE cust_account_profile_id = (
2351: select cust_account_profile_id
2352: from hz_customer_profiles
2353: WHERE party_id = p_party_id

Line 2365: last_updated_by = fnd_global.user_id,

2361: THEN
2362: UPDATE hz_customer_profiles
2363: set credit_hold = 'Y',
2364: last_update_date = sysdate,
2365: last_updated_by = fnd_global.user_id,
2366: last_update_login = fnd_global.login_id
2367: WHERE party_id = p_party_id
2368: AND cust_account_id = p_cust_account_id
2369: AND site_use_id IS NULL;

Line 2366: last_update_login = fnd_global.login_id

2362: UPDATE hz_customer_profiles
2363: set credit_hold = 'Y',
2364: last_update_date = sysdate,
2365: last_updated_by = fnd_global.user_id,
2366: last_update_login = fnd_global.login_id
2367: WHERE party_id = p_party_id
2368: AND cust_account_id = p_cust_account_id
2369: AND site_use_id IS NULL;
2370: ELSIF p_site_use_id IS NOT NULL

Line 2375: last_updated_by = fnd_global.user_id,

2371: THEN
2372: UPDATE hz_customer_profiles
2373: set credit_hold = 'Y',
2374: last_update_date = sysdate,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_login = fnd_global.login_id
2377: WHERE party_id = p_party_id
2378: AND cust_account_id = p_cust_account_id
2379: AND site_use_id = p_site_use_id;

Line 2376: last_update_login = fnd_global.login_id

2372: UPDATE hz_customer_profiles
2373: set credit_hold = 'Y',
2374: last_update_date = sysdate,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_login = fnd_global.login_id
2377: WHERE party_id = p_party_id
2378: AND cust_account_id = p_cust_account_id
2379: AND site_use_id = p_site_use_id;
2380: END IF;

Line 2389: last_updated_by = fnd_global.user_id,

2385: THEN
2386: UPDATE hz_customer_profiles
2387: set credit_hold = 'N',
2388: last_update_date = sysdate,
2389: last_updated_by = fnd_global.user_id,
2390: last_update_login = fnd_global.login_id
2391: WHERE party_id = p_party_id
2392: AND cust_account_id = p_cust_account_id
2393: AND site_use_id IS NULL;

Line 2390: last_update_login = fnd_global.login_id

2386: UPDATE hz_customer_profiles
2387: set credit_hold = 'N',
2388: last_update_date = sysdate,
2389: last_updated_by = fnd_global.user_id,
2390: last_update_login = fnd_global.login_id
2391: WHERE party_id = p_party_id
2392: AND cust_account_id = p_cust_account_id
2393: AND site_use_id IS NULL;
2394: ELSIF p_site_use_id IS NOT NULL

Line 2399: last_updated_by = fnd_global.user_id,

2395: THEN
2396: UPDATE hz_customer_profiles
2397: set credit_hold = 'N',
2398: last_update_date = sysdate,
2399: last_updated_by = fnd_global.user_id,
2400: last_update_login = fnd_global.login_id
2401: WHERE party_id = p_party_id
2402: AND cust_account_id = p_cust_account_id
2403: AND site_use_id = p_site_use_id;

Line 2400: last_update_login = fnd_global.login_id

2396: UPDATE hz_customer_profiles
2397: set credit_hold = 'N',
2398: last_update_date = sysdate,
2399: last_updated_by = fnd_global.user_id,
2400: last_update_login = fnd_global.login_id
2401: WHERE party_id = p_party_id
2402: AND cust_account_id = p_cust_account_id
2403: AND site_use_id = p_site_use_id;
2404: END IF;

Line 2413: last_updated_by = fnd_global.user_id,

2409: UPDATE hz_cust_profile_amts
2410: set overall_credit_limit = (overall_credit_limit +
2411: ( overall_credit_limit * p_reco_value2/100)),
2412: last_update_date = sysdate,
2413: last_updated_by = fnd_global.user_id,
2414: last_update_login = fnd_global.login_id
2415: WHERE cust_account_profile_id = (
2416: select cust_account_profile_id
2417: from hz_customer_profiles

Line 2414: last_update_login = fnd_global.login_id

2410: set overall_credit_limit = (overall_credit_limit +
2411: ( overall_credit_limit * p_reco_value2/100)),
2412: last_update_date = sysdate,
2413: last_updated_by = fnd_global.user_id,
2414: last_update_login = fnd_global.login_id
2415: WHERE cust_account_profile_id = (
2416: select cust_account_profile_id
2417: from hz_customer_profiles
2418: WHERE party_id = p_party_id

Line 2428: last_updated_by = fnd_global.user_id,

2424: UPDATE hz_cust_profile_amts
2425: set overall_credit_limit = (overall_credit_limit +
2426: ( overall_credit_limit * p_reco_value2/100)),
2427: last_update_date = sysdate,
2428: last_updated_by = fnd_global.user_id,
2429: last_update_login = fnd_global.login_id
2430: WHERE cust_account_profile_id = (
2431: select cust_account_profile_id
2432: from hz_customer_profiles

Line 2429: last_update_login = fnd_global.login_id

2425: set overall_credit_limit = (overall_credit_limit +
2426: ( overall_credit_limit * p_reco_value2/100)),
2427: last_update_date = sysdate,
2428: last_updated_by = fnd_global.user_id,
2429: last_update_login = fnd_global.login_id
2430: WHERE cust_account_profile_id = (
2431: select cust_account_profile_id
2432: from hz_customer_profiles
2433: WHERE party_id = p_party_id

Line 2446: last_updated_by = fnd_global.user_id,

2442: UPDATE hz_cust_profile_amts
2443: set trx_credit_limit = (trx_credit_limit +
2444: ( trx_credit_limit * p_reco_value2/100)),
2445: last_update_date = sysdate,
2446: last_updated_by = fnd_global.user_id,
2447: last_update_login = fnd_global.login_id
2448: WHERE cust_account_profile_id = (
2449: select cust_account_profile_id
2450: from hz_customer_profiles

Line 2447: last_update_login = fnd_global.login_id

2443: set trx_credit_limit = (trx_credit_limit +
2444: ( trx_credit_limit * p_reco_value2/100)),
2445: last_update_date = sysdate,
2446: last_updated_by = fnd_global.user_id,
2447: last_update_login = fnd_global.login_id
2448: WHERE cust_account_profile_id = (
2449: select cust_account_profile_id
2450: from hz_customer_profiles
2451: WHERE party_id = p_party_id

Line 2461: last_updated_by = fnd_global.user_id,

2457: UPDATE hz_cust_profile_amts
2458: set trx_credit_limit = (trx_credit_limit +
2459: ( trx_credit_limit * p_reco_value2/100)),
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,
2462: last_update_login = fnd_global.login_id
2463: WHERE cust_account_profile_id = (
2464: select cust_account_profile_id
2465: from hz_customer_profiles

Line 2462: last_update_login = fnd_global.login_id

2458: set trx_credit_limit = (trx_credit_limit +
2459: ( trx_credit_limit * p_reco_value2/100)),
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,
2462: last_update_login = fnd_global.login_id
2463: WHERE cust_account_profile_id = (
2464: select cust_account_profile_id
2465: from hz_customer_profiles
2466: WHERE party_id = p_party_id

Line 2731: last_updated_by = fnd_global.user_id,

2727: transactionTypeIn => 'ARCMGTAP');
2728: Update ar_cmgt_cf_recommends
2729: set status = 'R',
2730: last_update_date = sysdate,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id
2733: WHERE case_folder_id = l_case_folder_id;
2734:
2735: Update ar_cmgt_case_folders

Line 2732: last_update_login = fnd_global.login_id

2728: Update ar_cmgt_cf_recommends
2729: set status = 'R',
2730: last_update_date = sysdate,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id
2733: WHERE case_folder_id = l_case_folder_id;
2734:
2735: Update ar_cmgt_case_folders
2736: set status = 'CLOSED',

Line 2739: last_updated_by = fnd_global.user_id,

2735: Update ar_cmgt_case_folders
2736: set status = 'CLOSED',
2737: last_updated = sysdate,
2738: last_update_date = sysdate,
2739: last_updated_by = fnd_global.user_id,
2740: last_update_login = fnd_global.login_id
2741: WHERE case_folder_id = l_case_folder_id;
2742:
2743: Update ar_cmgt_credit_requests

Line 2740: last_update_login = fnd_global.login_id

2736: set status = 'CLOSED',
2737: last_updated = sysdate,
2738: last_update_date = sysdate,
2739: last_updated_by = fnd_global.user_id,
2740: last_update_login = fnd_global.login_id
2741: WHERE case_folder_id = l_case_folder_id;
2742:
2743: Update ar_cmgt_credit_requests
2744: set status = 'PROCESSED',

Line 2746: last_updated_by = fnd_global.user_id,

2742:
2743: Update ar_cmgt_credit_requests
2744: set status = 'PROCESSED',
2745: last_update_date = sysdate,
2746: last_updated_by = fnd_global.user_id,
2747: last_update_login = fnd_global.login_id
2748: WHERE credit_request_id = itemkey;
2749:
2750: END IF;

Line 2747: last_update_login = fnd_global.login_id

2743: Update ar_cmgt_credit_requests
2744: set status = 'PROCESSED',
2745: last_update_date = sysdate,
2746: last_updated_by = fnd_global.user_id,
2747: last_update_login = fnd_global.login_id
2748: WHERE credit_request_id = itemkey;
2749:
2750: END IF;
2751: END;

Line 2894: last_updated_by = fnd_global.user_id,

2890:
2891: UPDATE AR_CMGT_CF_RECOMMENDS
2892: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
2893: last_update_date = sysdate,
2894: last_updated_by = fnd_global.user_id,
2895: last_update_login = fnd_global.login_id
2896: WHERE RECOMMENDATION_ID = l_reco_id;
2897:
2898: if (sql%notfound)

Line 2895: last_update_login = fnd_global.login_id

2891: UPDATE AR_CMGT_CF_RECOMMENDS
2892: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
2893: last_update_date = sysdate,
2894: last_updated_by = fnd_global.user_id,
2895: last_update_login = fnd_global.login_id
2896: WHERE RECOMMENDATION_ID = l_reco_id;
2897:
2898: if (sql%notfound)
2899: THEN

Line 3054: last_updated_by = fnd_global.user_id,

3050:
3051: Update ar_cmgt_cf_recommends
3052: set status = 'I',
3053: last_update_date = sysdate,
3054: last_updated_by = fnd_global.user_id,
3055: last_update_login = fnd_global.login_id
3056: WHERE case_folder_id = l_case_folder_id;
3057:
3058: Update ar_cmgt_case_folders

Line 3055: last_update_login = fnd_global.login_id

3051: Update ar_cmgt_cf_recommends
3052: set status = 'I',
3053: last_update_date = sysdate,
3054: last_updated_by = fnd_global.user_id,
3055: last_update_login = fnd_global.login_id
3056: WHERE case_folder_id = l_case_folder_id;
3057:
3058: Update ar_cmgt_case_folders
3059: set status = 'CLOSED',

Line 3062: last_updated_by = fnd_global.user_id,

3058: Update ar_cmgt_case_folders
3059: set status = 'CLOSED',
3060: last_updated = sysdate,
3061: last_update_date = sysdate,
3062: last_updated_by = fnd_global.user_id,
3063: last_update_login = fnd_global.login_id
3064: WHERE case_folder_id = l_case_folder_id;
3065:
3066: Update ar_cmgt_credit_requests

Line 3063: last_update_login = fnd_global.login_id

3059: set status = 'CLOSED',
3060: last_updated = sysdate,
3061: last_update_date = sysdate,
3062: last_updated_by = fnd_global.user_id,
3063: last_update_login = fnd_global.login_id
3064: WHERE case_folder_id = l_case_folder_id;
3065:
3066: Update ar_cmgt_credit_requests
3067: set status = 'PROCESSED',

Line 3069: last_updated_by = fnd_global.user_id,

3065:
3066: Update ar_cmgt_credit_requests
3067: set status = 'PROCESSED',
3068: last_update_date = sysdate,
3069: last_updated_by = fnd_global.user_id,
3070: last_update_login = fnd_global.login_id
3071: WHERE credit_request_id = itemkey;
3072: END IF;
3073: EXCEPTION

Line 3070: last_update_login = fnd_global.login_id

3066: Update ar_cmgt_credit_requests
3067: set status = 'PROCESSED',
3068: last_update_date = sysdate,
3069: last_updated_by = fnd_global.user_id,
3070: last_update_login = fnd_global.login_id
3071: WHERE credit_request_id = itemkey;
3072: END IF;
3073: EXCEPTION
3074: WHEN HOLD_ERROR THEN

Line 3266: last_updated_by = fnd_global.user_id,

3262: UPDATE ar_cmgt_case_folders
3263: set status = 'CREATED',
3264: last_updated = sysdate,
3265: last_update_date = sysdate,
3266: last_updated_by = fnd_global.user_id,
3267: last_update_login = fnd_global.login_id
3268: WHERE case_folder_id = l_case_folder_id;
3269:
3270: END;

Line 3267: last_update_login = fnd_global.login_id

3263: set status = 'CREATED',
3264: last_updated = sysdate,
3265: last_update_date = sysdate,
3266: last_updated_by = fnd_global.user_id,
3267: last_update_login = fnd_global.login_id
3268: WHERE case_folder_id = l_case_folder_id;
3269:
3270: END;
3271:

Line 4207: last_updated_by = fnd_global.user_id

4203: UPDATE ar_cmgt_case_folders
4204: SET request_id = l_request_id,
4205: status = 'IN_PROCESS',
4206: last_update_date = sysdate,
4207: last_updated_by = fnd_global.user_id
4208: WHERE case_folder_id = l_case_folder_id;
4209: return;
4210: ELSE
4211: resultout := 'COMPLETE:N';

Line 4352: last_updated_by = fnd_global.user_id

4348: UPDATE ar_cmgt_case_folders
4349: SET request_id = p_request_id,
4350: status = 'IN_PROCESS',
4351: last_update_date = sysdate,
4352: last_updated_by = fnd_global.user_id
4353: WHERE case_folder_id = p_case_folder_id;
4354: END IF; */
4355: END IF;
4356: EXCEPTION