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_PARTY_TAX_PROFILE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1: package body ZX_PARTY_TAX_PROFILE_PKG as

1: package body ZX_PARTY_TAX_PROFILE_PKG as
2: /* $Header: zxcptytaxprfileb.pls 120.9 2006/10/02 18:44:36 dbetanco ship $ */
3:
4: procedure INSERT_ROW (
5: P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,

Line 50: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

46: P_FIRST_PARTY_LE_FLAG in VARCHAR2,
47: P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
48: X_RETURN_STATUS out NOCOPY VARCHAR2
49: ) is
50: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
51: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
52: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;

Line 51: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;

47: P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
48: X_RETURN_STATUS out NOCOPY VARCHAR2
49: ) is
50: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
51: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
52: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin

Line 53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE

49: ) is
50: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
51: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
52: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
53: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable
57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable
57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
59: --Perform validations before inserting data
60: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
61: BEGIN
62: -- Check created module name

Line 82: insert into ZX_PARTY_TAX_PROFILE (

78: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
79: END IF;
80: --Insert only when there is no error
81: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
82: insert into ZX_PARTY_TAX_PROFILE (
83: COLLECTING_AUTHORITY_FLAG,
84: PROVIDER_TYPE_CODE,
85: CREATE_AWT_DISTS_TYPE_CODE,
86: CREATE_AWT_INVOICES_TYPE_CODE,

Line 252: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

248: X_RETURN_STATUS out NOCOPY VARCHAR2,
249: P_REGISTRATION_TYPE_CODE IN VARCHAR2,
250: P_COUNTRY_CODE IN VARCHAR2
251: ) is
252: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
253: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
254: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;

Line 253: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;

249: P_REGISTRATION_TYPE_CODE IN VARCHAR2,
250: P_COUNTRY_CODE IN VARCHAR2
251: ) is
252: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
253: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
254: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin

Line 255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE

251: ) is
252: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
253: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
254: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
255: CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable
259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable
259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
261: BEGIN
262: -- Check created module name
263: select nvl(substr(created_by_module,1,3),'ZX') created_by_module
264: into L_CREATED_BY_MODULE

Line 284: insert into ZX_PARTY_TAX_PROFILE (

280: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
281: END IF;
282: --Insert only when there is no error
283: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
284: insert into ZX_PARTY_TAX_PROFILE (
285: COLLECTING_AUTHORITY_FLAG,
286: PROVIDER_TYPE_CODE,
287: CREATE_AWT_DISTS_TYPE_CODE,
288: CREATE_AWT_INVOICES_TYPE_CODE,

Line 457: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;

453: P_FIRST_PARTY_LE_FLAG in VARCHAR2,
454: P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
455: X_RETURN_STATUS out NOCOPY VARCHAR2
456: ) is
457: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
458: begin
459: --Initialise x_return_status variable
460: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
461: --Perform validations before inserting data

Line 475: update ZX_PARTY_TAX_PROFILE set

471: L_EFFECTIVE_FROM_USE_LE := NULL;
472: END IF;
473: --Update only when there is no error
474: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
475: update ZX_PARTY_TAX_PROFILE set
476: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
477: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
478: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
479: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),

Line 581: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;

577: X_RETURN_STATUS out NOCOPY VARCHAR2,
578: P_REGISTRATION_TYPE_CODE in VARCHAR2,
579: P_COUNTRY_CODE in VARCHAR2
580: ) is
581: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
582: begin
583: --Initialise x_return_status variable
584: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
585: --Perform validations before inserting data

Line 599: update ZX_PARTY_TAX_PROFILE set

595: L_EFFECTIVE_FROM_USE_LE := NULL;
596: END IF;
597: --Update only when there is no error
598: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
599: update ZX_PARTY_TAX_PROFILE set
600: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
601: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
602: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
603: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),

Line 666: delete from ZX_PARTY_TAX_PROFILE

662: begin
663: --Initialise x_return_status variable
664: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
665: --Delete the row
666: delete from ZX_PARTY_TAX_PROFILE
667: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
668:
669: if (sql%notfound) then
670: --Set x_return_status param

Line 676: end ZX_PARTY_TAX_PROFILE_PKG;

672: raise no_data_found;
673: end if;
674: end DELETE_ROW;
675:
676: end ZX_PARTY_TAX_PROFILE_PKG;