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.ZX_TCM_BES_REGISTRATION_PVT dependencies on ZX_PARTY_TAX_PROFILE

Line 61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;

57: p_event IN OUT NOCOPY wf_event_t) RETURN VARCHAR2
58: IS
59: l_party_id HZ_PARTIES.party_id%TYPE;
60:
61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
64:
65: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line 62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;

58: IS
59: l_party_id HZ_PARTIES.party_id%TYPE;
60:
61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
64:
65: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
66:

Line 63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

59: l_party_id HZ_PARTIES.party_id%TYPE;
60:
61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
64:
65: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
66:
67: l_status_code VARCHAR2(80);

Line 65: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

61: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
62: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
63: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
64:
65: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
66:
67: l_status_code VARCHAR2(80);
68:
69: BEGIN

Line 86: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

82: l_tax_rounding_rule :=NULL;
83:
84: -- Create PTP If can not be updated.
85: BEGIN
86: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
87: USING
88: (SELECT
89: decode (party.party_type, 'ORGANIZATION', 'THIRD_PARTY', 'PERSON', 'THIRD_PARTY') PARTY_TYPE_CODE,
90: L_TAX_CODE TAX_CLASSIFICATION_CODE,

Line 129: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

125: OBJECT_VERSION_NUMBER)
126: VALUES (
127: PTY.PARTY_TYPE_CODE,
128: PTY.TAX_CLASSIFICATION_CODE,
129: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
130: PTY.PARTY_ID,
131: PTY.PROGRAM_LOGIN_ID,
132: PTY.ROUNDING_LEVEL_CODE,
133: PTY.ROUNDING_RULE_CODE,

Line 161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;

157:
158: l_party_id HZ_PARTIES.party_id%TYPE;
159: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
160:
161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
164:
165: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line 162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;

158: l_party_id HZ_PARTIES.party_id%TYPE;
159: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
160:
161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
164:
165: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
166:

Line 163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

159: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
160:
161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
164:
165: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
166:
167: BEGIN

Line 165: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

161: l_tax_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
162: l_tax_header_level_flag ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
163: l_tax_rounding_rule ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
164:
165: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
166:
167: BEGIN
168: l_party_site_id:=p_event.GetValueForParameter('PARTY_SITE_ID');
169:

Line 178: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

174: l_tax_rounding_rule :=NULL;
175:
176: -- Create PTP If can not be updated.
177: BEGIN
178: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
179: USING
180: (SELECT
181: 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
182: L_TAX_CODE TAX_CLASSIFICATION_CODE,

Line 221: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

217: OBJECT_VERSION_NUMBER)
218: VALUES (
219: PTY.PARTY_TYPE_CODE,
220: PTY.TAX_CLASSIFICATION_CODE,
221: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
222: PTY.PARTY_SITE_ID,
223: PTY.PROGRAM_LOGIN_ID,
224: PTY.ROUNDING_LEVEL_CODE,
225: PTY.ROUNDING_RULE_CODE,

Line 250: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

246: IS
247: -- Create PTP If can not be updated.
248: BEGIN
249:
250: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
251: USING
252: (SELECT
253: decode (party.party_type, 'ORGANIZATION', 'THIRD_PARTY', 'PERSON', 'THIRD_PARTY') PARTY_TYPE_CODE,
254: NULL TAX_CLASSIFICATION_CODE,

Line 294: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

290: OBJECT_VERSION_NUMBER)
291: VALUES (
292: PTY.PARTY_TYPE_CODE,
293: PTY.TAX_CLASSIFICATION_CODE,
294: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
295: PTY.PARTY_ID,
296: PTY.PROGRAM_LOGIN_ID,
297: PTY.ROUNDING_LEVEL_CODE,
298: PTY.ROUNDING_RULE_CODE,

Line 308: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

304: PTY.LAST_UPDATE_LOGIN,
305: 1);
306:
307: -- Import Party Sites.
308: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
309: USING
310: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
311: NULL TAX_CLASSIFICATION_CODE,
312: party.party_site_id PARTY_ID,

Line 349: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

345: OBJECT_VERSION_NUMBER)
346: VALUES (
347: PTY.PARTY_TYPE_CODE,
348: PTY.TAX_CLASSIFICATION_CODE,
349: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
350: PTY.PARTY_ID,
351: PTY.PROGRAM_LOGIN_ID,
352: PTY.ROUNDING_LEVEL_CODE,
353: PTY.ROUNDING_RULE_CODE,

Line 380: (SELECT 'ZX_PARTY_TAX_PROFILE' OWNER_TABLE_NAME,

376: x_msg_data OUT NOCOPY VARCHAR2) IS
377:
378: BEGIN
379: MERGE INTO HZ_CODE_ASSIGNMENTS HZ USING
380: (SELECT 'ZX_PARTY_TAX_PROFILE' OWNER_TABLE_NAME,
381: PARTY_TAX_PROFILE_ID OWNER_TABLE_ID,
382: 'VENDOR TYPE' CLASS_CATEGORY,
383: OBJECT_VERSION_NUMBER
384: FROM ZX_PARTY_TAX_PROFILE

Line 384: FROM ZX_PARTY_TAX_PROFILE

380: (SELECT 'ZX_PARTY_TAX_PROFILE' OWNER_TABLE_NAME,
381: PARTY_TAX_PROFILE_ID OWNER_TABLE_ID,
382: 'VENDOR TYPE' CLASS_CATEGORY,
383: OBJECT_VERSION_NUMBER
384: FROM ZX_PARTY_TAX_PROFILE
385: WHERE Party_id = p_party_id
386: AND PARTY_TYPE_CODE ='THIRD_PARTY' ) PTP
387: ON (HZ.OWNER_TABLE_ID = PTP.OWNER_TABLE_ID
388: AND HZ.OWNER_TABLE_NAME = PTP.OWNER_TABLE_NAME