APPS.AR_CMGT_WF_ENGINE dependencies on HZ_CUSTOMER_PROFILES

Line 777: hz_customer_profiles prof

773: l_profile_class_name, l_postal_code, l_state, l_party_id
774: FROM ar_cmgt_credit_requests c,
775: hz_parties p,
776: hz_cust_profile_classes profclass,
777: hz_customer_profiles prof
778: WHERE c.credit_request_id = p_credit_request_id
779: AND c.party_id = p.party_id
780: AND p.party_id = prof.party_id
781: AND c.cust_account_id = decode(prof.cust_account_id,-1,-99,prof.cust_account_id)

Line 905: FROM hz_customer_profiles a, ar_cmgt_credit_requests b

901: THEN
902: BEGIN
903: SELECT a.CREDIT_ANALYST_ID
904: INTO l_credit_analyst_id
905: FROM hz_customer_profiles a, ar_cmgt_credit_requests b
906: WHERE b.credit_request_id = itemkey
907: AND a.party_id = b.party_id
908: AND a.cust_account_id = decode(b.cust_account_id,-99,-1,b.cust_account_id)
909: AND nvl(a.site_use_id,-99) = nvl(b.site_use_id, -99);

Line 1292: l_cust_account_profile_id hz_customer_profiles.cust_account_profile_id%type;

1288:
1289: l_party_id ar_cmgt_credit_requests.party_id%type;
1290: l_cust_acct_id ar_cmgt_credit_requests.cust_account_id%type;
1291: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1292: l_cust_account_profile_id hz_customer_profiles.cust_account_profile_id%type;
1293: l_return_status VARCHAR2(1);
1294: BEGIN
1295: IF pg_wf_debug = 'Y'
1296: THEN

Line 1330: FROM hz_customer_profiles

1326:
1327: BEGIN
1328: SELECT cust_account_profile_id
1329: INTO l_cust_account_profile_id
1330: FROM hz_customer_profiles
1331: WHERE party_id = l_party_id
1332: AND cust_account_id = -1
1333: AND site_use_id IS NULL;
1334:

Line 2641: ' UPDATE hz_customer_profiles ' ||

2637: THEN
2638: IF p_site_use_id IS NULL
2639: THEN
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 '||

Line 2656: ' UPDATE hz_customer_profiles ' ||

2652: p_cust_account_id;
2653: ELSIF p_site_use_id IS NOT NULL
2654: THEN
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 '||

Line 2681: from hz_customer_profiles

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
2683: AND cust_account_id = p_cust_account_id
2684: AND site_use_id IS NULL )
2685: AND currency_code = p_reco_value1;

Line 2695: from hz_customer_profiles

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
2697: AND cust_account_id = p_cust_account_id
2698: AND site_use_id = p_site_use_id )
2699: AND currency_code = p_reco_value1;

Line 2712: from hz_customer_profiles

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
2714: AND cust_account_id = p_cust_account_id
2715: AND site_use_id IS NULL )
2716: AND currency_code = p_reco_value1;

Line 2726: from hz_customer_profiles

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
2728: AND cust_account_id = p_cust_account_id
2729: AND site_use_id = p_site_use_id )
2730: AND currency_code = p_reco_value1;

Line 2736: UPDATE hz_customer_profiles

2732: ELSIF p_credit_recommendation = 'CUST_HOLD'
2733: THEN
2734: IF p_site_use_id IS NULL
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

Line 2746: UPDATE hz_customer_profiles

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
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

Line 2760: UPDATE hz_customer_profiles

2756: ELSIF p_credit_recommendation = 'REMOVE_CUST_HOLD'
2757: THEN
2758: IF p_site_use_id IS NULL
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

Line 2770: UPDATE hz_customer_profiles

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
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

Line 2791: from hz_customer_profiles

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
2793: AND cust_account_id = p_cust_account_id
2794: AND site_use_id IS NULL )
2795: AND currency_code = p_reco_value1;

Line 2806: from hz_customer_profiles

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
2808: AND cust_account_id = p_cust_account_id
2809: AND site_use_id = p_site_use_id )
2810: AND currency_code = p_reco_value1;

Line 2824: from hz_customer_profiles

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
2826: AND cust_account_id = p_cust_account_id
2827: AND site_use_id IS NULL )
2828: AND currency_code = p_reco_value1;

Line 2839: from hz_customer_profiles

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
2841: AND cust_account_id = p_cust_account_id
2842: AND site_use_id = p_site_use_id )
2843: AND currency_code = p_reco_value1;

Line 3187: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;

3183: HOLD_ERROR EXCEPTION;
3184: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3185: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;
3186: no_data_found EXCEPTION;
3187: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;
3188: l_entity_code VARCHAR2(1);
3189: l_entity_id NUMBER;
3190: l_msg_count NUMBER;
3191:

Line 3403: UPDATE hz_customer_profiles

3399:
3400: l_last_revw_date := TRUNC(sysdate);
3401:
3402: /* 12670579 - cleaned up review cycle logic */
3403: UPDATE hz_customer_profiles
3404: SET REVIEW_CYCLE = c_reco_rec.recommendation_value1,
3405: NEXT_CREDIT_REVIEW_DATE =
3406: DECODE(c_reco_rec.recommendation_value1,
3407: 'YEARLY', (l_last_revw_date + 365),

Line 3568: FROM hz_customer_profiles

3564: INTO l_credit_limit
3565: FROM hz_cust_profile_amts hzp
3566: WHERE cust_account_profile_id = (
3567: SELECT cust_account_profile_id
3568: FROM hz_customer_profiles
3569: WHERE party_id = l_party_id
3570: AND cust_account_id = l_cust_account_id
3571: AND ( site_use_id IS NULL
3572: OR site_use_id = l_site_use_id))