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.HZ_CUSTOMER_INT dependencies on HZ_UTILITY_V2PUB

Line 2174: g_created_by := hz_utility_v2pub.created_by;

2170: +===========================================================================*/
2171:
2172: PROCEDURE reset_who IS
2173: BEGIN
2174: g_created_by := hz_utility_v2pub.created_by;
2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;

Line 2175: g_last_update_login := hz_utility_v2pub.last_update_login;

2171:
2172: PROCEDURE reset_who IS
2173: BEGIN
2174: g_created_by := hz_utility_v2pub.created_by;
2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;
2179: g_program_id := hz_utility_v2pub.program_id;

Line 2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;

2172: PROCEDURE reset_who IS
2173: BEGIN
2174: g_created_by := hz_utility_v2pub.created_by;
2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;
2179: g_program_id := hz_utility_v2pub.program_id;
2180: END reset_who;

Line 2177: g_request_id := hz_utility_v2pub.request_id;

2173: BEGIN
2174: g_created_by := hz_utility_v2pub.created_by;
2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;
2179: g_program_id := hz_utility_v2pub.program_id;
2180: END reset_who;
2181:

Line 2178: g_program_application_id := hz_utility_v2pub.program_application_id;

2174: g_created_by := hz_utility_v2pub.created_by;
2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;
2179: g_program_id := hz_utility_v2pub.program_id;
2180: END reset_who;
2181:
2182: /*===========================================================================+

Line 2179: g_program_id := hz_utility_v2pub.program_id;

2175: g_last_update_login := hz_utility_v2pub.last_update_login;
2176: g_last_updated_by := hz_utility_v2pub.last_updated_by;
2177: g_request_id := hz_utility_v2pub.request_id;
2178: g_program_application_id := hz_utility_v2pub.program_application_id;
2179: g_program_id := hz_utility_v2pub.program_id;
2180: END reset_who;
2181:
2182: /*===========================================================================+
2183: | PROCEDURE

Line 3120: last_update_login = hz_utility_v2pub.last_update_login,

3116: fetch pflag into l_acct_site_id,l_site_use_id;
3117: IF pflag%FOUND THEN
3118: update hz_cust_site_uses_all
3119: set primary_flag = 'N',
3120: last_update_login = hz_utility_v2pub.last_update_login,
3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,
3123: request_id = hz_utility_v2pub.request_id,
3124: program_application_id = hz_utility_v2pub.program_application_id,

Line 3122: last_updated_by = hz_utility_v2pub.last_updated_by,

3118: update hz_cust_site_uses_all
3119: set primary_flag = 'N',
3120: last_update_login = hz_utility_v2pub.last_update_login,
3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,
3123: request_id = hz_utility_v2pub.request_id,
3124: program_application_id = hz_utility_v2pub.program_application_id,
3125: program_id = hz_utility_v2pub.program_id
3126: where site_use_id = l_site_use_id;

Line 3123: request_id = hz_utility_v2pub.request_id,

3119: set primary_flag = 'N',
3120: last_update_login = hz_utility_v2pub.last_update_login,
3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,
3123: request_id = hz_utility_v2pub.request_id,
3124: program_application_id = hz_utility_v2pub.program_application_id,
3125: program_id = hz_utility_v2pub.program_id
3126: where site_use_id = l_site_use_id;
3127:

Line 3124: program_application_id = hz_utility_v2pub.program_application_id,

3120: last_update_login = hz_utility_v2pub.last_update_login,
3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,
3123: request_id = hz_utility_v2pub.request_id,
3124: program_application_id = hz_utility_v2pub.program_application_id,
3125: program_id = hz_utility_v2pub.program_id
3126: where site_use_id = l_site_use_id;
3127:
3128: update hz_cust_acct_sites_all

Line 3125: program_id = hz_utility_v2pub.program_id

3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,
3123: request_id = hz_utility_v2pub.request_id,
3124: program_application_id = hz_utility_v2pub.program_application_id,
3125: program_id = hz_utility_v2pub.program_id
3126: where site_use_id = l_site_use_id;
3127:
3128: update hz_cust_acct_sites_all
3129: set BILL_TO_FLAG = decode(p_site_use_code,'BILL_TO','Y',BILL_TO_FLAG),

Line 3132: last_update_login = hz_utility_v2pub.last_update_login,

3128: update hz_cust_acct_sites_all
3129: set BILL_TO_FLAG = decode(p_site_use_code,'BILL_TO','Y',BILL_TO_FLAG),
3130: SHIP_TO_FLAG = decode(p_site_use_code,'SHIP_TO','Y',SHIP_TO_FLAG),
3131: MARKET_FLAG = decode(p_site_use_code,'MARKET','Y',MARKET_FLAG),
3132: last_update_login = hz_utility_v2pub.last_update_login,
3133: last_update_date = SYSDATE,
3134: last_updated_by = hz_utility_v2pub.last_updated_by,
3135: request_id = hz_utility_v2pub.request_id,
3136: program_application_id = hz_utility_v2pub.program_application_id,

Line 3134: last_updated_by = hz_utility_v2pub.last_updated_by,

3130: SHIP_TO_FLAG = decode(p_site_use_code,'SHIP_TO','Y',SHIP_TO_FLAG),
3131: MARKET_FLAG = decode(p_site_use_code,'MARKET','Y',MARKET_FLAG),
3132: last_update_login = hz_utility_v2pub.last_update_login,
3133: last_update_date = SYSDATE,
3134: last_updated_by = hz_utility_v2pub.last_updated_by,
3135: request_id = hz_utility_v2pub.request_id,
3136: program_application_id = hz_utility_v2pub.program_application_id,
3137: program_id = hz_utility_v2pub.program_id
3138: where cust_acct_site_id = l_acct_site_id;

Line 3135: request_id = hz_utility_v2pub.request_id,

3131: MARKET_FLAG = decode(p_site_use_code,'MARKET','Y',MARKET_FLAG),
3132: last_update_login = hz_utility_v2pub.last_update_login,
3133: last_update_date = SYSDATE,
3134: last_updated_by = hz_utility_v2pub.last_updated_by,
3135: request_id = hz_utility_v2pub.request_id,
3136: program_application_id = hz_utility_v2pub.program_application_id,
3137: program_id = hz_utility_v2pub.program_id
3138: where cust_acct_site_id = l_acct_site_id;
3139:

Line 3136: program_application_id = hz_utility_v2pub.program_application_id,

3132: last_update_login = hz_utility_v2pub.last_update_login,
3133: last_update_date = SYSDATE,
3134: last_updated_by = hz_utility_v2pub.last_updated_by,
3135: request_id = hz_utility_v2pub.request_id,
3136: program_application_id = hz_utility_v2pub.program_application_id,
3137: program_id = hz_utility_v2pub.program_id
3138: where cust_acct_site_id = l_acct_site_id;
3139:
3140: END IF;

Line 3137: program_id = hz_utility_v2pub.program_id

3133: last_update_date = SYSDATE,
3134: last_updated_by = hz_utility_v2pub.last_updated_by,
3135: request_id = hz_utility_v2pub.request_id,
3136: program_application_id = hz_utility_v2pub.program_application_id,
3137: program_id = hz_utility_v2pub.program_id
3138: where cust_acct_site_id = l_acct_site_id;
3139:
3140: END IF;
3141: close pflag;

Line 3196: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,

3192: PTP.REP_REGISTRATION_NUMBER = PTY.TAX_REFERENCE,
3193: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3194: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3195: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3196: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3197: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3198: PTP.REQUEST_ID = p_request_id,
3199: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3200: WHEN NOT MATCHED THEN

Line 3197: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,

3193: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3194: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3195: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3196: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3197: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3198: PTP.REQUEST_ID = p_request_id,
3199: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3200: WHEN NOT MATCHED THEN
3201: INSERT (PARTY_TYPE_CODE,

Line 3226: hz_utility_v2pub.program_id,

3222: PTY.CREATED_BY,
3223: PTY.LAST_UPDATE_DATE,
3224: PTY.LAST_UPDATED_BY,
3225: PTY.LAST_UPDATE_LOGIN,
3226: hz_utility_v2pub.program_id,
3227: hz_utility_v2pub.program_application_id,
3228: p_request_id,
3229: 1,
3230: PTY.COUNTRY_CODE );--4742586

Line 3227: hz_utility_v2pub.program_application_id,

3223: PTY.LAST_UPDATE_DATE,
3224: PTY.LAST_UPDATED_BY,
3225: PTY.LAST_UPDATE_LOGIN,
3226: hz_utility_v2pub.program_id,
3227: hz_utility_v2pub.program_application_id,
3228: p_request_id,
3229: 1,
3230: PTY.COUNTRY_CODE );--4742586
3231:

Line 3266: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,

3262: PTP.REP_REGISTRATION_NUMBER = PTY.TAX_REFERENCE,
3263: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3264: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3265: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3266: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3267: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3268: PTP.REQUEST_ID = p_request_id,
3269: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3270: WHEN NOT MATCHED THEN

Line 3267: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,

3263: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3264: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3265: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3266: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3267: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3268: PTP.REQUEST_ID = p_request_id,
3269: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3270: WHEN NOT MATCHED THEN
3271: INSERT (PARTY_TYPE_CODE,

Line 3296: hz_utility_v2pub.program_id,

3292: PTY.CREATED_BY,
3293: PTY.LAST_UPDATE_DATE,
3294: PTY.LAST_UPDATED_BY,
3295: PTY.LAST_UPDATE_LOGIN,
3296: hz_utility_v2pub.program_id,
3297: hz_utility_v2pub.program_application_id,
3298: p_request_id,
3299: 1,
3300: PTY.COUNTRY_CODE );

Line 3297: hz_utility_v2pub.program_application_id,

3293: PTY.LAST_UPDATE_DATE,
3294: PTY.LAST_UPDATED_BY,
3295: PTY.LAST_UPDATE_LOGIN,
3296: hz_utility_v2pub.program_id,
3297: hz_utility_v2pub.program_application_id,
3298: p_request_id,
3299: 1,
3300: PTY.COUNTRY_CODE );
3301:

Line 3337: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,

3333: UPDATE SET
3334: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3335: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3336: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3337: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3338: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3339: PTP.REQUEST_ID = p_request_id,
3340: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3341: WHEN NOT MATCHED THEN

Line 3338: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,

3334: PTP.LAST_UPDATE_DATE=PTY.LAST_UPDATE_DATE,
3335: PTP.LAST_UPDATED_BY=PTY.LAST_UPDATED_BY,
3336: PTP.LAST_UPDATE_LOGIN=PTY.LAST_UPDATE_LOGIN,
3337: PTP.PROGRAM_ID = hz_utility_v2pub.program_id,
3338: PTP.PROGRAM_APPLICATION_ID = hz_utility_v2pub.program_application_id,
3339: PTP.REQUEST_ID = p_request_id,
3340: PTP.OBJECT_VERSION_NUMBER = PTP.OBJECT_VERSION_NUMBER +1
3341: WHEN NOT MATCHED THEN
3342: INSERT (

Line 3369: hz_utility_v2pub.program_id,

3365: PTY.CREATED_BY,
3366: PTY.LAST_UPDATE_DATE,
3367: PTY.LAST_UPDATED_BY,
3368: PTY.LAST_UPDATE_LOGIN,
3369: hz_utility_v2pub.program_id,
3370: hz_utility_v2pub.program_application_id,
3371: p_request_id,
3372: 1,
3373: PTY.COUNTRY_CODE);--4742586

Line 3370: hz_utility_v2pub.program_application_id,

3366: PTY.LAST_UPDATE_DATE,
3367: PTY.LAST_UPDATED_BY,
3368: PTY.LAST_UPDATE_LOGIN,
3369: hz_utility_v2pub.program_id,
3370: hz_utility_v2pub.program_application_id,
3371: p_request_id,
3372: 1,
3373: PTY.COUNTRY_CODE);--4742586
3374: --COMMIT;

Line 3424: ,hz_utility_v2pub.created_by -- CREATED_BY

3420: ,'' -- OWNER_TABLE_ID
3421: ,1 -- OBJECT_VERSION_NUMBER
3422: ,'CUST_INTERFACE' -- CREATED_BY_MODULE
3423: ,'' -- APPLICATION_ID
3424: ,hz_utility_v2pub.created_by -- CREATED_BY
3425: , SYSDATE -- CREATION_DATE
3426: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3427: , SYSDATE -- LAST_UPDATE_DATE
3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY

Line 3426: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN

3422: ,'CUST_INTERFACE' -- CREATED_BY_MODULE
3423: ,'' -- APPLICATION_ID
3424: ,hz_utility_v2pub.created_by -- CREATED_BY
3425: , SYSDATE -- CREATION_DATE
3426: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3427: , SYSDATE -- LAST_UPDATE_DATE
3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3429: ,p_request_id -- REQUEST_ID
3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID

Line 3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY

3424: ,hz_utility_v2pub.created_by -- CREATED_BY
3425: , SYSDATE -- CREATION_DATE
3426: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3427: , SYSDATE -- LAST_UPDATE_DATE
3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3429: ,p_request_id -- REQUEST_ID
3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID
3431: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3432: from ra_customers_interface rci,

Line 3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID

3426: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3427: , SYSDATE -- LAST_UPDATE_DATE
3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3429: ,p_request_id -- REQUEST_ID
3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID
3431: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3432: from ra_customers_interface rci,
3433: hz_parties hzp
3434: WHERE hzp.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)

Line 3431: ,hz_utility_v2pub.program_id -- PROGRAM_ID

3427: , SYSDATE -- LAST_UPDATE_DATE
3428: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3429: ,p_request_id -- REQUEST_ID
3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID
3431: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3432: from ra_customers_interface rci,
3433: hz_parties hzp
3434: WHERE hzp.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3435: and hzp.request_id = p_request_id

Line 3500: ,hz_utility_v2pub.created_by -- CREATED_BY

3496: ,'' -- OWNER_TABLE_ID
3497: ,1 -- OBJECT_VERSION_NUMBER
3498: ,'CUST_INTERFACE' -- CREATED_BY_MODULE
3499: ,'' -- APPLICATION_ID
3500: ,hz_utility_v2pub.created_by -- CREATED_BY
3501: , SYSDATE -- CREATION_DATE
3502: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3503: , SYSDATE -- LAST_UPDATE_DATE
3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY

Line 3502: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN

3498: ,'CUST_INTERFACE' -- CREATED_BY_MODULE
3499: ,'' -- APPLICATION_ID
3500: ,hz_utility_v2pub.created_by -- CREATED_BY
3501: , SYSDATE -- CREATION_DATE
3502: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3503: , SYSDATE -- LAST_UPDATE_DATE
3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3505: ,p_request_id -- REQUEST_ID
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID

Line 3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY

3500: ,hz_utility_v2pub.created_by -- CREATED_BY
3501: , SYSDATE -- CREATION_DATE
3502: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3503: , SYSDATE -- LAST_UPDATE_DATE
3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3505: ,p_request_id -- REQUEST_ID
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131

Line 3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID

3502: ,hz_utility_v2pub.last_update_login -- LAST_UPDATE_LOGIN
3503: , SYSDATE -- LAST_UPDATE_DATE
3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3505: ,p_request_id -- REQUEST_ID
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131
3509: hz_parties hzp
3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')

Line 3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID

3503: , SYSDATE -- LAST_UPDATE_DATE
3504: ,hz_utility_v2pub.last_updated_by -- LAST_UPDATED_BY
3505: ,p_request_id -- REQUEST_ID
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131
3509: hz_parties hzp
3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')
3511: AND rci.request_id = p_request_id