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.CSC_PARTY_MERGE_PKG dependencies on STANDARD

Line 191: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

187: last_update_date = trunc(SYSDATE),
188: last_updated_by = G_USER_ID,
189: last_update_login = G_LOGIN_ID,
190: request_id = G_REQUEST_ID,
191: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
192: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
193: program_update_date = trunc(SYSDATE)
194: where party_id = p_from_fk_id;
195:

Line 192: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

188: last_updated_by = G_USER_ID,
189: last_update_login = G_LOGIN_ID,
190: request_id = G_REQUEST_ID,
191: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
192: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
193: program_update_date = trunc(SYSDATE)
194: where party_id = p_from_fk_id;
195:
196: insert into csc_customers_audit_hist (

Line 210: ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

206: g_user_id, g_login_id, sysdate,
207: g_user_id, sysdate, g_user_id,
208: 'N', l_from_override_flag, l_from_overridden_crit_flag,
209: l_from_override_reason_code , G_REQUEST_ID,
210: ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
211: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE );
212:
213: return;
214: exception

Line 211: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE );

207: g_user_id, sysdate, g_user_id,
208: 'N', l_from_override_flag, l_from_overridden_crit_flag,
209: l_from_override_reason_code , G_REQUEST_ID,
210: ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
211: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE );
212:
213: return;
214: exception
215: when others then

Line 271: p_program_application_id => ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

267: x_overridden_critical_flag => l_from_overridden_crit_flag,
268: x_override_reason_code => l_from_override_reason_code,
269: p_party_status => 'M',
270: p_request_id => G_REQUEST_ID,
271: p_program_application_id => ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
272: p_program_id => ARP_STANDARD.PROFILE.PROGRAM_ID,
273: p_program_update_date => SYSDATE );
274:
275: exception

Line 272: p_program_id => ARP_STANDARD.PROFILE.PROGRAM_ID,

268: x_override_reason_code => l_from_override_reason_code,
269: p_party_status => 'M',
270: p_request_id => G_REQUEST_ID,
271: p_program_application_id => ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
272: p_program_id => ARP_STANDARD.PROFILE.PROGRAM_ID,
273: p_program_update_date => SYSDATE );
274:
275: exception
276: when resource_busy then

Line 402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

398: select
399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
400: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
401: G_USER_ID, SYSDATE, G_USER_ID,
402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
404: from csc_cust_plans
405: where party_id = p_from_fk_id
406: and cust_account_id is not null;

Line 403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
400: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
401: G_USER_ID, SYSDATE, G_USER_ID,
402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
404: from csc_cust_plans
405: where party_id = p_from_fk_id
406: and cust_account_id is not null;
407: audit_count := sql%rowcount;

Line 419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

415: select
416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
417: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
418: G_USER_ID, SYSDATE, G_USER_ID,
419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
421: from csc_cust_plans
422: where party_id = p_from_fk_id and cust_account_id is null
423: and plan_id not in ( select plan_id

Line 420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
417: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
418: G_USER_ID, SYSDATE, G_USER_ID,
419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
421: from csc_cust_plans
422: where party_id = p_from_fk_id and cust_account_id is null
423: and plan_id not in ( select plan_id
424: from csc_cust_plans

Line 438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

434: select
435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
436: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
437: G_USER_ID, SYSDATE, G_USER_ID,
438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
440: from csc_cust_plans
441: where party_id = p_from_fk_id
442: and cust_account_id is not null;

Line 439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
436: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
437: G_USER_ID, SYSDATE, G_USER_ID,
438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
440: from csc_cust_plans
441: where party_id = p_from_fk_id
442: and cust_account_id is not null;
443: audit_count := audit_count+sql%rowcount;

Line 455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

451: select
452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
453: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
454: G_USER_ID, SYSDATE, G_USER_ID,
455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
457: from csc_cust_plans
458: where party_id = p_from_fk_id and cust_account_id is null
459: and plan_id not in ( select plan_id

Line 456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
453: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
454: G_USER_ID, SYSDATE, G_USER_ID,
455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
457: from csc_cust_plans
458: where party_id = p_from_fk_id and cust_account_id is null
459: and plan_id not in ( select plan_id
460: from csc_cust_plans

Line 472: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

468: -- end_date_active = SYSDATE,
469: last_update_date = SYSDATE,
470: last_updated_by = G_USER_ID,
471: last_update_login = G_LOGIN_ID,
472: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
473: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
474: program_update_date = SYSDATE,
475: object_version_number = object_version_number + 1
476: where party_id = p_from_fk_id

Line 473: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

469: last_update_date = SYSDATE,
470: last_updated_by = G_USER_ID,
471: last_update_login = G_LOGIN_ID,
472: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
473: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
474: program_update_date = SYSDATE,
475: object_version_number = object_version_number + 1
476: where party_id = p_from_fk_id
477: and cust_account_id is not null;

Line 488: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

484: -- end_date_active = SYSDATE,
485: last_update_date = SYSDATE,
486: last_updated_by = G_USER_ID,
487: last_update_login = G_LOGIN_ID,
488: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
489: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
490: program_update_date = SYSDATE,
491: object_version_number = object_version_number + 1
492: where party_id = p_from_fk_id and cust_account_id is null

Line 489: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

485: last_update_date = SYSDATE,
486: last_updated_by = G_USER_ID,
487: last_update_login = G_LOGIN_ID,
488: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
489: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
490: program_update_date = SYSDATE,
491: object_version_number = object_version_number + 1
492: where party_id = p_from_fk_id and cust_account_id is null
493: and plan_id not in ( select plan_id

Line 523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

519: -- select
520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,
521: -- G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
522: -- G_USER_ID, SYSDATE, G_USER_ID,
523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
525: -- from csc_cust_plans
526: -- where party_id = p_from_fk_id
527: -- and plan_id not in ( select plan_id

Line 524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,
521: -- G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
522: -- G_USER_ID, SYSDATE, G_USER_ID,
523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
525: -- from csc_cust_plans
526: -- where party_id = p_from_fk_id
527: -- and plan_id not in ( select plan_id
528: -- from csc_cust_plans

Line 550: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

546: request_id = G_REQUEST_ID,
547: last_update_date = SYSDATE,
548: last_updated_by = G_USER_ID,
549: last_update_login = G_LOGIN_ID,
550: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
551: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
552: program_update_date = SYSDATE,
553: object_version_number = object_version_number + 1
554: where party_id = p_from_fk_id

Line 551: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

547: last_update_date = SYSDATE,
548: last_updated_by = G_USER_ID,
549: last_update_login = G_LOGIN_ID,
550: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
551: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
552: program_update_date = SYSDATE,
553: object_version_number = object_version_number + 1
554: where party_id = p_from_fk_id
555: and plan_id in ( select plan_id

Line 579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

575: select
576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,
577: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
578: G_USER_ID, SYSDATE, G_USER_ID,
579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
581: from csc_cust_plans
582: where party_id = p_from_fk_id
583: and plan_id in ( select plan_id

Line 580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,
577: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
578: G_USER_ID, SYSDATE, G_USER_ID,
579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
581: from csc_cust_plans
582: where party_id = p_from_fk_id
583: and plan_id in ( select plan_id
584: from csc_cust_plans

Line 701: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,

697:
698: update csc_customized_plans
699: set party_id = p_to_fk_id,
700: request_id = G_REQUEST_ID,
701: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
702: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
703: program_update_date = SYSDATE,
704: plan_status_code = G_TRANSFER_PLAN
705: where party_id = p_from_fk_id

Line 702: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

698: update csc_customized_plans
699: set party_id = p_to_fk_id,
700: request_id = G_REQUEST_ID,
701: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
702: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
703: program_update_date = SYSDATE,
704: plan_status_code = G_TRANSFER_PLAN
705: where party_id = p_from_fk_id
706: and plan_id not in ( select plan_id