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.ARH_CONT_PKG dependencies on DUAL

Line 278: from dual

274: dummy number;
275: begin
276: select 1
277: into dummy
278: from dual
279: where not exists ( select 1
280: from hz_cust_account_roles acct_role,
281: hz_parties party,
282: hz_relationships rel

Line 332: from dual

328: dummy number;
329: BEGIN
330: select 1
331: into dummy
332: from dual
333: where not exists ( select 1
334: from hz_cust_account_roles acct_role
335: where acct_role.orig_system_reference
336: = x_orig_system_reference

Line 603: SELECT hz_contact_numbers_s.nextval INTO X_Contact_Number FROM DUAL;

599: --
600: IF X_Contact_Number is NULL THEN
601: -- if (nvl(fnd_profile.value('AR_AUTOMATIC_CONTACT_NUMBERING'), 'N')
602: -- = 'Y') then
603: SELECT hz_contact_numbers_s.nextval INTO X_Contact_Number FROM DUAL;
604: -- end if;
605: -- Bug Fix : 2172123.
606: END IF;
607:

Line 616: SELECT hz_org_contacts_s.nextval INTO x_contact_id FROM DUAL;

612: i_create_org_contact := 'N';
613: END IF;
614:
615: IF i_create_org_contact = 'Y' THEN
616: SELECT hz_org_contacts_s.nextval INTO x_contact_id FROM DUAL;
617: END IF;
618:
619: arp_standard.debug(' i_create_org_contact :'||i_create_org_contact );
620:

Line 625: select hz_party_number_s.nextval into i_subject_party_number from dual;

621: -- BugFix:2225260
622: --- If Subject Party does not exist,added this following if clause.
623: --
624: IF X_Sub_Party_Id IS NULL THEN
625: select hz_party_number_s.nextval into i_subject_party_number from dual;
626: select hz_parties_s.nextval into i_subject_party_id from dual;
627: ELSE
628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;

Line 626: select hz_parties_s.nextval into i_subject_party_id from dual;

622: --- If Subject Party does not exist,added this following if clause.
623: --
624: IF X_Sub_Party_Id IS NULL THEN
625: select hz_party_number_s.nextval into i_subject_party_number from dual;
626: select hz_parties_s.nextval into i_subject_party_id from dual;
627: ELSE
628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;
630:

Line 634: select hz_contact_points_s.nextval into i_contact_point_id from dual;

630:
631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );
632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;
636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;
637:
638: --

Line 635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;

631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );
632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;
636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;
637:
638: --
639: -- validate uniqueness

Line 636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;

632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;
636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;
637:
638: --
639: -- validate uniqueness
640: --

Line 702: SELECT hz_party_number_s.nextval INTO ii_party_number FROM DUAL;

698: OPEN cu_party_type(i_subject_party_id);
699: FETCH cu_party_type INTO l_subject_type;
700: CLOSE cu_party_type;
701:
702: SELECT hz_party_number_s.nextval INTO ii_party_number FROM DUAL;
703:
704: ocon_rec.party_rel_rec.subject_id := i_subject_party_id;
705: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
706: -- ocon_rec.party_rel_rec.subject_type := 'PERSON';

Line 1692: from dual;

1688: email_rec.email_address := X_Email_Address;
1689:
1690: select hz_contact_points_s.nextval
1691: into i_contact_point_id
1692: from dual;
1693:
1694: cpoint_rec.contact_point_id := i_contact_point_Id;
1695: cpoint_rec.created_by_module := 'TCA_FORM_WRAPPER';
1696: