DBA Data[Home] [Help]

APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on FND_GLOBAL

Line 92: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

88: (SELECT
89: decode (party.party_type, 'ORGANIZATION', 'THIRD_PARTY', 'PERSON', 'THIRD_PARTY') PARTY_TYPE_CODE,
90: L_TAX_CODE TAX_CLASSIFICATION_CODE,
91: L_PARTY_ID PARTY_ID,
92: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
93: L_TAX_HEADER_LEVEL_FLAG ROUNDING_LEVEL_CODE,
94: L_TAX_ROUNDING_RULE ROUNDING_RULE_CODE,
95: party.tax_reference TAX_REFERENCE,
96: SYSDATE CREATION_DATE,

Line 97: FND_GLOBAL.User_ID CREATED_BY,

93: L_TAX_HEADER_LEVEL_FLAG ROUNDING_LEVEL_CODE,
94: L_TAX_ROUNDING_RULE ROUNDING_RULE_CODE,
95: party.tax_reference TAX_REFERENCE,
96: SYSDATE CREATION_DATE,
97: FND_GLOBAL.User_ID CREATED_BY,
98: SYSDATE LAST_UPDATE_DATE,
99: FND_GLOBAL.User_ID LAST_UPDATED_BY,
100: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
101: FROM HZ_PARTIES party

Line 99: FND_GLOBAL.User_ID LAST_UPDATED_BY,

95: party.tax_reference TAX_REFERENCE,
96: SYSDATE CREATION_DATE,
97: FND_GLOBAL.User_ID CREATED_BY,
98: SYSDATE LAST_UPDATE_DATE,
99: FND_GLOBAL.User_ID LAST_UPDATED_BY,
100: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
101: FROM HZ_PARTIES party
102: WHERE PARTY_ID = l_party_id) PTY
103: ON (PTY.PARTY_ID = PTP.PARTY_ID)

Line 100: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

96: SYSDATE CREATION_DATE,
97: FND_GLOBAL.User_ID CREATED_BY,
98: SYSDATE LAST_UPDATE_DATE,
99: FND_GLOBAL.User_ID LAST_UPDATED_BY,
100: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
101: FROM HZ_PARTIES party
102: WHERE PARTY_ID = l_party_id) PTY
103: ON (PTY.PARTY_ID = PTP.PARTY_ID)
104: WHEN MATCHED THEN UPDATE SET

Line 184: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

180: (SELECT
181: 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
182: L_TAX_CODE TAX_CLASSIFICATION_CODE,
183: L_PARTY_SITE_ID PARTY_SITE_ID,
184: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
185: L_TAX_HEADER_LEVEL_FLAG ROUNDING_LEVEL_CODE,
186: L_TAX_ROUNDING_RULE ROUNDING_RULE_CODE,
187: NULL TAX_REFERENCE,
188: SYSDATE CREATION_DATE,

Line 189: FND_GLOBAL.User_ID CREATED_BY,

185: L_TAX_HEADER_LEVEL_FLAG ROUNDING_LEVEL_CODE,
186: L_TAX_ROUNDING_RULE ROUNDING_RULE_CODE,
187: NULL TAX_REFERENCE,
188: SYSDATE CREATION_DATE,
189: FND_GLOBAL.User_ID CREATED_BY,
190: SYSDATE LAST_UPDATE_DATE,
191: FND_GLOBAL.User_ID LAST_UPDATED_BY,
192: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
193: FROM HZ_PARTY_SITES party

Line 191: FND_GLOBAL.User_ID LAST_UPDATED_BY,

187: NULL TAX_REFERENCE,
188: SYSDATE CREATION_DATE,
189: FND_GLOBAL.User_ID CREATED_BY,
190: SYSDATE LAST_UPDATE_DATE,
191: FND_GLOBAL.User_ID LAST_UPDATED_BY,
192: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
193: FROM HZ_PARTY_SITES party
194: WHERE PARTY_SITE_ID = l_party_site_id) PTY
195: ON (PTY.PARTY_SITE_ID = PTP.PARTY_ID)

Line 192: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

188: SYSDATE CREATION_DATE,
189: FND_GLOBAL.User_ID CREATED_BY,
190: SYSDATE LAST_UPDATE_DATE,
191: FND_GLOBAL.User_ID LAST_UPDATED_BY,
192: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
193: FROM HZ_PARTY_SITES party
194: WHERE PARTY_SITE_ID = l_party_site_id) PTY
195: ON (PTY.PARTY_SITE_ID = PTP.PARTY_ID)
196: WHEN MATCHED THEN UPDATE SET

Line 256: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

252: (SELECT
253: decode (party.party_type, 'ORGANIZATION', 'THIRD_PARTY', 'PERSON', 'THIRD_PARTY') PARTY_TYPE_CODE,
254: NULL TAX_CLASSIFICATION_CODE,
255: party.party_id PARTY_ID,
256: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
257: NULL ROUNDING_LEVEL_CODE,
258: NULL ROUNDING_RULE_CODE,
259: party.tax_reference TAX_REFERENCE,
260: SYSDATE CREATION_DATE,

Line 261: FND_GLOBAL.User_ID CREATED_BY,

257: NULL ROUNDING_LEVEL_CODE,
258: NULL ROUNDING_RULE_CODE,
259: party.tax_reference TAX_REFERENCE,
260: SYSDATE CREATION_DATE,
261: FND_GLOBAL.User_ID CREATED_BY,
262: SYSDATE LAST_UPDATE_DATE,
263: FND_GLOBAL.User_ID LAST_UPDATED_BY,
264: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
265: FROM HZ_PARTIES party

Line 263: FND_GLOBAL.User_ID LAST_UPDATED_BY,

259: party.tax_reference TAX_REFERENCE,
260: SYSDATE CREATION_DATE,
261: FND_GLOBAL.User_ID CREATED_BY,
262: SYSDATE LAST_UPDATE_DATE,
263: FND_GLOBAL.User_ID LAST_UPDATED_BY,
264: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
265: FROM HZ_PARTIES party
266: WHERE party.request_id = p_request_id
267: AND (party.party_type ='ORGANIZATION' OR party.party_type ='PERSON')) PTY

Line 264: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

260: SYSDATE CREATION_DATE,
261: FND_GLOBAL.User_ID CREATED_BY,
262: SYSDATE LAST_UPDATE_DATE,
263: FND_GLOBAL.User_ID LAST_UPDATED_BY,
264: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
265: FROM HZ_PARTIES party
266: WHERE party.request_id = p_request_id
267: AND (party.party_type ='ORGANIZATION' OR party.party_type ='PERSON')) PTY
268: ON (PTY.PARTY_ID = PTP.PARTY_ID)

Line 313: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

309: USING
310: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
311: NULL TAX_CLASSIFICATION_CODE,
312: party.party_site_id PARTY_ID,
313: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
314: NULL ROUNDING_LEVEL_CODE,
315: NULL ROUNDING_RULE_CODE,
316: NULL TAX_REFERENCE,
317: SYSDATE CREATION_DATE,

Line 318: FND_GLOBAL.User_ID CREATED_BY,

314: NULL ROUNDING_LEVEL_CODE,
315: NULL ROUNDING_RULE_CODE,
316: NULL TAX_REFERENCE,
317: SYSDATE CREATION_DATE,
318: FND_GLOBAL.User_ID CREATED_BY,
319: SYSDATE LAST_UPDATE_DATE,
320: FND_GLOBAL.User_ID LAST_UPDATED_BY,
321: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
322: FROM HZ_PARTY_SITES party

Line 320: FND_GLOBAL.User_ID LAST_UPDATED_BY,

316: NULL TAX_REFERENCE,
317: SYSDATE CREATION_DATE,
318: FND_GLOBAL.User_ID CREATED_BY,
319: SYSDATE LAST_UPDATE_DATE,
320: FND_GLOBAL.User_ID LAST_UPDATED_BY,
321: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
322: FROM HZ_PARTY_SITES party
323: WHERE party.request_id = p_request_id ) PTY
324: ON (PTY.PARTY_ID = PTP.PARTY_ID)

Line 321: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

317: SYSDATE CREATION_DATE,
318: FND_GLOBAL.User_ID CREATED_BY,
319: SYSDATE LAST_UPDATE_DATE,
320: FND_GLOBAL.User_ID LAST_UPDATED_BY,
321: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
322: FROM HZ_PARTY_SITES party
323: WHERE party.request_id = p_request_id ) PTY
324: ON (PTY.PARTY_ID = PTP.PARTY_ID)
325: WHEN MATCHED THEN UPDATE SET

Line 393: HZ.LAST_UPDATED_BY= FND_GLOBAL.User_ID,

389: AND HZ.CLASS_CATEGORY=PTP.CLASS_CATEGORY)
390: WHEN MATCHED THEN UPDATE SET
391: HZ.CLASS_CODE = P_CLASS_CODE,
392: HZ.LAST_UPDATE_DATE=SYSDATE,
393: HZ.LAST_UPDATED_BY= FND_GLOBAL.User_ID,
394: HZ.LAST_UPDATE_LOGIN=FND_GLOBAL.Login_ID,
395: HZ.OBJECT_VERSION_NUMBER = HZ.OBJECT_VERSION_NUMBER +1
396: WHEN NOT MATCHED THEN
397: INSERT (

Line 394: HZ.LAST_UPDATE_LOGIN=FND_GLOBAL.Login_ID,

390: WHEN MATCHED THEN UPDATE SET
391: HZ.CLASS_CODE = P_CLASS_CODE,
392: HZ.LAST_UPDATE_DATE=SYSDATE,
393: HZ.LAST_UPDATED_BY= FND_GLOBAL.User_ID,
394: HZ.LAST_UPDATE_LOGIN=FND_GLOBAL.Login_ID,
395: HZ.OBJECT_VERSION_NUMBER = HZ.OBJECT_VERSION_NUMBER +1
396: WHEN NOT MATCHED THEN
397: INSERT (
398: CODE_ASSIGNMENT_ID,

Line 435: FND_GLOBAL.User_ID ,

431: 'USER_ENTERED',
432: null,
433: sysdate,
434: null,
435: FND_GLOBAL.User_ID ,
436: SYSDATE ,
437: FND_GLOBAL.Login_ID,
438: SYSDATE ,
439: FND_GLOBAL.User_ID,

Line 437: FND_GLOBAL.Login_ID,

433: sysdate,
434: null,
435: FND_GLOBAL.User_ID ,
436: SYSDATE ,
437: FND_GLOBAL.Login_ID,
438: SYSDATE ,
439: FND_GLOBAL.User_ID,
440: NULL ,
441: 1,

Line 439: FND_GLOBAL.User_ID,

435: FND_GLOBAL.User_ID ,
436: SYSDATE ,
437: FND_GLOBAL.Login_ID,
438: SYSDATE ,
439: FND_GLOBAL.User_ID,
440: NULL ,
441: 1,
442: 'EBTAX',
443: 235,

Line 446: fnd_global.PROG_APPL_ID ,

442: 'EBTAX',
443: 235,
444: null ,
445: null,
446: fnd_global.PROG_APPL_ID ,
447: fnd_global.CONC_PROGRAM_ID);
448:
449: END SYNCH_PTP_CODE_ASSIGMENT;
450:

Line 447: fnd_global.CONC_PROGRAM_ID);

443: 235,
444: null ,
445: null,
446: fnd_global.PROG_APPL_ID ,
447: fnd_global.CONC_PROGRAM_ID);
448:
449: END SYNCH_PTP_CODE_ASSIGMENT;
450:
451: END ZX_TCM_BES_REGISTRATION_PVT;