DBA Data[Home] [Help]

APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on FND_GLOBAL

Line 180: FND_GLOBAL.User_ID,

176: P_LEGAL_ESTABLISHMENT_FLAG,
177: P_FIRST_PARTY_LE_FLAG,
178: P_REPORTING_AUTHORITY_FLAG,
179: sysdate,
180: FND_GLOBAL.User_ID,
181: sysdate,
182: FND_GLOBAL.User_ID,
183: FND_GLOBAL.Login_ID,
184: 1

Line 182: FND_GLOBAL.User_ID,

178: P_REPORTING_AUTHORITY_FLAG,
179: sysdate,
180: FND_GLOBAL.User_ID,
181: sysdate,
182: FND_GLOBAL.User_ID,
183: FND_GLOBAL.Login_ID,
184: 1
185: );
186: OPEN ptp_cur;

Line 183: FND_GLOBAL.Login_ID,

179: sysdate,
180: FND_GLOBAL.User_ID,
181: sysdate,
182: FND_GLOBAL.User_ID,
183: FND_GLOBAL.Login_ID,
184: 1
185: );
186: OPEN ptp_cur;
187: FETCH ptp_cur INTO L_PARTY_TAX_PROFILE_ID;

Line 384: FND_GLOBAL.User_ID,

380: P_LEGAL_ESTABLISHMENT_FLAG,
381: P_FIRST_PARTY_LE_FLAG,
382: P_REPORTING_AUTHORITY_FLAG,
383: sysdate,
384: FND_GLOBAL.User_ID,
385: sysdate,
386: FND_GLOBAL.User_ID,
387: FND_GLOBAL.Login_ID,
388: 1,

Line 386: FND_GLOBAL.User_ID,

382: P_REPORTING_AUTHORITY_FLAG,
383: sysdate,
384: FND_GLOBAL.User_ID,
385: sysdate,
386: FND_GLOBAL.User_ID,
387: FND_GLOBAL.Login_ID,
388: 1,
389: P_REGISTRATION_TYPE_CODE,
390: P_COUNTRY_CODE

Line 387: FND_GLOBAL.Login_ID,

383: sysdate,
384: FND_GLOBAL.User_ID,
385: sysdate,
386: FND_GLOBAL.User_ID,
387: FND_GLOBAL.Login_ID,
388: 1,
389: P_REGISTRATION_TYPE_CODE,
390: P_COUNTRY_CODE
391: );

Line 520: LAST_UPDATED_BY = FND_GLOBAL.User_ID,

516: LEGAL_ESTABLISHMENT_FLAG = DECODE( P_LEGAL_ESTABLISHMENT_FLAG, NULL, LEGAL_ESTABLISHMENT_FLAG, P_LEGAL_ESTABLISHMENT_FLAG ),
517: FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
518: REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
519: LAST_UPDATE_DATE = sysdate,
520: LAST_UPDATED_BY = FND_GLOBAL.User_ID,
521: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
522: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
523: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
524: if (sql%notfound) then

Line 521: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,

517: FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
518: REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
519: LAST_UPDATE_DATE = sysdate,
520: LAST_UPDATED_BY = FND_GLOBAL.User_ID,
521: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
522: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
523: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
524: if (sql%notfound) then
525: --Set x_return_status param

Line 644: LAST_UPDATED_BY = FND_GLOBAL.User_ID,

640: LEGAL_ESTABLISHMENT_FLAG = DECODE( P_LEGAL_ESTABLISHMENT_FLAG, NULL, LEGAL_ESTABLISHMENT_FLAG, P_LEGAL_ESTABLISHMENT_FLAG ),
641: FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
642: REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
643: LAST_UPDATE_DATE = sysdate,
644: LAST_UPDATED_BY = FND_GLOBAL.User_ID,
645: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
646: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
647: REGISTRATION_TYPE_CODE = DECODE (P_REGISTRATION_TYPE_CODE,NULL, REGISTRATION_TYPE_CODE, P_REGISTRATION_TYPE_CODE),
648: COUNTRY_CODE = DECODE (P_COUNTRY_CODE,NULL, COUNTRY_CODE, P_COUNTRY_CODE)

Line 645: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,

641: FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
642: REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
643: LAST_UPDATE_DATE = sysdate,
644: LAST_UPDATED_BY = FND_GLOBAL.User_ID,
645: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
646: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
647: REGISTRATION_TYPE_CODE = DECODE (P_REGISTRATION_TYPE_CODE,NULL, REGISTRATION_TYPE_CODE, P_REGISTRATION_TYPE_CODE),
648: COUNTRY_CODE = DECODE (P_COUNTRY_CODE,NULL, COUNTRY_CODE, P_COUNTRY_CODE)
649: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;