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

Line 39: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);

35: where CONCURRENT_PROGRAM_NAME = 'IEX_POPULATE_UWQ_SUM';
36:
37: INSERT INTO AR_CONC_PROCESS_REQUESTS
38: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
39: values ('IEX_POPULATE_UWQ_SUM',FND_GLOBAL.conc_request_id);
40: COMMIT;
41: END insert_conc_req;
42:
43:

Line 50: if FND_GLOBAL.Conc_Request_Id is not null then

46: BEGIN
47: if (p_msg_level >= G_MSG_LEVEL) then
48:
49: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
50: if FND_GLOBAL.Conc_Request_Id is not null then
51: fnd_file.put_line(FND_FILE.LOG, p_msg);
52: end if;
53:
54: end if;

Line 688: where REQUEST_ID = FND_GLOBAL.conc_request_id;

684: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
685: l_return_status := 'E';
686: Rollback;
687: DELETE from AR_CONC_PROCESS_REQUESTS
688: where REQUEST_ID = FND_GLOBAL.conc_request_id;
689: commit;
690: if FND_GLOBAL.Conc_Request_Id is not null then
691: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
692: status => 'ERROR',

Line 690: if FND_GLOBAL.Conc_Request_Id is not null then

686: Rollback;
687: DELETE from AR_CONC_PROCESS_REQUESTS
688: where REQUEST_ID = FND_GLOBAL.conc_request_id;
689: commit;
690: if FND_GLOBAL.Conc_Request_Id is not null then
691: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
692: status => 'ERROR',
693: message => 'The process has failed. Please review log file.');
694: end if;

Line 703: where REQUEST_ID = FND_GLOBAL.conc_request_id;

699: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);
700: l_return_status := 'E';
701: Rollback;
702: DELETE from AR_CONC_PROCESS_REQUESTS
703: where REQUEST_ID = FND_GLOBAL.conc_request_id;
704: commit;
705: if FND_GLOBAL.Conc_Request_Id is not null then
706: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
707: status => 'ERROR',

Line 705: if FND_GLOBAL.Conc_Request_Id is not null then

701: Rollback;
702: DELETE from AR_CONC_PROCESS_REQUESTS
703: where REQUEST_ID = FND_GLOBAL.conc_request_id;
704: commit;
705: if FND_GLOBAL.Conc_Request_Id is not null then
706: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
707: status => 'ERROR',
708: message => 'The process has failed. Please review log file.');
709: end if;

Line 798: if FND_GLOBAL.Conc_Request_Id is not null then

794:
795: --Begin Bug 9079404 04-Nov-2009 barathsr
796:
797: if from_date is not null and l_truncate_table='Y' then
798: if FND_GLOBAL.Conc_Request_Id is not null then
799: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
800: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
801: end if;
802: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');

Line 808: if FND_GLOBAL.Conc_Request_Id is not null then

804: return;
805: end if;
806:
807: if from_date is null and l_truncate_table='N' and g_ou_lvl_enb='N' then
808: if FND_GLOBAL.Conc_Request_Id is not null then
809: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
810: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
811: end if;
812: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');

Line 1958: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

1954: AND b.status = 'OP'
1955: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
1956: AND dln.org_id = a.org_id
1957: --AND TRUNC(dln.LAST_UPDATE_DATE)>=trunc(sysdate-1) -- changed for bug 13322580
1958: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
1959: GROUP BY a.customer_site_use_id;
1960:
1961:
1962:

Line 1975: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

1971: WHERE del.customer_site_use_id = dln.site_use_id AND
1972: del.org_id = dln.org_id and
1973: del.status IN('DELINQUENT', 'PREDELINQUENT')
1974: --AND TRUNC(dln.LAST_UPDATE_DATE)>=trunc(sysdate-1) -- changed for bug 13322580
1975: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
1976: group by del.CUSTOMER_SITE_USE_ID;
1977:
1978:
1979:

Line 2004: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2000: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))
2001: and del.customer_site_use_id = dln.site_use_id
2002: and del.org_id = dln.org_id
2003: --and TRUNC(dln.LAST_UPDATE_DATE)>=TRUNC(sysdate-1) -- changed for bug 13322580
2004: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2005: GROUP BY del.customer_site_use_id;
2006:
2007: cursor c_billto_pro_summ_dt is
2008: select del.CUSTOMER_SITE_USE_ID,

Line 2021: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2017: and del.customer_site_use_id = dln.site_use_id
2018: and del.org_id = dln.org_id
2019: and pd.state = 'BROKEN_PROMISE'
2020: --AND TRUNC(dln.LAST_UPDATE_DATE)>=TRUNC(sysdate-1) -- changed for bug 13322580
2021: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2022: group by del.CUSTOMER_SITE_USE_ID;
2023:
2024:
2025: CURSOR c_billto_site_details_dt IS

Line 2059: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2055: AND summ.cust_account_id = acc.cust_account_id
2056: AND acc.party_id = party.party_id
2057: AND loc.country = fnd_terr.territory_code(+)
2058: -- AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) -- changed for bug 13322580
2059: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2060: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
2061: and party.party_id=party_pref.party_id(+)
2062: and party_pref.module(+)='COLLECTIONS'
2063: and party_pref.category(+)='COLLECTIONS LEVEL'

Line 2099: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2095: AND phone.phone_line_type NOT IN('PAGER', 'FAX')
2096: AND phone.status = 'A'
2097: AND nvl(phone.do_not_use_flag, 'N') = 'N'
2098: -- AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) -- changed for bug 13322580
2099: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2100: group by summ.party_id,
2101: phone.phone_country_code,
2102: phone.phone_area_code,
2103: phone.phone_number,

Line 2129: and temp.request_id = FND_GLOBAL.CONC_REQUEST_ID ; -- Added for bug13452739

2125: and hp.collector_id=ac.collector_id
2126: and rg.group_id (+) = ac.resource_id
2127: and rs.resource_id(+) = ac.resource_id
2128: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1); -- changed for bug 13322580
2129: and temp.request_id = FND_GLOBAL.CONC_REQUEST_ID ; -- Added for bug13452739
2130:
2131: CURSOR c_billto_ch_coll_dt_sum IS
2132: SELECT
2133: DISTINCT

Line 2148: AND ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

2144: and ac.collector_id = hp.collector_id
2145: AND ac.resource_id is NOT NULL
2146: AND ac.resource_id <> ids.collector_resource_id
2147: -- AND trunc(ids.last_update_date)>= TRUNC(SYSDATE-1); -- changed for bug 13322580
2148: AND ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
2149:
2150: cursor c_billto_last_payment_dtls_dt is
2151: select summ.site_use_id,
2152: summ.last_payment_amount last_payment_amount,

Line 2165: and summ1.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- Added for bug13452739

2161: and summ.last_payment_date=(select max(summ1.last_payment_date)
2162: from iex_dln_uwq_summary summ1
2163: where summ1.site_use_id=summ.site_use_id
2164: --and trunc(summ1.last_update_date)>= trunc(sysdate-1)); -- chnaged for bug 13322580
2165: and summ1.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- Added for bug13452739
2166:
2167:
2168: cursor c_billto_bankruptcies_dt is
2169: select summ.party_id,

Line 2176: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2172: iex_dln_uwq_summary summ
2173: where bkr.customer_site_use_id=summ.site_use_id
2174: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
2175: --AND trunc(summ.last_update_date)>=trunc(sysdate-1) --changed for bug 13322580
2176: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2177: group by summ.party_id;
2178:
2179: cursor c_billto_score_dt is
2180: SELECT sh.score_object_id,

Line 2193: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

2189: iex_dln_uwq_summary temp
2190: WHERE sh1.score_object_code = 'IEX_BILLTO'
2191: AND sh1.score_object_id = temp.site_use_id
2192: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) -- chnaged for bug 13322580
2193: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
2194: group by sh1.score_object_id,sh1.score_object_code);
2195:
2196: --End Bug 9597052 28-Apr-2010 barathsr
2197:

Line 3191: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3187: WHERE del.cust_account_id = dln.cust_account_id
3188: AND del.org_id = dln.org_id
3189: and del.status IN('DELINQUENT', 'PREDELINQUENT')
3190: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) -- changed for bug 13322580
3191: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3192: group by del.CUst_account_id,dln.org_id;
3193:
3194: cursor c_acc_pro_dtls_dt is
3195: SELECT del.cust_account_id,dln.org_id,

Line 3218: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3214: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))
3215: and dln.site_use_id is null
3216: and del.org_id = dln.org_id
3217: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3218: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3219: GROUP BY del.cust_account_id,dln.org_id;
3220:
3221: cursor c_acc_pro_summ_dt is
3222: select del.CUST_Account_ID,dln.org_id,

Line 3235: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3231: and dln.site_use_id is null
3232: and del.org_id = dln.org_id
3233: and pd.state = 'BROKEN_PROMISE'
3234: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3235: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3236: group by del.CUST_account_ID,dln.org_id;
3237:
3238:
3239: CURSOR c_acct_details_dt IS

Line 3270: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3266: and party_pref.category(+)='COLLECTIONS LEVEL'
3267: and party_pref.preference_code(+)='PARTY_ID'
3268: and summ.site_use_id is null
3269: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3270: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3271: GROUP BY party.party_id,
3272: party.party_name,
3273: summ.cust_account_id,
3274: acc.account_name,

Line 3305: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3301: AND phone.status(+) = 'A'
3302: AND nvl(phone.do_not_use_flag(+), 'N') = 'N'
3303: and summ.site_use_id is null
3304: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3305: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3306: group by summ.party_id,
3307: phone.phone_country_code,
3308: phone.phone_area_code,
3309: phone.phone_number,

Line 3338: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

3334: and rs.resource_id(+) = ac.resource_id
3335: and hp.site_use_id is null
3336: and temp.site_use_id is null
3337: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1); --changed for bug 13322580
3338: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
3339:
3340: CURSOR c_acc_ch_coll_dt_sum IS
3341: SELECT
3342: DISTINCT

Line 3359: AND ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

3355: AND ac.resource_id <> ids.collector_resource_id
3356: and hp.site_use_id is null
3357: and ids.site_use_id is null
3358: --AND trunc(ids.last_update_date)>= TRUNC(SYSDATE-1); --changed for bug 13322580
3359: AND ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
3360:
3361: cursor c_acc_last_payment_dtls_dt is
3362: select summ.cust_account_id,summ.org_id,
3363: summ.last_payment_amount last_payment_amount,

Line 3377: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- Added for bug13452739

3373: where dln.cust_account_id=summ.cust_account_id
3374: and dln.org_id=summ.org_id
3375: and dln.site_use_id is null
3376: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1)); --changed for bug 13322580
3377: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- Added for bug13452739
3378:
3379:
3380: cursor c_acc_bankruptcies_dt is
3381: select summ.party_id,summ.org_id,

Line 3388: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3384: iex_dln_uwq_summary summ
3385: where bkr.cust_account_id=summ.cust_account_id
3386: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
3387: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3388: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3389: group by summ.party_id,summ.org_id;
3390:
3391: cursor c_acc_score_dt is
3392: SELECT sh.score_object_id,

Line 3407: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

3403: WHERE sh1.score_object_code = 'IEX_ACCOUNT'
3404: AND sh1.score_object_id = temp.cust_account_id
3405: and temp.site_use_id is null
3406: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3407: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
3408: group by sh1.score_object_id,sh1.score_object_code);
3409: -------------------
3410: --Start of comment for Bug 9597052 28-Apr-2010 barathsr
3411: /* CURSOR c_iex_cu_uwq_summary(c_level varchar2,c_org_id number)--Added for Bug 8707923 27-Jul-2009 barathsr

Line 4368: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4364: AND b.status = 'OP'
4365: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
4366: AND dln.org_id = a.org_id
4367: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4368: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4369: and dln.site_use_id is null
4370: and dln.cust_account_id is null
4371: GROUP BY a.party_cust_id,dln.org_id;
4372:

Line 4387: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4383: del.status IN('DELINQUENT', 'PREDELINQUENT')
4384: and dln.site_use_id is null
4385: and dln.cust_account_id is null
4386: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4387: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4388: group by del.party_cust_id,dln.org_id;
4389:
4390: cursor c_cu_pro_dtls_dt is
4391: SELECT del.party_cust_id,dln.org_id,

Line 4414: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4410: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))
4411: and dln.site_use_id is null
4412: and dln.cust_account_id is null
4413: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4414: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4415: and del.org_id = dln.org_id
4416: GROUP BY del.party_cust_id,dln.org_id;
4417:
4418: cursor c_cu_pro_summ_dt is

Line 4431: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4427: and pd.delinquency_id = del.delinquency_id
4428: and dln.site_use_id is null
4429: and dln.cust_account_id is null
4430: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4431: AND dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4432: and del.org_id = dln.org_id
4433: and pd.state = 'BROKEN_PROMISE'
4434: group by del.party_cust_ID,dln.org_id;
4435:

Line 4466: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4462: and party_pref.module(+)='COLLECTIONS'
4463: and party_pref.category(+)='COLLECTIONS LEVEL'
4464: and party_pref.preference_code(+)='PARTY_ID'
4465: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4466: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4467: and summ.site_use_id is null
4468: and summ.cust_account_id is null
4469: GROUP BY party.party_id,
4470: party.party_name,

Line 4499: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4495: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')
4496: AND phone.status(+) = 'A'
4497: AND nvl(phone.do_not_use_flag(+), 'N') = 'N'
4498: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4499: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4500: and summ.site_use_id is null
4501: and summ.cust_account_id is null
4502: group by summ.party_id,
4503: phone.phone_country_code,

Line 4531: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4527: and ac.collector_id(+) = hp.collector_id
4528: and rg.group_id(+) = ac.resource_id
4529: and rs.resource_id(+) = ac.resource_id
4530: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4531: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4532: and hp.cust_account_id=-1
4533: and hp.site_use_id is null
4534: and temp.site_use_id is null
4535: and temp.cust_account_id is null;

Line 4558: and ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

4554: and hp.site_use_id is null
4555: and ids.cust_account_id is null
4556: and ids.site_use_id is null
4557: --AND trunc(ids.last_update_date)>= TRUNC(SYSDATE-1); --changed for bug 13322580
4558: and ids.request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
4559:
4560: cursor c_cu_last_payment_dtls_dt is
4561: select hca.party_id,summ.org_id,
4562: summ.last_payment_amount last_payment_amount,

Line 4577: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4573: from iex_dln_uwq_summary dln
4574: where dln.party_id=hca.party_id
4575: and dln.org_id=summ.org_id
4576: --AND trunc(dln.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4577: and dln.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4578: and dln.cust_account_id is null
4579: and dln.site_use_id is null);
4580:
4581:

Line 4591: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4587: where bkr.party_id=summ.party_id
4588: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
4589: and summ.site_use_id is null and summ.cust_account_id is null
4590: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4591: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4592: group by summ.party_id,summ.org_id;
4593:
4594: cursor c_cu_score_dt is
4595: SELECT sh.score_object_id,

Line 4609: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4605: iex_dln_uwq_summary temp
4606: WHERE sh1.score_object_code = 'PARTY'
4607: AND sh1.score_object_id = temp.party_id
4608: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4609: AND temp.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4610: and temp.site_use_id is null
4611: and temp.cust_account_id is null
4612: group by sh1.score_object_id,sh1.score_object_code);
4613: --End Bug 9597052 28-Apr-2010 barathsr

Line 4648: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4644: AND wkitem.status_code IN('OPEN', 'ONHOLD')
4645: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
4646: AND strat.jtf_object_id = sum.PARTY_ID
4647: --AND sum.LAST_UPDATE_DATE >= trunc(sysdate-1) --changed for bug 13322580
4648: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4649: and sum.org_id=nvl(p_org_id,sum.org_id) --Added for Bug 8707923 27-Jul-2009 barathsr
4650: and sum.business_level=p_level;--Added for Bug 8707923 27-Jul-2009 barathsr
4651:
4652: CURSOR c_strategy_summary_acct(p_level varchar2,p_from_date date,p_org_id number) --Added for Bug 8707923 27-Jul-2009 barathsr

Line 4683: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4679: AND wkitem.status_code IN('OPEN', 'ONHOLD')
4680: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
4681: AND strat.jtf_object_id = sum.CUST_ACCOUNT_ID
4682: --AND sum.LAST_UPDATE_DATE >= trunc(sysdate-1) --changed for bug 13322580
4683: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4684: and sum.org_id=nvl(p_org_id,sum.org_id) --Added for Bug 8707923 27-Jul-2009 barathsr
4685: and sum.business_level=p_level;--Added for Bug 8707923 27-Jul-2009 barathsr
4686:
4687: CURSOR c_strategy_summary_billto(p_level varchar2,p_from_date date,p_org_id number) --Added for Bug 8707923 27-Jul-2009 barathsr

Line 4718: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

4714: AND wkitem.status_code IN('OPEN', 'ONHOLD')
4715: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
4716: AND strat.jtf_object_id = sum.SITE_USE_ID
4717: --AND trunc(sum.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
4718: AND sum.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
4719: and sum.org_id=nvl(p_org_id,sum.org_id) --Added for Bug 8707923 27-Jul-2009 barathsr
4720: and sum.business_level=p_level;--Added for Bug 8707923 27-Jul-2009 barathsr
4721:
4722: --End Bug 9596144 25-May-2010 barathsr

Line 5512: FND_GLOBAL.USER_ID,

5508: L_PENDING_ADJ_VALUE(i),
5509: L_PAST_DUE_INV_INST_COUNT(i),
5510: L_LAST_PAYMENT_DATE(i),
5511: sysdate,
5512: FND_GLOBAL.USER_ID,
5513: sysdate,
5514: FND_GLOBAL.USER_ID,
5515: FND_GLOBAL.CONC_LOGIN_ID,
5516: 0,

Line 5514: FND_GLOBAL.USER_ID,

5510: L_LAST_PAYMENT_DATE(i),
5511: sysdate,
5512: FND_GLOBAL.USER_ID,
5513: sysdate,
5514: FND_GLOBAL.USER_ID,
5515: FND_GLOBAL.CONC_LOGIN_ID,
5516: 0,
5517: p_level, --Added for Bug 8707923 27-Jul-2009 barathsr
5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),

Line 5515: FND_GLOBAL.CONC_LOGIN_ID,

5511: sysdate,
5512: FND_GLOBAL.USER_ID,
5513: sysdate,
5514: FND_GLOBAL.USER_ID,
5515: FND_GLOBAL.CONC_LOGIN_ID,
5516: 0,
5517: p_level, --Added for Bug 8707923 27-Jul-2009 barathsr
5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
5519: FND_GLOBAL.CONC_PROGRAM_ID,

Line 5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),

5514: FND_GLOBAL.USER_ID,
5515: FND_GLOBAL.CONC_LOGIN_ID,
5516: 0,
5517: p_level, --Added for Bug 8707923 27-Jul-2009 barathsr
5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
5519: FND_GLOBAL.CONC_PROGRAM_ID,
5520: FND_GLOBAL.PROG_APPL_ID,
5521: 1);
5522:

Line 5519: FND_GLOBAL.CONC_PROGRAM_ID,

5515: FND_GLOBAL.CONC_LOGIN_ID,
5516: 0,
5517: p_level, --Added for Bug 8707923 27-Jul-2009 barathsr
5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
5519: FND_GLOBAL.CONC_PROGRAM_ID,
5520: FND_GLOBAL.PROG_APPL_ID,
5521: 1);
5522:
5523: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));

Line 5520: FND_GLOBAL.PROG_APPL_ID,

5516: 0,
5517: p_level, --Added for Bug 8707923 27-Jul-2009 barathsr
5518: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
5519: FND_GLOBAL.CONC_PROGRAM_ID,
5520: FND_GLOBAL.PROG_APPL_ID,
5521: 1);
5522:
5523: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
5524: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Inserted ' || L_IEU_OBJECT_FUNCTION.COUNT || ' rows');

Line 5606: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5602: COUNTRY = L_COUNTRY(i),
5603: PROVINCE = L_PROVINCE(i),
5604: POSTAL_CODE = L_POSTAL_CODE(i),
5605: LAST_UPDATE_DATE=sysdate,
5606: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5607: WHERE
5608: party_id = L_party_id(i)
5609: and org_id= L_ORG_ID(i);
5610: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cust_DETAILS updated ' || L_cust_account_id.count || ' rows ');

Line 5659: last_updated_by = FND_GLOBAL.USER_ID

5655: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
5656: PHONE_NUMBER = L_PHONE_NUMBER(i),
5657: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
5658: last_update_date = SYSDATE,
5659: last_updated_by = FND_GLOBAL.USER_ID
5660: WHERE PARTY_ID = L_PARTY_ID(i)
5661: and ORG_ID= L_ORG_ID(i);
5662: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
5663: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 5721: last_updated_by = FND_GLOBAL.USER_ID

5717: collector_id = l_collector_id(i),
5718: resource_id=l_resource_id(i),
5719: resource_type=l_resource_type(i),
5720: last_update_date = SYSDATE,
5721: last_updated_by = FND_GLOBAL.USER_ID
5722: WHERE
5723: party_id = L_party_id(i)
5724: and org_id= L_ORG_ID(i);
5725: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_COLLECTOR_PROF updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 5768: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5764: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
5765: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
5766: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
5767: LAST_UPDATE_DATE=sysdate,
5768: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5769: WHERE
5770: party_ID = L_party_ID(i)
5771: and org_id= L_ORG_ID(i);
5772: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_pro_dtls updated ' || L_party_ID.count || ' rows ');

Line 5811: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5807: UPDATE IEX_DLN_UWQ_SUMMARY
5808: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
5809: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
5810: LAST_UPDATE_DATE=sysdate,
5811: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5812: WHERE
5813: party_id = L_party_ID(i)
5814: and org_id= L_ORG_ID(i);
5815: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_del_cnt updated ' || L_party_ID.count || ' rows ');

Line 5856: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5852: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
5853: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
5854: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i),
5855: LAST_UPDATE_DATE=sysdate,
5856: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5857: WHERE
5858: party_ID = L_party_ID(i)
5859: and org_id= L_ORG_ID(i);
5860: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_deln_dtls updated ' || L_party_ID.count || ' rows ');

Line 5902: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5898: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
5899: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
5900: PENDING_PROMISES = L_PENDING_PROMISES(i),
5901: LAST_UPDATE_DATE=sysdate,
5902: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5903: WHERE
5904: party_ID = L_party_ID(i)
5905: and org_id= L_ORG_ID(i);
5906: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_pro_summ updated ' || L_party_ID.count || ' rows ');

Line 5954: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5950: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
5951: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
5952: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
5953: LAST_UPDATE_DATE=sysdate,
5954: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5955: WHERE
5956: party_ID = L_party_ID(i)
5957: and org_id= L_ORG_ID(i);
5958: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_LAST_PAYMENT_dtls updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');

Line 5996: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

5992: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
5993: UPDATE IEX_DLN_UWQ_SUMMARY
5994: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
5995: LAST_UPDATE_DATE=sysdate,
5996: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
5997: WHERE
5998: PARTY_ID = L_PARTY_ID(i)
5999: and org_id= L_ORG_ID(i);
6000: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_BANKRUPTCIES updated ' || L_PARTY_ID.count || ' rows ');

Line 6046: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6042: SET SCORE = L_SCORE(i),
6043: score_id=l_score_id(i),
6044: score_name=l_score_name(i),
6045: LAST_UPDATE_DATE=sysdate,
6046: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6047: WHERE
6048: party_ID = L_party_ID(i);
6049: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_score updated ' || L_cust_account_ID.count || ' rows ');
6050: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 6120: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6116: COUNTRY = L_COUNTRY(i),
6117: PROVINCE = L_PROVINCE(i),
6118: POSTAL_CODE = L_POSTAL_CODE(i),
6119: LAST_UPDATE_DATE=sysdate,
6120: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6121: WHERE
6122: party_id = L_party_id(i)
6123: and org_id= L_ORG_ID(i);
6124: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cust_DETAILS_dt updated ' || L_party_id.count || ' rows ');

Line 6173: last_updated_by = FND_GLOBAL.USER_ID

6169: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
6170: PHONE_NUMBER = L_PHONE_NUMBER(i),
6171: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
6172: last_update_date = SYSDATE,
6173: last_updated_by = FND_GLOBAL.USER_ID
6174: WHERE PARTY_ID = L_PARTY_ID(i)
6175: and org_id= L_ORG_ID(i);
6176: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_contact_point_dt Cursor updated ' ||L_PARTY_ID.count || ' rows ');
6177: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 6234: last_updated_by = FND_GLOBAL.USER_ID

6230: collector_id = l_collector_id(i),
6231: resource_id=l_resource_id(i),
6232: resource_type=l_resource_type(i),
6233: last_update_date = SYSDATE,
6234: last_updated_by = FND_GLOBAL.USER_ID
6235: WHERE
6236: party_id = L_party_id(i)
6237: and org_id= L_ORG_ID(i);
6238: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_COLLECTOR_PROF_dt updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 6281: last_updated_by = FND_GLOBAL.USER_ID

6277: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
6278: COLLECTOR_RES_TYPE = L_COLLECTOR_RES_TYPE(i),
6279: collector_id = l_collector_id(i),
6280: last_update_date = SYSDATE,
6281: last_updated_by = FND_GLOBAL.USER_ID
6282: WHERE
6283: party_id = L_party_ID(i)
6284: and org_id=L_ORG_ID(i);
6285: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_ch_coll_dt_sum updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 6329: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6325: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
6326: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
6327: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
6328: LAST_UPDATE_DATE=sysdate,
6329: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6330: WHERE
6331: party_ID = L_party_ID(i)
6332: and org_id=L_ORG_ID(i);
6333: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_pro_dtls_dt updated ' || L_party_ID.count || ' rows ');

Line 6372: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6368: UPDATE IEX_DLN_UWQ_SUMMARY
6369: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
6370: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
6371: LAST_UPDATE_DATE=sysdate,
6372: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6373: WHERE
6374: party_id = L_party_ID(i)
6375: and org_id=L_ORG_ID(i);
6376: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_del_cnt_dt updated ' || L_party_ID.count || ' rows ');

Line 6417: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6413: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
6414: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
6415: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i) ,
6416: LAST_UPDATE_DATE=sysdate,
6417: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6418: WHERE
6419: party_ID = L_party_ID(i)
6420: and org_id=L_ORG_ID(i);
6421: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_deln_dtls_dt updated ' || L_party_ID.count || ' rows ');

Line 6463: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6459: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
6460: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
6461: PENDING_PROMISES = L_PENDING_PROMISES(i),
6462: LAST_UPDATE_DATE=sysdate,
6463: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6464: WHERE
6465: party_ID = L_party_ID(i)
6466: and org_id=L_ORG_ID(i);
6467: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_pro_summ_dt updated ' || L_party_ID.count || ' rows ');

Line 6515: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6511: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
6512: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
6513: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
6514: LAST_UPDATE_DATE=sysdate,
6515: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6516: WHERE
6517: party_ID = L_party_ID(i)
6518: and org_id=L_ORG_ID(i);
6519: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_LAST_PAYMENT_dtls_dt updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');

Line 6557: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6553: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
6554: UPDATE IEX_DLN_UWQ_SUMMARY
6555: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
6556: LAST_UPDATE_DATE=sysdate,
6557: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6558: WHERE
6559: PARTY_ID = L_PARTY_ID(i)
6560: and org_id=L_ORG_ID(i);
6561: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cu_BANKRUPTCIES_dt updated ' || L_PARTY_ID.count || ' rows ');

Line 6607: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6603: SET SCORE = L_SCORE(i),
6604: score_id=l_score_id(i),
6605: score_name=l_score_name(i),
6606: LAST_UPDATE_DATE=sysdate,
6607: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6608: WHERE
6609: party_ID = L_party_ID(i);
6610: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_cu_score_dt updated ' || L_cust_account_ID.count || ' rows ');
6611: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 6688: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6684: COUNTRY = L_COUNTRY(i),
6685: PROVINCE = L_PROVINCE(i),
6686: POSTAL_CODE = L_POSTAL_CODE(i),
6687: LAST_UPDATE_DATE=sysdate,
6688: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6689: WHERE
6690: cust_account_id = L_cust_account_id(i)
6691: and org_id=L_ORG_ID(i);
6692: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acct_DETAILS updated ' || L_cust_account_id.count || ' rows ');

Line 6740: last_updated_by = FND_GLOBAL.USER_ID

6736: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
6737: PHONE_NUMBER = L_PHONE_NUMBER(i),
6738: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
6739: last_update_date = SYSDATE,
6740: last_updated_by = FND_GLOBAL.USER_ID
6741: WHERE PARTY_ID = L_PARTY_ID(i)
6742: and org_id=L_ORG_ID(i);
6743: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
6744: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 6801: last_updated_by = FND_GLOBAL.USER_ID

6797: collector_id = l_collector_id(i),
6798: resource_id=l_resource_id(i),
6799: resource_type=l_resource_type(i),
6800: last_update_date = SYSDATE,
6801: last_updated_by = FND_GLOBAL.USER_ID
6802: WHERE
6803: cust_account_id = L_cust_account_id(i)
6804: and org_id=L_ORG_ID(i);
6805: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_COLLECTOR_PROF updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 6848: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6844: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
6845: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
6846: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
6847: LAST_UPDATE_DATE=sysdate,
6848: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6849: WHERE
6850: cust_account_ID = L_cust_account_ID(i)
6851: and org_id=L_ORG_ID(i);
6852: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_pro_dtls updated ' || L_cust_account_ID.count || ' rows ');

Line 6891: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6887: UPDATE IEX_DLN_UWQ_SUMMARY
6888: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
6889: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
6890: LAST_UPDATE_DATE=sysdate,
6891: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6892: WHERE
6893: cust_account_id = L_cust_account_ID(i)
6894: and org_id=L_ORG_ID(i);
6895: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_del_cnt updated ' || L_cust_account_ID.count || ' rows ');

Line 6936: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6932: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
6933: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
6934: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i),
6935: LAST_UPDATE_DATE=sysdate,
6936: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6937: WHERE
6938: cust_account_ID = L_cust_account_ID(i)
6939: and org_id=L_ORG_ID(i);
6940: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_deln_dtls updated ' || L_cust_account_ID.count || ' rows ');

Line 6982: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

6978: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
6979: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
6980: PENDING_PROMISES = L_PENDING_PROMISES(i),
6981: LAST_UPDATE_DATE=sysdate,
6982: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
6983: WHERE
6984: cust_account_ID = L_cust_account_ID(i)
6985: and org_id=L_ORG_ID(i);
6986: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_pro_summ updated ' || L_cust_account_ID.count || ' rows ');

Line 7034: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7030: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
7031: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
7032: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
7033: LAST_UPDATE_DATE=sysdate,
7034: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7035: WHERE
7036: cust_account_ID = L_cust_account_ID(i)
7037: and org_id=L_ORG_ID(i);
7038: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_LAST_PAYMENT_dtls updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');

Line 7076: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7072: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
7073: UPDATE IEX_DLN_UWQ_SUMMARY
7074: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
7075: LAST_UPDATE_DATE=sysdate,
7076: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7077: WHERE
7078: PARTY_ID = L_PARTY_ID(i)
7079: and org_id=L_ORG_ID(i);
7080: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_BANKRUPTCIES updated ' || L_PARTY_ID.count || ' rows ');

Line 7126: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7122: SET SCORE = L_SCORE(i),
7123: score_id=l_score_id(i),
7124: score_name=l_score_name(i),
7125: LAST_UPDATE_DATE=sysdate,
7126: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7127: WHERE
7128: cust_account_ID = L_cust_account_ID(i);
7129: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_score updated ' || L_cust_account_ID.count || ' rows ');
7130: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7205: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7201: COUNTRY = L_COUNTRY(i),
7202: PROVINCE = L_PROVINCE(i),
7203: POSTAL_CODE = L_POSTAL_CODE(i),
7204: LAST_UPDATE_DATE=sysdate,
7205: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7206: WHERE
7207: cust_account_id = L_cust_account_id(i)
7208: and org_id=L_ORG_ID(i);
7209: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acct_DETAILS_dt updated ' || L_cust_account_id.count || ' rows ');

Line 7257: last_updated_by = FND_GLOBAL.USER_ID

7253: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
7254: PHONE_NUMBER = L_PHONE_NUMBER(i),
7255: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
7256: last_update_date = SYSDATE,
7257: last_updated_by = FND_GLOBAL.USER_ID
7258: WHERE PARTY_ID = L_PARTY_ID(i)
7259: and org_id=L_ORG_ID(i);
7260: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_contact_point_dt Cursor updated ' ||L_PARTY_ID.count || ' rows ');
7261: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7317: last_updated_by = FND_GLOBAL.USER_ID

7313: collector_id = l_collector_id(i),
7314: resource_id=l_resource_id(i),
7315: resource_type=l_resource_type(i),
7316: last_update_date = SYSDATE,
7317: last_updated_by = FND_GLOBAL.USER_ID
7318: WHERE
7319: cust_account_id = L_cust_account_id(i)
7320: and org_id=L_ORG_ID(i);
7321: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_COLLECTOR_PROF_dt updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 7365: last_updated_by = FND_GLOBAL.USER_ID

7361: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
7362: COLLECTOR_RES_TYPE = L_COLLECTOR_RES_TYPE(i),
7363: collector_id = l_collector_id(i),
7364: last_update_date = SYSDATE,
7365: last_updated_by = FND_GLOBAL.USER_ID
7366: WHERE
7367: cust_account_ID = L_cust_account_ID(i)
7368: and org_id=L_ORG_ID(i);
7369: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_ch_coll_dt_sum updated ' || L_COLLECTOR_ID.count || ' rows ');

Line 7413: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7409: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
7410: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
7411: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
7412: LAST_UPDATE_DATE=sysdate,
7413: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7414: WHERE
7415: cust_account_ID = L_cust_account_ID(i)
7416: and org_id=L_ORG_ID(i);
7417: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_pro_dtls_dt updated ' || L_cust_account_ID.count || ' rows ');

Line 7456: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7452: UPDATE IEX_DLN_UWQ_SUMMARY
7453: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
7454: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
7455: LAST_UPDATE_DATE=sysdate,
7456: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7457: WHERE
7458: cust_account_id = L_cust_account_ID(i)
7459: and org_id=L_ORG_ID(i);
7460: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_del_cnt_dt updated ' || L_cust_account_ID.count || ' rows ');

Line 7501: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7497: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
7498: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
7499: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i),
7500: LAST_UPDATE_DATE=sysdate,
7501: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7502: WHERE
7503: cust_account_ID = L_cust_account_ID(i)
7504: and org_id=L_ORG_ID(i);
7505: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_deln_dtls_dt updated ' || L_cust_account_ID.count || ' rows ');

Line 7547: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7543: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
7544: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
7545: PENDING_PROMISES = L_PENDING_PROMISES(i),
7546: LAST_UPDATE_DATE=sysdate,
7547: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7548: WHERE
7549: cust_account_ID = L_cust_account_ID(i)
7550: and org_id=L_ORG_ID(i);
7551: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_pro_summ_dt updated ' || L_cust_account_ID.count || ' rows ');

Line 7599: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7595: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
7596: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
7597: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
7598: LAST_UPDATE_DATE=sysdate,
7599: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7600: WHERE
7601: cust_account_ID = L_cust_account_ID(i)
7602: and org_id=L_ORG_ID(i);
7603: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_LAST_PAYMENT_dtls_dt updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');

Line 7641: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7637: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
7638: UPDATE IEX_DLN_UWQ_SUMMARY
7639: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
7640: LAST_UPDATE_DATE=sysdate,
7641: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7642: WHERE
7643: PARTY_ID = L_PARTY_ID(i)
7644: and org_id=L_ORG_ID(i);
7645: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_acc_BANKRUPTCIES_dt updated ' || L_PARTY_ID.count || ' rows ');

Line 7691: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7687: SET SCORE = L_SCORE(i),
7688: score_id=l_score_id(i),
7689: score_name=l_score_name(i),
7690: LAST_UPDATE_DATE=sysdate,
7691: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7692: WHERE
7693: cust_account_ID = L_cust_account_ID(i);
7694: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_acc_score_dt updated ' || L_cust_account_ID.count || ' rows ');
7695: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7772: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7768: COUNTRY = L_COUNTRY(i),
7769: PROVINCE = L_PROVINCE(i),
7770: POSTAL_CODE = L_POSTAL_CODE(i),
7771: LAST_UPDATE_DATE=sysdate,
7772: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7773: WHERE
7774: SITE_USE_ID = L_SITE_USE_ID(i);
7775: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_SITE_DETAILS updated ' || L_SITE_USE_ID.count || ' rows ');
7776: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7823: last_updated_by = FND_GLOBAL.USER_ID

7819: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
7820: PHONE_NUMBER = L_PHONE_NUMBER(i),
7821: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
7822: last_update_date = SYSDATE,
7823: last_updated_by = FND_GLOBAL.USER_ID
7824: WHERE PARTY_ID = L_PARTY_ID(i);
7825: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
7826: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
7827:

Line 7883: last_updated_by = FND_GLOBAL.USER_ID

7879: collector_id = l_collector_id(i),
7880: resource_id=l_resource_id(i),
7881: resource_type=l_resource_type(i),
7882: last_update_date = SYSDATE,
7883: last_updated_by = FND_GLOBAL.USER_ID
7884: WHERE
7885: SITE_USE_ID = L_SITE_USE_ID(i);
7886: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_COLLECTOR_PROF updated ' || L_COLLECTOR_ID.count || ' rows ');
7887: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7929: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7925: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
7926: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
7927: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
7928: LAST_UPDATE_DATE=sysdate,
7929: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7930: WHERE
7931: SITE_USE_ID = L_SITE_USE_ID(i);
7932: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_pro_dtls updated ' || L_SITE_USE_ID.count || ' rows ');
7933: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 7971: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

7967: UPDATE IEX_DLN_UWQ_SUMMARY
7968: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
7969: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
7970: LAST_UPDATE_DATE=sysdate,
7971: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
7972: WHERE
7973: SITE_USE_ID = L_SITE_USE_ID(i);
7974: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_del_cnt updated ' || L_SITE_USE_ID.count || ' rows ');
7975: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8015: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8011: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
8012: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
8013: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i),
8014: LAST_UPDATE_DATE=sysdate,
8015: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8016: WHERE
8017: SITE_USE_ID = L_SITE_USE_ID(i);
8018: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_del_dln updated ' || L_SITE_USE_ID.count || ' rows ');
8019: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8060: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8056: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
8057: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
8058: PENDING_PROMISES = L_PENDING_PROMISES(i),
8059: LAST_UPDATE_DATE=sysdate,
8060: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8061: WHERE
8062: SITE_USE_ID = L_SITE_USE_ID(i);
8063: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_pro_summ updated ' || L_SITE_USE_ID.count || ' rows ');
8064: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8111: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8107: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
8108: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
8109: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
8110: LAST_UPDATE_DATE=sysdate,
8111: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8112: WHERE
8113: SITE_USE_ID = L_SITE_USE_ID(i);
8114: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_LAST_PAYMENT_AMOUNT updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');
8115: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8152: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8148: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
8149: UPDATE IEX_DLN_UWQ_SUMMARY
8150: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
8151: LAST_UPDATE_DATE=sysdate,
8152: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8153: WHERE
8154: PARTY_ID = L_PARTY_ID(i);
8155: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_BANKRUPTCIES updated ' || L_PARTY_ID.count || ' rows ');
8156: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8201: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8197: SET SCORE = L_SCORE(i),
8198: score_id=l_score_id(i),
8199: score_name=l_score_name(i),
8200: LAST_UPDATE_DATE=sysdate,
8201: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8202: WHERE
8203: SITE_USE_ID = L_SITE_USE_ID(i);
8204: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_score updated ' || L_SITE_USE_ID.count || ' rows ');
8205: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8280: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8276: COUNTRY = L_COUNTRY(i),
8277: PROVINCE = L_PROVINCE(i),
8278: POSTAL_CODE = L_POSTAL_CODE(i),
8279: LAST_UPDATE_DATE=sysdate,
8280: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8281: WHERE
8282: SITE_USE_ID = L_SITE_USE_ID(i);
8283: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_SITE_DETAILS_dt updated ' || L_SITE_USE_ID.count || ' rows ');
8284: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8331: last_updated_by = FND_GLOBAL.USER_ID

8327: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
8328: PHONE_NUMBER = L_PHONE_NUMBER(i),
8329: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
8330: last_update_date = SYSDATE,
8331: last_updated_by = FND_GLOBAL.USER_ID
8332: WHERE PARTY_ID = L_PARTY_ID(i);
8333: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_contact_point_dt Cursor updated ' ||L_PARTY_ID.count || ' rows ');
8334: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
8335:

Line 8390: last_updated_by = FND_GLOBAL.USER_ID

8386: collector_id = l_collector_id(i),
8387: resource_id=l_resource_id(i),
8388: resource_type=l_resource_type(i),
8389: last_update_date = SYSDATE,
8390: last_updated_by = FND_GLOBAL.USER_ID
8391: WHERE
8392: SITE_USE_ID = L_SITE_USE_ID(i);
8393: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_COLLECTOR_PROF_dt updated ' || L_COLLECTOR_ID.count || ' rows ');
8394: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8436: last_updated_by = FND_GLOBAL.USER_ID

8432: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
8433: COLLECTOR_RES_TYPE = L_COLLECTOR_RES_TYPE(i),
8434: collector_id = l_collector_id(i),
8435: last_update_date = SYSDATE,
8436: last_updated_by = FND_GLOBAL.USER_ID
8437: WHERE
8438: SITE_USE_ID = L_SITE_USE_ID(i);
8439: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_ch_coll_dt_sum updated ' || L_COLLECTOR_ID.count || ' rows ');
8440: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8482: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8478: SET NUMBER_OF_PROMISES = L_NUMBER_OF_PROMISES(i),
8479: BROKEN_PROMISE_AMOUNT = L_BROKEN_PROMISE_AMOUNT(i),
8480: PROMISE_AMOUNT = L_PROMISE_AMOUNT(i),
8481: LAST_UPDATE_DATE=sysdate,
8482: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8483: WHERE
8484: SITE_USE_ID = L_SITE_USE_ID(i);
8485: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_pro_dtls_dt updated ' || L_SITE_USE_ID.count || ' rows ');
8486: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8524: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8520: UPDATE IEX_DLN_UWQ_SUMMARY
8521: SET NUMBER_OF_DELINQUENCIES = L_NUMBER_OF_DELINQUENCIES(i),
8522: PAST_DUE_INV_VALUE = L_PAST_DUE_INV_VALUE(i),
8523: LAST_UPDATE_DATE=sysdate,
8524: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8525: WHERE
8526: SITE_USE_ID = L_SITE_USE_ID(i);
8527: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_deln_cnt_dt updated ' || L_SITE_USE_ID.count || ' rows ');
8528: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8568: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8564: SET PENDING_DELINQUENCIES = L_PENDING_DELINQUENCIES(i),
8565: COMPLETE_DELINQUENCIES = L_COMPLETE_DELINQUENCIES(i),
8566: ACTIVE_DELINQUENCIES = L_ACTIVE_DELINQUENCIES(i),
8567: LAST_UPDATE_DATE=sysdate,
8568: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8569: WHERE
8570: SITE_USE_ID = L_SITE_USE_ID(i);
8571: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_DELN_DTLS_dt ' || L_SITE_USE_ID.count || ' rows ');
8572: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8613: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8609: SET ACTIVE_PROMISES = L_ACTIVE_PROMISES(i),
8610: COMPLETE_PROMISES = L_COMPLETE_PROMISES(i),
8611: PENDING_PROMISES = L_PENDING_PROMISES(i),
8612: LAST_UPDATE_DATE=sysdate,
8613: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8614: WHERE
8615: SITE_USE_ID = L_SITE_USE_ID(i);
8616: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_PRO_SUMM_dt updated ' || L_SITE_USE_ID.count || ' rows ');
8617: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8664: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8660: -- sysdate,iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), L_LAST_PAYMENT_AMOUNT(i)),
8661: LAST_PAYMENT_AMOUNT_CURR = L_LAST_PAYMENT_AMOUNT_CURR(i),
8662: LAST_PAYMENT_NUMBER = L_LAST_PAYMENT_NUMBER(i),
8663: LAST_UPDATE_DATE=sysdate,
8664: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8665: WHERE
8666: SITE_USE_ID = L_SITE_USE_ID(i);
8667: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_LAST_PAYMENT_dtls_dt updated ' || L_LAST_PAYMENT_AMOUNT.count || ' rows ');
8668: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8705: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8701: forall i IN L_PARTY_ID.FIRST .. L_PARTY_ID.LAST
8702: UPDATE IEX_DLN_UWQ_SUMMARY
8703: SET NUMBER_OF_BANKRUPTCIES = L_NUMBER_OF_BANKRUPTCIES(i),
8704: LAST_UPDATE_DATE=sysdate,
8705: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8706: WHERE
8707: PARTY_ID = L_PARTY_ID(i);
8708: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_BILLTO_BANKRUPTCIES_dt updated ' || L_PARTY_ID.count || ' rows ');
8709: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8754: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8750: SET SCORE = L_SCORE(i),
8751: score_id=l_score_id(i),
8752: score_name=l_score_name(i),
8753: LAST_UPDATE_DATE=sysdate,
8754: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8755: WHERE
8756: SITE_USE_ID = L_SITE_USE_ID(i);
8757: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_billto_score_dt updated ' || L_SITE_USE_ID.count || ' rows ');
8758: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 8873: LAST_UPDATED_BY=FND_GLOBAL.USER_ID--Added for bug#6981126 by schekuri on 27-Jun-2008

8869: END_TIME = L_END_TIME(i),
8870: WORK_ITEM_ORDER = L_WORK_ITEM_ORDER(i),
8871: WKITEM_ESCALATED_YN = L_ESCALATED_YN(i),
8872: LAST_UPDATE_DATE=sysdate,
8873: LAST_UPDATED_BY=FND_GLOBAL.USER_ID--Added for bug#6981126 by schekuri on 27-Jun-2008
8874: WHERE PARTY_ID = L_JTF_OBJECT_ID(i);
8875: end if;
8876: end loop;
8877:

Line 8961: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

8957: END_TIME = L_END_TIME(i),
8958: WORK_ITEM_ORDER = L_WORK_ITEM_ORDER(i),
8959: WKITEM_ESCALATED_YN = L_ESCALATED_YN(i),--Added for bug#6981126 by schekuri on 27-Jun-2008
8960: LAST_UPDATE_DATE=sysdate,
8961: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
8962: WHERE CUST_ACCOUNT_ID = L_JTF_OBJECT_ID(i);
8963: end if;
8964: end loop;
8965:

Line 9049: LAST_UPDATED_BY=FND_GLOBAL.USER_ID

9045: END_TIME = L_END_TIME(i),
9046: WORK_ITEM_ORDER = L_WORK_ITEM_ORDER(i),
9047: WKITEM_ESCALATED_YN = L_ESCALATED_YN(i),--Added for bug#6981126 by schekuri on 27-Jun-2008
9048: LAST_UPDATE_DATE=sysdate,
9049: LAST_UPDATED_BY=FND_GLOBAL.USER_ID
9050: WHERE SITE_USE_ID = L_JTF_OBJECT_ID(i);
9051:
9052: END IF;
9053: end loop;

Line 9134: last_updated_by = FND_GLOBAL.USER_ID

9130: country = L_COUNTRY(i),
9131: province = L_PROVINCE(i),
9132: postal_code = L_POSTAL_CODE(i),
9133: last_update_date = SYSDATE,
9134: last_updated_by = FND_GLOBAL.USER_ID
9135: WHERE PARTY_ID = L_PARTY_ID(i);
9136: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_Party Cursor updated ' ||L_PARTY_ID.count || ' rows ');
9137: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
9138: COMMIT;

Line 9194: last_updated_by = FND_GLOBAL.USER_ID

9190: country = L_COUNTRY(i),
9191: province = L_PROVINCE(i),
9192: postal_code = L_POSTAL_CODE(i),
9193: last_update_date = SYSDATE,
9194: last_updated_by = FND_GLOBAL.USER_ID
9195: WHERE site_use_id= L_site_use_ID(i);
9196:
9197: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_billto_sites Cursor updated ' ||L_SITE_USE_ID.count || ' rows ');
9198: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 9253: last_updated_by = FND_GLOBAL.USER_ID

9249: COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i), -- Added for 15906302
9250: COLLECTOR_RESOURCE_NAME = L_COLLECTOR_RESOURCE_NAME(i), -- Added for 15906302
9251: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),-- Added for 15906302
9252: last_update_date = SYSDATE,
9253: last_updated_by = FND_GLOBAL.USER_ID
9254: WHERE
9255: PARTY_ID = L_PARTY_ID(i)
9256: AND nvl(CUST_ACCOUNT_ID,1) = nvl(L_CUST_ACCOUNT_ID(i),1)
9257: AND nvl(SITE_USE_ID,1) = nvl(L_SITE_USE_ID(i),1);

Line 9302: last_updated_by = FND_GLOBAL.USER_ID

9298: SET COLLECTOR_RESOURCE_ID = L_COLLECTOR_RESOURCE_ID(i),
9299: COLLECTOR_RESOURCE_NAME = L_COLLECTOR_RESOURCE_NAME(i), -- Added for the bug#7562130
9300: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
9301: last_update_date = SYSDATE,
9302: last_updated_by = FND_GLOBAL.USER_ID
9303: WHERE
9304: COLLECTOR_ID = L_COLLECTOR_ID(i);
9305: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_collector updated ' || L_COLLECTOR_ID.count || ' rows ');
9306: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 9356: last_updated_by = FND_GLOBAL.USER_ID

9352: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
9353: PHONE_NUMBER = L_PHONE_NUMBER(i),
9354: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
9355: last_update_date = SYSDATE,
9356: last_updated_by = FND_GLOBAL.USER_ID
9357: WHERE PARTY_ID = L_PARTY_ID(i);
9358: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Changed_contact Cursor updated ' ||L_PARTY_ID.count || ' rows ');
9359: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
9360:

Line 9419: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;

9415: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Updated contracts info in Table IEX_DLN_UWQ_SUMMARY at time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
9416: end if;
9417: -- End for bug#8261043
9418: DELETE from AR_CONC_PROCESS_REQUESTS
9419: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;
9420: COMMIT;
9421:
9422:
9423: EXCEPTION

Line 9466: where REQUEST_ID = FND_GLOBAL.conc_request_id;

9462:
9463: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
9464: Rollback;
9465: DELETE from AR_CONC_PROCESS_REQUESTS
9466: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9467: commit;
9468:
9469: if FND_GLOBAL.Conc_Request_Id is not null then
9470: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 9469: if FND_GLOBAL.Conc_Request_Id is not null then

9465: DELETE from AR_CONC_PROCESS_REQUESTS
9466: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9467: commit;
9468:
9469: if FND_GLOBAL.Conc_Request_Id is not null then
9470: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
9471: status => 'ERROR',
9472: message => 'The process has failed. Please review log file.');
9473: end if;

Line 9517: where REQUEST_ID = FND_GLOBAL.conc_request_id;

9513:
9514: -- End - Andre Araujo - 10/20/06 - Added dynamic sql
9515: Rollback;
9516: DELETE from AR_CONC_PROCESS_REQUESTS
9517: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9518: commit;
9519:
9520: if FND_GLOBAL.Conc_Request_Id is not null then
9521: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 9520: if FND_GLOBAL.Conc_Request_Id is not null then

9516: DELETE from AR_CONC_PROCESS_REQUESTS
9517: where REQUEST_ID = FND_GLOBAL.conc_request_id;
9518: commit;
9519:
9520: if FND_GLOBAL.Conc_Request_Id is not null then
9521: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
9522: status => 'ERROR',
9523: message => 'The process has failed. Please review log file.');
9524: end if;

Line 10338: FND_GLOBAL.USER_ID,

10334: L_PAST_DUE_INV_INST_COUNT(i),
10335: L_LAST_PAYMENT_DATE(i),
10336: L_LAST_PAYMENT_AMOUNT_CURR(i),
10337: sysdate,
10338: FND_GLOBAL.USER_ID,
10339: sysdate,
10340: FND_GLOBAL.USER_ID,
10341: FND_GLOBAL.CONC_LOGIN_ID,
10342: L_ADDRESS1(i),

Line 10340: FND_GLOBAL.USER_ID,

10336: L_LAST_PAYMENT_AMOUNT_CURR(i),
10337: sysdate,
10338: FND_GLOBAL.USER_ID,
10339: sysdate,
10340: FND_GLOBAL.USER_ID,
10341: FND_GLOBAL.CONC_LOGIN_ID,
10342: L_ADDRESS1(i),
10343: L_CITY(i),
10344: L_STATE(i),

Line 10341: FND_GLOBAL.CONC_LOGIN_ID,

10337: sysdate,
10338: FND_GLOBAL.USER_ID,
10339: sysdate,
10340: FND_GLOBAL.USER_ID,
10341: FND_GLOBAL.CONC_LOGIN_ID,
10342: L_ADDRESS1(i),
10343: L_CITY(i),
10344: L_STATE(i),
10345: L_COUNTY(i),

Line 10353: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),

10349: 0,
10350: 0,
10351: 0,
10352: 'BILL_TO', --Added for Bug 8707923 27-Jul-2009 barathsr
10353: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
10354: FND_GLOBAL.CONC_PROGRAM_ID,
10355: FND_GLOBAL.PROG_APPL_ID,
10356: 1);
10357:

Line 10354: FND_GLOBAL.CONC_PROGRAM_ID,

10350: 0,
10351: 0,
10352: 'BILL_TO', --Added for Bug 8707923 27-Jul-2009 barathsr
10353: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
10354: FND_GLOBAL.CONC_PROGRAM_ID,
10355: FND_GLOBAL.PROG_APPL_ID,
10356: 1);
10357:
10358: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));

Line 10355: FND_GLOBAL.PROG_APPL_ID,

10351: 0,
10352: 'BILL_TO', --Added for Bug 8707923 27-Jul-2009 barathsr
10353: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
10354: FND_GLOBAL.CONC_PROGRAM_ID,
10355: FND_GLOBAL.PROG_APPL_ID,
10356: 1);
10357:
10358: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
10359: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Inserted ' || L_IEU_OBJECT_FUNCTION.COUNT || ' rows for business lvl-->'||p_level);

Line 10506: last_updated_by = FND_GLOBAL.USER_ID

10502: COLLECTOR_RESOURCE_NAME = L_COLLECTOR_RESOURCE_NAME(i), -- Added for the bug#7562130
10503: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
10504: collector_id = l_collector_id(i),
10505: last_update_date = SYSDATE,
10506: last_updated_by = FND_GLOBAL.USER_ID
10507: WHERE
10508: SITE_USE_ID = L_SITE_USE_ID(i);
10509: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_COLLECTOR_PROF updated ' || L_COLLECTOR_ID.count || ' rows ');
10510: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 10559: last_updated_by = FND_GLOBAL.USER_ID

10555: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
10556: PHONE_NUMBER = L_PHONE_NUMBER(i),
10557: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
10558: last_update_date = SYSDATE,
10559: last_updated_by = FND_GLOBAL.USER_ID
10560: WHERE PARTY_ID = L_PARTY_ID(i);
10561: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
10562: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
10563:

Line 11655: FND_GLOBAL.USER_ID,

11651: L_PAST_DUE_INV_INST_COUNT(i),
11652: L_LAST_PAYMENT_DATE(i),
11653: L_LAST_PAYMENT_AMOUNT_CURR(i),
11654: sysdate,
11655: FND_GLOBAL.USER_ID,
11656: sysdate,
11657: FND_GLOBAL.USER_ID,
11658: FND_GLOBAL.CONC_LOGIN_ID,
11659: L_ADDRESS1(i),

Line 11657: FND_GLOBAL.USER_ID,

11653: L_LAST_PAYMENT_AMOUNT_CURR(i),
11654: sysdate,
11655: FND_GLOBAL.USER_ID,
11656: sysdate,
11657: FND_GLOBAL.USER_ID,
11658: FND_GLOBAL.CONC_LOGIN_ID,
11659: L_ADDRESS1(i),
11660: L_CITY(i),
11661: L_STATE(i),

Line 11658: FND_GLOBAL.CONC_LOGIN_ID,

11654: sysdate,
11655: FND_GLOBAL.USER_ID,
11656: sysdate,
11657: FND_GLOBAL.USER_ID,
11658: FND_GLOBAL.CONC_LOGIN_ID,
11659: L_ADDRESS1(i),
11660: L_CITY(i),
11661: L_STATE(i),
11662: L_COUNTY(i),

Line 11670: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),

11666: 0,
11667: 0,
11668: 0,
11669: 'ACCOUNT', --Added for Bug 8707923 27-Jul-2009 barathsr
11670: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
11671: FND_GLOBAL.CONC_PROGRAM_ID,
11672: FND_GLOBAL.PROG_APPL_ID,
11673: 1);
11674:

Line 11671: FND_GLOBAL.CONC_PROGRAM_ID,

11667: 0,
11668: 0,
11669: 'ACCOUNT', --Added for Bug 8707923 27-Jul-2009 barathsr
11670: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
11671: FND_GLOBAL.CONC_PROGRAM_ID,
11672: FND_GLOBAL.PROG_APPL_ID,
11673: 1);
11674:
11675: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));

Line 11672: FND_GLOBAL.PROG_APPL_ID,

11668: 0,
11669: 'ACCOUNT', --Added for Bug 8707923 27-Jul-2009 barathsr
11670: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
11671: FND_GLOBAL.CONC_PROGRAM_ID,
11672: FND_GLOBAL.PROG_APPL_ID,
11673: 1);
11674:
11675: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
11676: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Inserted ' || L_IEU_OBJECT_FUNCTION.COUNT || ' rows at biz lvl-->'||p_level);

Line 11824: last_updated_by = FND_GLOBAL.USER_ID

11820: COLLECTOR_RESOURCE_NAME = L_COLLECTOR_RESOURCE_NAME(i), -- Added for the bug#7562130
11821: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
11822: collector_id = l_collector_id(i),
11823: last_update_date = SYSDATE,
11824: last_updated_by = FND_GLOBAL.USER_ID
11825: WHERE
11826: CUST_ACCOUNT_ID = L_CUST_ACCOUNT_ID(i);
11827: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_collector_prof updated ' || L_COLLECTOR_ID.count || ' rows ');
11828: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 11877: last_updated_by = FND_GLOBAL.USER_ID

11873: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
11874: PHONE_NUMBER = L_PHONE_NUMBER(i),
11875: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
11876: last_update_date = SYSDATE,
11877: last_updated_by = FND_GLOBAL.USER_ID
11878: WHERE PARTY_ID = L_PARTY_ID(i);
11879: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' Contact point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
11880: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
11881:

Line 12962: FND_GLOBAL.USER_ID,

12958: L_PAST_DUE_INV_INST_COUNT(i),
12959: L_LAST_PAYMENT_DATE(i),
12960: L_LAST_PAYMENT_AMOUNT_CURR(i),
12961: sysdate,
12962: FND_GLOBAL.USER_ID,
12963: sysdate,
12964: FND_GLOBAL.USER_ID,
12965: FND_GLOBAL.CONC_LOGIN_ID,
12966: L_ADDRESS1(i),

Line 12964: FND_GLOBAL.USER_ID,

12960: L_LAST_PAYMENT_AMOUNT_CURR(i),
12961: sysdate,
12962: FND_GLOBAL.USER_ID,
12963: sysdate,
12964: FND_GLOBAL.USER_ID,
12965: FND_GLOBAL.CONC_LOGIN_ID,
12966: L_ADDRESS1(i),
12967: L_CITY(i),
12968: L_STATE(i),

Line 12965: FND_GLOBAL.CONC_LOGIN_ID,

12961: sysdate,
12962: FND_GLOBAL.USER_ID,
12963: sysdate,
12964: FND_GLOBAL.USER_ID,
12965: FND_GLOBAL.CONC_LOGIN_ID,
12966: L_ADDRESS1(i),
12967: L_CITY(i),
12968: L_STATE(i),
12969: L_COUNTY(i),

Line 12977: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),

12973: 0,
12974: 0,
12975: 0,
12976: 'CUSTOMER', --Added for Bug 8707923 27-Jul-2009 barathsr
12977: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
12978: FND_GLOBAL.CONC_PROGRAM_ID,
12979: FND_GLOBAL.PROG_APPL_ID,
12980: 1);
12981:

Line 12978: FND_GLOBAL.CONC_PROGRAM_ID,

12974: 0,
12975: 0,
12976: 'CUSTOMER', --Added for Bug 8707923 27-Jul-2009 barathsr
12977: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
12978: FND_GLOBAL.CONC_PROGRAM_ID,
12979: FND_GLOBAL.PROG_APPL_ID,
12980: 1);
12981:
12982: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));

Line 12979: FND_GLOBAL.PROG_APPL_ID,

12975: 0,
12976: 'CUSTOMER', --Added for Bug 8707923 27-Jul-2009 barathsr
12977: nvl(FND_GLOBAL.Conc_REQUEST_ID,0),
12978: FND_GLOBAL.CONC_PROGRAM_ID,
12979: FND_GLOBAL.PROG_APPL_ID,
12980: 1);
12981:
12982: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
12983: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Inserted ' || L_IEU_OBJECT_FUNCTION.COUNT || ' rows for biz lvl-->'||p_level);

Line 13128: last_updated_by = FND_GLOBAL.USER_ID

13124: COLLECTOR_RESOURCE_NAME = L_COLLECTOR_RESOURCE_NAME(i) , -- Added for the bug#7562130
13125: COLLECTOR_RES_TYPE = L_RESOURCE_TYPE(i),
13126: collector_id = l_collector_id(i),
13127: last_update_date = SYSDATE,
13128: last_updated_by = FND_GLOBAL.USER_ID
13129: WHERE
13130: party_id = L_PARTY_ID(i);
13131: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_collector_prof updated ' || L_COLLECTOR_ID.count || ' rows ');
13132: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');

Line 13179: last_updated_by = FND_GLOBAL.USER_ID

13175: PHONE_AREA_CODE = L_PHONE_AREA_CODE(i),
13176: PHONE_NUMBER = L_PHONE_NUMBER(i),
13177: PHONE_EXTENSION = L_PHONE_EXTENSION(i),
13178: last_update_date = SYSDATE,
13179: last_updated_by = FND_GLOBAL.USER_ID
13180: WHERE PARTY_ID = L_PARTY_ID(i);
13181: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' c_contact_point Cursor updated ' ||L_PARTY_ID.count || ' rows ');
13182: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
13183:

Line 13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;

13544: --l_org_id:=mo_global.get_current_org_id;
13545: select org_id
13546: into l_org_id
13547: from fnd_concurrent_requests
13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;
13549:
13550: if l_org_id is null then
13551: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
13552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

Line 13787: AND request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

13783: FROM iex_dln_uwq_summary
13784: where org_id=p_org_id
13785: -- AND last_update_date >= nvl( p_from_date, last_update_date);
13786: --AND last_update_date >= trunc(sysdate-1); -- changed for bug 13322580 pnaveenk if program runs on next day
13787: AND request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
13788:
13789:
13790:
13791: Begin

Line 14078: where request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

14074:
14075: CURSOR c_contract_summary(p_org_id number) IS
14076: select party_id
14077: FROM iex_dln_uwq_summary
14078: where request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739
14079: --last_update_date >= trunc(sysdate-1) --changed for bug 13322580
14080: and org_id= p_org_id;
14081: type l_count is table of number index by binary_integer;
14082: l_cases_count l_count;

Line 14163: AND request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739

14159: FROM iex_dln_uwq_summary
14160: where org_id= p_org_id
14161: -- AND last_update_date >= nvl( p_from_date, last_update_date);
14162: --AND last_update_date >= trunc(sysdate-1); -- chnaged for bug 13322580
14163: AND request_id = FND_GLOBAL.CONC_REQUEST_ID; -- Added for bug13452739
14164: l_party_id number_list;
14165: l_cust_acct_id number_list;
14166: l_site_use_id number_list;
14167: l_org_id number_list;