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.OTA_RA_CON_API dependencies on HZ_PARTIES

Line 94: x_party_id HZ_PARTIES.PARTY_ID%type;

90: x_msg_data VARCHAR2(2000);
91: tmp_var VARCHAR2(2000);
92: tmp_var1 VARCHAR2(2000);
93: l_temp VARCHAR2(30);
94: x_party_id HZ_PARTIES.PARTY_ID%type;
95: x_party_object_version_number NUMBER;
96: l_sql_stat VARCHAR2(4000);
97: --
98:

Line 105: update HZ_PARTIES

101: hr_utility.set_location('Entering:'||l_proc, 5);
102: --
103: -- arkashya Bug #2652833: Changed update on ra_contacts to be based on HZ_ tables directly
104: /*
105: update HZ_PARTIES
106: set
107: PERSON_LAST_NAME = substrb( p_last_name,1,50),
108: PERSON_FIRST_NAME = substrb(p_first_name,1,40),
109: PERSON_PRE_NAME_ADJUNCT = p_title

Line 113: HZ_PARTIES PARTY,

109: PERSON_PRE_NAME_ADJUNCT = p_title
110: where
111: PARTY_ID = (select PARTY.PARTY_ID
112: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
113: HZ_PARTIES PARTY,
114: HZ_RELATIONSHIPS REL,
115: HZ_ORG_CONTACTS ORG_CONT,
116: HZ_CUST_ACCOUNTS ROLE_ACCT
117: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

117: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
120: AND REL.SUBJECT_ID = PARTY.PARTY_ID
121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
123: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
124: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
125: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id );

Line 122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
120: AND REL.SUBJECT_ID = PARTY.PARTY_ID
121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
123: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
124: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
125: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id );
126: */

Line 130: HZ_PARTIES PARTY,

126: */
127: SELECT party.party_id, party.object_version_number
128: INTO x_party_id, x_party_object_version_number
129: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
130: HZ_PARTIES PARTY,
131: HZ_RELATIONSHIPS REL,
132: HZ_ORG_CONTACTS ORG_CONT,
133: HZ_CUST_ACCOUNTS ROLE_ACCT
134: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 138: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

134: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
135: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
136: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
137: AND REL.SUBJECT_ID = PARTY.PARTY_ID
138: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
139: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
140: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
141: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
142: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id;

Line 139: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

135: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
136: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
137: AND REL.SUBJECT_ID = PARTY.PARTY_ID
138: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
139: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
140: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
141: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
142: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id;
143:

Line 265: i_subject_party_id HZ_PARTIES.PARTY_ID%type;

261: X_Msg_Count OUT NOCOPY NUMBER,
262: X_Msg_Data OUT NOCOPY VARCHAR2
263: ) IS
264:
265: i_subject_party_id HZ_PARTIES.PARTY_ID%type;
266: i_subject_party_number VARCHAR2(30);
267: i_object_party_id NUMBER;
268: i_profile_id NUMBER;
269: tmp_var VARCHAR2(2000);

Line 271: i_party_id HZ_PARTIES.PARTY_ID%type;

267: i_object_party_id NUMBER;
268: i_profile_id NUMBER;
269: tmp_var VARCHAR2(2000);
270: i_party_relationship_id NUMBER;
271: i_party_id HZ_PARTIES.PARTY_ID%type;
272: i_party_number VARCHAR2(30);
273: i_org_contact_id NUMBER;
274: tmp_var1 VARCHAR2(2000);
275: i_create_org_contact VARCHAR2(1);

Line 332: --Column subject_table_name must have a value.(HZ_PARTIES)

328: IF x_return_status <> 'S' THEN
329: RETURN;
330: END IF;
331: --Column relationship_code must have a value. Invalid value for subject_id. Please enter id value from .
332: --Column subject_table_name must have a value.(HZ_PARTIES)
333: --Column subject_type must have a value. Invalid value for object_id. Please enter id value from .(PERSON)
334: --Column object_table_name must have a value.(HZ_PARTIES)
335: --Column object_type must have a value (ORGANIZATION)
336: --

Line 334: --Column object_table_name must have a value.(HZ_PARTIES)

330: END IF;
331: --Column relationship_code must have a value. Invalid value for subject_id. Please enter id value from .
332: --Column subject_table_name must have a value.(HZ_PARTIES)
333: --Column subject_type must have a value. Invalid value for object_id. Please enter id value from .(PERSON)
334: --Column object_table_name must have a value.(HZ_PARTIES)
335: --Column object_type must have a value (ORGANIZATION)
336: --
337: -- Create an Org Contact
338: --

Line 347: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

343: ocon_rec.party_rel_rec.subject_id := i_subject_party_id;
344: ocon_rec.party_rel_rec.object_id := customer_party_id;
345: ocon_rec.party_rel_rec.relationship_type := 'CONTACT';
346: ocon_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
347: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
348: ocon_rec.party_rel_rec.object_table_name :='HZ_PARTIES';
349: ocon_rec.party_rel_rec.subject_type := 'PERSON';
350: ocon_rec.party_rel_rec.object_type := 'ORGANIZATION';
351: ocon_rec.party_rel_rec.start_date := sysdate;

Line 348: ocon_rec.party_rel_rec.object_table_name :='HZ_PARTIES';

344: ocon_rec.party_rel_rec.object_id := customer_party_id;
345: ocon_rec.party_rel_rec.relationship_type := 'CONTACT';
346: ocon_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
347: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
348: ocon_rec.party_rel_rec.object_table_name :='HZ_PARTIES';
349: ocon_rec.party_rel_rec.subject_type := 'PERSON';
350: ocon_rec.party_rel_rec.object_type := 'ORGANIZATION';
351: ocon_rec.party_rel_rec.start_date := sysdate;
352: ocon_rec.contact_number := x_contact_number;