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.13 2010/12/22 14:13:38 srajapar ship $ */
3:
4:
5: procedure INSERT_ROW (

Line 153: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

149: x_return_status OUT NOCOPY VARCHAR2,
150: p_registration_type_code IN VARCHAR2,
151: p_country_code IN VARCHAR2
152: ) is
153: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
154: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
155: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
156:
157: CURSOR ptp_cur IS

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

150: p_registration_type_code IN VARCHAR2,
151: p_country_code IN VARCHAR2
152: ) is
153: L_PARTY_TAX_PROFILE_ID ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
154: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
155: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
156:
157: CURSOR ptp_cur IS
158: SELECT PARTY_TAX_PROFILE_ID

Line 159: FROM ZX_PARTY_TAX_PROFILE

155: L_CREATED_BY_MODULE HZ_PARTIES.CREATED_BY_MODULE%TYPE;
156:
157: CURSOR ptp_cur IS
158: SELECT PARTY_TAX_PROFILE_ID
159: FROM ZX_PARTY_TAX_PROFILE
160: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
161:
162: begin
163: --Initialise x_return_status variable

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

161:
162: begin
163: --Initialise x_return_status variable
164: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
165: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
166:
167: -- commenting out for bug 10236399
168: -- BEGIN
169: -- Check created module name

Line 193: insert into ZX_PARTY_TAX_PROFILE (

189: L_EFFECTIVE_FROM_USE_LE := SYSDATE;
190: END IF;
191: --Insert only when there is no error
192: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
193: insert into ZX_PARTY_TAX_PROFILE (
194: COLLECTING_AUTHORITY_FLAG,
195: PROVIDER_TYPE_CODE,
196: CREATE_AWT_DISTS_TYPE_CODE,
197: CREATE_AWT_INVOICES_TYPE_CODE,

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

464: x_return_status OUT NOCOPY VARCHAR2,
465: p_registration_type_code IN VARCHAR2,
466: p_country_code IN VARCHAR2
467: ) is
468: L_EFFECTIVE_FROM_USE_LE ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE := P_EFFECTIVE_FROM_USE_LE;
469: begin
470: --Initialise x_return_status variable
471: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
472: --Perform validations before inserting data

Line 486: update ZX_PARTY_TAX_PROFILE set

482: L_EFFECTIVE_FROM_USE_LE := NULL;
483: END IF;
484: --Update only when there is no error
485: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
486: update ZX_PARTY_TAX_PROFILE set
487: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
488: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
489: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
490: 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 553: delete from ZX_PARTY_TAX_PROFILE

549: begin
550: --Initialise x_return_status variable
551: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
552: --Delete the row
553: delete from ZX_PARTY_TAX_PROFILE
554: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
555:
556: if (sql%notfound) then
557: --Set x_return_status param

Line 643: END ZX_PARTY_TAX_PROFILE_PKG;

639: x_msg_data := SQLERRM;
640:
641: END sync_tax_reg_num;
642:
643: END ZX_PARTY_TAX_PROFILE_PKG;