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 552: last_updated_by = fnd_global.user_id,

548: IF funcmode <> 'TRANSFER' THEN
549: UPDATE ar_cmgt_credit_requests
550: set credit_analyst_id = l_resource_id,
551: last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.login_id
554: WHERE credit_request_id = itemkey
555: AND credit_analyst_id IS NULL;
556:

Line 553: last_update_login = fnd_global.login_id

549: UPDATE ar_cmgt_credit_requests
550: set credit_analyst_id = l_resource_id,
551: last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.login_id
554: WHERE credit_request_id = itemkey
555: AND credit_analyst_id IS NULL;
556:
557: UPDATE ar_cmgt_case_folders

Line 561: last_updated_by = fnd_global.user_id,

557: UPDATE ar_cmgt_case_folders
558: set credit_analyst_id = l_resource_id,
559: last_updated = sysdate,
560: last_update_date = sysdate,
561: last_updated_by = fnd_global.user_id,
562: last_update_login = fnd_global.login_id
563: WHERE credit_request_id = itemkey
564: AND credit_analyst_id IS NULL;
565: END IF;

Line 562: last_update_login = fnd_global.login_id

558: set credit_analyst_id = l_resource_id,
559: last_updated = sysdate,
560: last_update_date = sysdate,
561: last_updated_by = fnd_global.user_id,
562: last_update_login = fnd_global.login_id
563: WHERE credit_request_id = itemkey
564: AND credit_analyst_id IS NULL;
565: END IF;
566:

Line 971: last_updated_by = fnd_global.user_id,

967:
968: UPDATE ar_cmgt_credit_requests
969: SET credit_analyst_id = l_credit_analyst_id,
970: last_update_date = sysdate,
971: last_updated_by = fnd_global.user_id,
972: last_update_login = fnd_global.login_id
973: WHERE credit_request_id = itemkey;
974:
975:

Line 972: last_update_login = fnd_global.login_id

968: UPDATE ar_cmgt_credit_requests
969: SET credit_analyst_id = l_credit_analyst_id,
970: last_update_date = sysdate,
971: last_updated_by = fnd_global.user_id,
972: last_update_login = fnd_global.login_id
973: WHERE credit_request_id = itemkey;
974:
975:
976: WF_ENGINE.setItemAttrText(itemType => 'ARCMGTAP',

Line 1001: last_updated_by = fnd_global.user_id,

997: update ar_cmgt_case_folders
998: set credit_analyst_id = l_credit_analyst_id,
999: last_updated = sysdate,
1000: last_update_date = sysdate,
1001: last_updated_by = fnd_global.user_id,
1002: last_update_login = fnd_global.login_id
1003: WHERE case_folder_id = l_case_folder_id;
1004:
1005: -- Also upadate data records with credit_analyst_id

Line 1002: last_update_login = fnd_global.login_id

998: set credit_analyst_id = l_credit_analyst_id,
999: last_updated = sysdate,
1000: last_update_date = sysdate,
1001: last_updated_by = fnd_global.user_id,
1002: last_update_login = fnd_global.login_id
1003: WHERE case_folder_id = l_case_folder_id;
1004:
1005: -- Also upadate data records with credit_analyst_id
1006: update ar_cmgt_case_folders

Line 1010: last_updated_by = fnd_global.user_id,

1006: update ar_cmgt_case_folders
1007: set credit_analyst_id = l_credit_analyst_id,
1008: last_updated = sysdate,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,
1011: last_update_login = fnd_global.login_id
1012: WHERE credit_request_id = itemkey
1013: AND type = 'DATA';
1014: END IF;

Line 1011: last_update_login = fnd_global.login_id

1007: set credit_analyst_id = l_credit_analyst_id,
1008: last_updated = sysdate,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,
1011: last_update_login = fnd_global.login_id
1012: WHERE credit_request_id = itemkey
1013: AND type = 'DATA';
1014: END IF;
1015: resultout := 'COMPLETE:SUCESS';

Line 1189: last_updated_by = fnd_global.user_id,

1185: THEN
1186: UPDATE ar_cmgt_credit_requests
1187: SET status = 'IN_PROCESS',
1188: last_update_date = sysdate,
1189: last_updated_by = fnd_global.user_id,
1190: last_update_login = fnd_global.login_id
1191: WHERE credit_request_id = itemkey;
1192:
1193: END IF;

Line 1190: last_update_login = fnd_global.login_id

1186: UPDATE ar_cmgt_credit_requests
1187: SET status = 'IN_PROCESS',
1188: last_update_date = sysdate,
1189: last_updated_by = fnd_global.user_id,
1190: last_update_login = fnd_global.login_id
1191: WHERE credit_request_id = itemkey;
1192:
1193: END IF;
1194:

Line 1211: last_updated_by = fnd_global.user_id,

1207: THEN
1208: UPDATE ar_cmgt_credit_requests
1209: SET status = 'SUBMIT',
1210: last_update_date = sysdate,
1211: last_updated_by = fnd_global.user_id,
1212: last_update_login = fnd_global.login_id
1213: WHERE credit_request_id = itemkey;
1214:
1215: END IF;

Line 1212: last_update_login = fnd_global.login_id

1208: UPDATE ar_cmgt_credit_requests
1209: SET status = 'SUBMIT',
1210: last_update_date = sysdate,
1211: last_updated_by = fnd_global.user_id,
1212: last_update_login = fnd_global.login_id
1213: WHERE credit_request_id = itemkey;
1214:
1215: END IF;
1216:

Line 1241: last_updated_by = fnd_global.user_id,

1237: UPDATE ar_cmgt_case_folders
1238: SET status = 'SUBMITTED',
1239: last_updated = sysdate,
1240: last_update_date = sysdate,
1241: last_updated_by = fnd_global.user_id,
1242: last_update_login = fnd_global.login_id
1243: WHERE case_folder_id = l_case_folder_id;
1244:
1245: END IF;

Line 1242: last_update_login = fnd_global.login_id

1238: SET status = 'SUBMITTED',
1239: last_updated = sysdate,
1240: last_update_date = sysdate,
1241: last_updated_by = fnd_global.user_id,
1242: last_update_login = fnd_global.login_id
1243: WHERE case_folder_id = l_case_folder_id;
1244:
1245: END IF;
1246:

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

2640: l_sql_statement :=
2641: ' UPDATE hz_customer_profiles ' ||
2642: ' set credit_classification = :1 ,'||
2643: ' last_update_date = sysdate ,'||
2644: ' last_updated_by = fnd_global.user_id, '||
2645: ' last_update_login = fnd_global.login_id '||
2646: ' where party_id = :2 '||
2647: ' and cust_account_id = :3 '||
2648: ' and site_use_id IS NULL' ;

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

2641: ' UPDATE hz_customer_profiles ' ||
2642: ' set credit_classification = :1 ,'||
2643: ' last_update_date = sysdate ,'||
2644: ' last_updated_by = fnd_global.user_id, '||
2645: ' last_update_login = fnd_global.login_id '||
2646: ' where party_id = :2 '||
2647: ' and cust_account_id = :3 '||
2648: ' and site_use_id IS NULL' ;
2649: EXECUTE IMMEDIATE l_sql_statement using

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

2655: l_sql_statement :=
2656: ' UPDATE hz_customer_profiles ' ||
2657: ' set credit_classification = :1, '||
2658: ' last_update_date = sysdate ,'||
2659: ' last_updated_by = fnd_global.user_id, '||
2660: ' last_update_login = fnd_global.login_id '||
2661: ' where party_id = :2 '||
2662: ' and cust_account_id = :3 '||
2663: ' and site_use_id = :4 ';

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

2656: ' UPDATE hz_customer_profiles ' ||
2657: ' set credit_classification = :1, '||
2658: ' last_update_date = sysdate ,'||
2659: ' last_updated_by = fnd_global.user_id, '||
2660: ' last_update_login = fnd_global.login_id '||
2661: ' where party_id = :2 '||
2662: ' and cust_account_id = :3 '||
2663: ' and site_use_id = :4 ';
2664: EXECUTE IMMEDIATE l_sql_statement using

Line 2677: last_updated_by = fnd_global.user_id,

2673: THEN
2674: UPDATE hz_cust_profile_amts
2675: set trx_credit_limit = p_reco_value2,
2676: last_update_date = sysdate,
2677: last_updated_by = fnd_global.user_id,
2678: last_update_login = fnd_global.login_id
2679: WHERE cust_account_profile_id = (
2680: select cust_account_profile_id
2681: from hz_customer_profiles

Line 2678: last_update_login = fnd_global.login_id

2674: UPDATE hz_cust_profile_amts
2675: set trx_credit_limit = p_reco_value2,
2676: last_update_date = sysdate,
2677: last_updated_by = fnd_global.user_id,
2678: last_update_login = fnd_global.login_id
2679: WHERE cust_account_profile_id = (
2680: select cust_account_profile_id
2681: from hz_customer_profiles
2682: WHERE party_id = p_party_id

Line 2691: last_updated_by = fnd_global.user_id,

2687: THEN
2688: UPDATE hz_cust_profile_amts
2689: set trx_credit_limit = p_reco_value2,
2690: last_update_date = sysdate,
2691: last_updated_by = fnd_global.user_id,
2692: last_update_login = fnd_global.login_id
2693: WHERE cust_account_profile_id = (
2694: select cust_account_profile_id
2695: from hz_customer_profiles

Line 2692: last_update_login = fnd_global.login_id

2688: UPDATE hz_cust_profile_amts
2689: set trx_credit_limit = p_reco_value2,
2690: last_update_date = sysdate,
2691: last_updated_by = fnd_global.user_id,
2692: last_update_login = fnd_global.login_id
2693: WHERE cust_account_profile_id = (
2694: select cust_account_profile_id
2695: from hz_customer_profiles
2696: WHERE party_id = p_party_id

Line 2708: last_updated_by = fnd_global.user_id,

2704: THEN
2705: UPDATE hz_cust_profile_amts
2706: set overall_credit_limit = p_reco_value2,
2707: last_update_date = sysdate,
2708: last_updated_by = fnd_global.user_id,
2709: last_update_login = fnd_global.login_id
2710: WHERE cust_account_profile_id = (
2711: select cust_account_profile_id
2712: from hz_customer_profiles

Line 2709: last_update_login = fnd_global.login_id

2705: UPDATE hz_cust_profile_amts
2706: set overall_credit_limit = p_reco_value2,
2707: last_update_date = sysdate,
2708: last_updated_by = fnd_global.user_id,
2709: last_update_login = fnd_global.login_id
2710: WHERE cust_account_profile_id = (
2711: select cust_account_profile_id
2712: from hz_customer_profiles
2713: WHERE party_id = p_party_id

Line 2722: last_updated_by = fnd_global.user_id,

2718: THEN
2719: UPDATE hz_cust_profile_amts
2720: set overall_credit_limit = p_reco_value2,
2721: last_update_date = sysdate,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_login = fnd_global.login_id
2724: WHERE cust_account_profile_id = (
2725: select cust_account_profile_id
2726: from hz_customer_profiles

Line 2723: last_update_login = fnd_global.login_id

2719: UPDATE hz_cust_profile_amts
2720: set overall_credit_limit = p_reco_value2,
2721: last_update_date = sysdate,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_login = fnd_global.login_id
2724: WHERE cust_account_profile_id = (
2725: select cust_account_profile_id
2726: from hz_customer_profiles
2727: WHERE party_id = p_party_id

Line 2739: last_updated_by = fnd_global.user_id,

2735: THEN
2736: UPDATE hz_customer_profiles
2737: set credit_hold = 'Y',
2738: last_update_date = sysdate,
2739: last_updated_by = fnd_global.user_id,
2740: last_update_login = fnd_global.login_id
2741: WHERE party_id = p_party_id
2742: AND cust_account_id = p_cust_account_id
2743: AND site_use_id IS NULL;

Line 2740: last_update_login = fnd_global.login_id

2736: UPDATE hz_customer_profiles
2737: set credit_hold = 'Y',
2738: last_update_date = sysdate,
2739: last_updated_by = fnd_global.user_id,
2740: last_update_login = fnd_global.login_id
2741: WHERE party_id = p_party_id
2742: AND cust_account_id = p_cust_account_id
2743: AND site_use_id IS NULL;
2744: ELSIF p_site_use_id IS NOT NULL

Line 2749: last_updated_by = fnd_global.user_id,

2745: THEN
2746: UPDATE hz_customer_profiles
2747: set credit_hold = 'Y',
2748: last_update_date = sysdate,
2749: last_updated_by = fnd_global.user_id,
2750: last_update_login = fnd_global.login_id
2751: WHERE party_id = p_party_id
2752: AND cust_account_id = p_cust_account_id
2753: AND site_use_id = p_site_use_id;

Line 2750: last_update_login = fnd_global.login_id

2746: UPDATE hz_customer_profiles
2747: set credit_hold = 'Y',
2748: last_update_date = sysdate,
2749: last_updated_by = fnd_global.user_id,
2750: last_update_login = fnd_global.login_id
2751: WHERE party_id = p_party_id
2752: AND cust_account_id = p_cust_account_id
2753: AND site_use_id = p_site_use_id;
2754: END IF;

Line 2763: last_updated_by = fnd_global.user_id,

2759: THEN
2760: UPDATE hz_customer_profiles
2761: set credit_hold = 'N',
2762: last_update_date = sysdate,
2763: last_updated_by = fnd_global.user_id,
2764: last_update_login = fnd_global.login_id
2765: WHERE party_id = p_party_id
2766: AND cust_account_id = p_cust_account_id
2767: AND site_use_id IS NULL;

Line 2764: last_update_login = fnd_global.login_id

2760: UPDATE hz_customer_profiles
2761: set credit_hold = 'N',
2762: last_update_date = sysdate,
2763: last_updated_by = fnd_global.user_id,
2764: last_update_login = fnd_global.login_id
2765: WHERE party_id = p_party_id
2766: AND cust_account_id = p_cust_account_id
2767: AND site_use_id IS NULL;
2768: ELSIF p_site_use_id IS NOT NULL

Line 2773: last_updated_by = fnd_global.user_id,

2769: THEN
2770: UPDATE hz_customer_profiles
2771: set credit_hold = 'N',
2772: last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id
2775: WHERE party_id = p_party_id
2776: AND cust_account_id = p_cust_account_id
2777: AND site_use_id = p_site_use_id;

Line 2774: last_update_login = fnd_global.login_id

2770: UPDATE hz_customer_profiles
2771: set credit_hold = 'N',
2772: last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id
2775: WHERE party_id = p_party_id
2776: AND cust_account_id = p_cust_account_id
2777: AND site_use_id = p_site_use_id;
2778: END IF;

Line 2787: last_updated_by = fnd_global.user_id,

2783: UPDATE hz_cust_profile_amts
2784: set overall_credit_limit = (overall_credit_limit +
2785: ( overall_credit_limit * p_reco_value2/100)),
2786: last_update_date = sysdate,
2787: last_updated_by = fnd_global.user_id,
2788: last_update_login = fnd_global.login_id
2789: WHERE cust_account_profile_id = (
2790: select cust_account_profile_id
2791: from hz_customer_profiles

Line 2788: last_update_login = fnd_global.login_id

2784: set overall_credit_limit = (overall_credit_limit +
2785: ( overall_credit_limit * p_reco_value2/100)),
2786: last_update_date = sysdate,
2787: last_updated_by = fnd_global.user_id,
2788: last_update_login = fnd_global.login_id
2789: WHERE cust_account_profile_id = (
2790: select cust_account_profile_id
2791: from hz_customer_profiles
2792: WHERE party_id = p_party_id

Line 2802: last_updated_by = fnd_global.user_id,

2798: UPDATE hz_cust_profile_amts
2799: set overall_credit_limit = (overall_credit_limit +
2800: ( overall_credit_limit * p_reco_value2/100)),
2801: last_update_date = sysdate,
2802: last_updated_by = fnd_global.user_id,
2803: last_update_login = fnd_global.login_id
2804: WHERE cust_account_profile_id = (
2805: select cust_account_profile_id
2806: from hz_customer_profiles

Line 2803: last_update_login = fnd_global.login_id

2799: set overall_credit_limit = (overall_credit_limit +
2800: ( overall_credit_limit * p_reco_value2/100)),
2801: last_update_date = sysdate,
2802: last_updated_by = fnd_global.user_id,
2803: last_update_login = fnd_global.login_id
2804: WHERE cust_account_profile_id = (
2805: select cust_account_profile_id
2806: from hz_customer_profiles
2807: WHERE party_id = p_party_id

Line 2820: last_updated_by = fnd_global.user_id,

2816: UPDATE hz_cust_profile_amts
2817: set trx_credit_limit = (trx_credit_limit +
2818: ( trx_credit_limit * p_reco_value2/100)),
2819: last_update_date = sysdate,
2820: last_updated_by = fnd_global.user_id,
2821: last_update_login = fnd_global.login_id
2822: WHERE cust_account_profile_id = (
2823: select cust_account_profile_id
2824: from hz_customer_profiles

Line 2821: last_update_login = fnd_global.login_id

2817: set trx_credit_limit = (trx_credit_limit +
2818: ( trx_credit_limit * p_reco_value2/100)),
2819: last_update_date = sysdate,
2820: last_updated_by = fnd_global.user_id,
2821: last_update_login = fnd_global.login_id
2822: WHERE cust_account_profile_id = (
2823: select cust_account_profile_id
2824: from hz_customer_profiles
2825: WHERE party_id = p_party_id

Line 2835: last_updated_by = fnd_global.user_id,

2831: UPDATE hz_cust_profile_amts
2832: set trx_credit_limit = (trx_credit_limit +
2833: ( trx_credit_limit * p_reco_value2/100)),
2834: last_update_date = sysdate,
2835: last_updated_by = fnd_global.user_id,
2836: last_update_login = fnd_global.login_id
2837: WHERE cust_account_profile_id = (
2838: select cust_account_profile_id
2839: from hz_customer_profiles

Line 2836: last_update_login = fnd_global.login_id

2832: set trx_credit_limit = (trx_credit_limit +
2833: ( trx_credit_limit * p_reco_value2/100)),
2834: last_update_date = sysdate,
2835: last_updated_by = fnd_global.user_id,
2836: last_update_login = fnd_global.login_id
2837: WHERE cust_account_profile_id = (
2838: select cust_account_profile_id
2839: from hz_customer_profiles
2840: WHERE party_id = p_party_id

Line 3147: last_updated_by = fnd_global.user_id,

3143: transactionTypeIn => 'ARCMGTAP');
3144: Update ar_cmgt_cf_recommends
3145: set status = 'R',
3146: last_update_date = sysdate,
3147: last_updated_by = fnd_global.user_id,
3148: last_update_login = fnd_global.login_id
3149: WHERE case_folder_id = l_case_folder_id;
3150:
3151: Update ar_cmgt_case_folders

Line 3148: last_update_login = fnd_global.login_id

3144: Update ar_cmgt_cf_recommends
3145: set status = 'R',
3146: last_update_date = sysdate,
3147: last_updated_by = fnd_global.user_id,
3148: last_update_login = fnd_global.login_id
3149: WHERE case_folder_id = l_case_folder_id;
3150:
3151: Update ar_cmgt_case_folders
3152: set status = 'CLOSED',

Line 3155: last_updated_by = fnd_global.user_id,

3151: Update ar_cmgt_case_folders
3152: set status = 'CLOSED',
3153: last_updated = sysdate,
3154: last_update_date = sysdate,
3155: last_updated_by = fnd_global.user_id,
3156: last_update_login = fnd_global.login_id
3157: WHERE case_folder_id = l_case_folder_id;
3158:
3159: Update ar_cmgt_credit_requests

Line 3156: last_update_login = fnd_global.login_id

3152: set status = 'CLOSED',
3153: last_updated = sysdate,
3154: last_update_date = sysdate,
3155: last_updated_by = fnd_global.user_id,
3156: last_update_login = fnd_global.login_id
3157: WHERE case_folder_id = l_case_folder_id;
3158:
3159: Update ar_cmgt_credit_requests
3160: set status = 'PROCESSED',

Line 3162: last_updated_by = fnd_global.user_id,

3158:
3159: Update ar_cmgt_credit_requests
3160: set status = 'PROCESSED',
3161: last_update_date = sysdate,
3162: last_updated_by = fnd_global.user_id,
3163: last_update_login = fnd_global.login_id
3164: WHERE credit_request_id = itemkey;
3165:
3166: END IF;

Line 3163: last_update_login = fnd_global.login_id

3159: Update ar_cmgt_credit_requests
3160: set status = 'PROCESSED',
3161: last_update_date = sysdate,
3162: last_updated_by = fnd_global.user_id,
3163: last_update_login = fnd_global.login_id
3164: WHERE credit_request_id = itemkey;
3165:
3166: END IF;
3167: END;

Line 3379: last_updated_by = fnd_global.user_id,

3375:
3376: UPDATE AR_CMGT_CF_RECOMMENDS
3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
3378: last_update_date = sysdate,
3379: last_updated_by = fnd_global.user_id,
3380: last_update_login = fnd_global.login_id
3381: WHERE RECOMMENDATION_ID = l_reco_id;
3382:
3383: if (sql%notfound)

Line 3380: last_update_login = fnd_global.login_id

3376: UPDATE AR_CMGT_CF_RECOMMENDS
3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
3378: last_update_date = sysdate,
3379: last_updated_by = fnd_global.user_id,
3380: last_update_login = fnd_global.login_id
3381: WHERE RECOMMENDATION_ID = l_reco_id;
3382:
3383: if (sql%notfound)
3384: THEN

Line 3415: last_updated_by = fnd_global.user_id,

3411: 'WEEKLY', (l_last_revw_date + 7),
3412: l_last_revw_date + 1),
3413: LAST_CREDIT_REVIEW_DATE = l_last_revw_date,
3414: last_update_date = sysdate,
3415: last_updated_by = fnd_global.user_id,
3416: last_update_login = fnd_global.login_id
3417: WHERE party_id = l_party_id
3418: AND cust_account_id = l_cust_account_id
3419: AND ((l_site_use_id IS NULL AND site_use_id IS NULL) OR

Line 3416: last_update_login = fnd_global.login_id

3412: l_last_revw_date + 1),
3413: LAST_CREDIT_REVIEW_DATE = l_last_revw_date,
3414: last_update_date = sysdate,
3415: last_updated_by = fnd_global.user_id,
3416: last_update_login = fnd_global.login_id
3417: WHERE party_id = l_party_id
3418: AND cust_account_id = l_cust_account_id
3419: AND ((l_site_use_id IS NULL AND site_use_id IS NULL) OR
3420: site_use_id = l_site_use_id);

Line 3434: last_updated_by = fnd_global.user_id,

3430:
3431: Update ar_cmgt_cf_recommends
3432: set status = 'I',
3433: last_update_date = sysdate,
3434: last_updated_by = fnd_global.user_id,
3435: last_update_login = fnd_global.login_id
3436: WHERE case_folder_id = l_case_folder_id;
3437:
3438: Update ar_cmgt_case_folders

Line 3435: last_update_login = fnd_global.login_id

3431: Update ar_cmgt_cf_recommends
3432: set status = 'I',
3433: last_update_date = sysdate,
3434: last_updated_by = fnd_global.user_id,
3435: last_update_login = fnd_global.login_id
3436: WHERE case_folder_id = l_case_folder_id;
3437:
3438: Update ar_cmgt_case_folders
3439: set status = 'CLOSED',

Line 3442: last_updated_by = fnd_global.user_id,

3438: Update ar_cmgt_case_folders
3439: set status = 'CLOSED',
3440: last_updated = sysdate,
3441: last_update_date = sysdate,
3442: last_updated_by = fnd_global.user_id,
3443: last_update_login = fnd_global.login_id
3444: WHERE case_folder_id = l_case_folder_id;
3445:
3446: Update ar_cmgt_credit_requests

Line 3443: last_update_login = fnd_global.login_id

3439: set status = 'CLOSED',
3440: last_updated = sysdate,
3441: last_update_date = sysdate,
3442: last_updated_by = fnd_global.user_id,
3443: last_update_login = fnd_global.login_id
3444: WHERE case_folder_id = l_case_folder_id;
3445:
3446: Update ar_cmgt_credit_requests
3447: set status = 'PROCESSED',

Line 3449: last_updated_by = fnd_global.user_id,

3445:
3446: Update ar_cmgt_credit_requests
3447: set status = 'PROCESSED',
3448: last_update_date = sysdate,
3449: last_updated_by = fnd_global.user_id,
3450: last_update_login = fnd_global.login_id
3451: WHERE credit_request_id = itemkey;
3452: END IF;
3453:

Line 3450: last_update_login = fnd_global.login_id

3446: Update ar_cmgt_credit_requests
3447: set status = 'PROCESSED',
3448: last_update_date = sysdate,
3449: last_updated_by = fnd_global.user_id,
3450: last_update_login = fnd_global.login_id
3451: WHERE credit_request_id = itemkey;
3452: END IF;
3453:
3454: IF pg_wf_debug = 'Y'

Line 3696: last_updated_by = fnd_global.user_id,

3692: UPDATE ar_cmgt_case_folders
3693: set status = 'CREATED',
3694: last_updated = sysdate,
3695: last_update_date = sysdate,
3696: last_updated_by = fnd_global.user_id,
3697: last_update_login = fnd_global.login_id
3698: WHERE case_folder_id = l_case_folder_id;
3699:
3700: END;

Line 3697: last_update_login = fnd_global.login_id

3693: set status = 'CREATED',
3694: last_updated = sysdate,
3695: last_update_date = sysdate,
3696: last_updated_by = fnd_global.user_id,
3697: last_update_login = fnd_global.login_id
3698: WHERE case_folder_id = l_case_folder_id;
3699:
3700: END;
3701:

Line 4716: last_updated_by = fnd_global.user_id,

4712: UPDATE ar_cmgt_case_folders
4713: SET request_id = l_request_id,
4714: status = 'IN_PROCESS',
4715: last_update_date = sysdate,
4716: last_updated_by = fnd_global.user_id,
4717: last_update_login = fnd_global.login_id
4718: WHERE case_folder_id = l_case_folder_id;
4719: return;
4720: ELSE

Line 4717: last_update_login = fnd_global.login_id

4713: SET request_id = l_request_id,
4714: status = 'IN_PROCESS',
4715: last_update_date = sysdate,
4716: last_updated_by = fnd_global.user_id,
4717: last_update_login = fnd_global.login_id
4718: WHERE case_folder_id = l_case_folder_id;
4719: return;
4720: ELSE
4721: resultout := 'COMPLETE:N';

Line 4862: last_updated_by = fnd_global.user_id

4858: UPDATE ar_cmgt_case_folders
4859: SET request_id = p_request_id,
4860: status = 'IN_PROCESS',
4861: last_update_date = sysdate,
4862: last_updated_by = fnd_global.user_id
4863: WHERE case_folder_id = p_case_folder_id;
4864: END IF; */
4865: END IF;
4866: EXCEPTION