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_PTP_IMPORT dependencies on ZX_EXEMPTIONS_INT

Line 177: FUNCTION getAttrValue(p_zx_exempt_rec IN zx_exemptions_int%ROWTYPE

173: PROCEDURE PopulateProductionTables;
174: PROCEDURE ResetRecStatusForChildTables;
175: PROCEDURE performDFFValidation;
176: PROCEDURE resetDFFFieldUsage;
177: FUNCTION getAttrValue(p_zx_exempt_rec IN zx_exemptions_int%ROWTYPE
178: ,p_column_name IN VARCHAR2
179: ) RETURN VARCHAR2 ;
180:
181:

Line 218: G_INTF_EXE_TABLE_NAME := 'ZX_EXEMPTIONS_INT';

214: -- interface table names
215: --
216: G_INTF_PTP_TABLE_NAME := 'ZX_PARTY_TAX_PROFILE_INT';
217: G_INTF_REG_TABLE_NAME := 'ZX_REGISTRATIONS_INT';
218: G_INTF_EXE_TABLE_NAME := 'ZX_EXEMPTIONS_INT';
219: G_INTF_RCA_TABLE_NAME := 'ZX_REPORT_CODES_ASSOC_INT';
220: G_INTF_CUS_TABLE_NAME := 'RA_CUSTOMERS_INTERFACE_ALL';
221: G_INTF_SUP_TABLE_NAME := 'AP_SUPPLIERS_INT';
222: G_INTF_SUP_SITE_TABLE_NAME := 'AP_SUPPLIER_SITES_INT';

Line 469: DELETE zx_exemptions_int

465: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
466: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
467: END IF;
468:
469: DELETE zx_exemptions_int
470: WHERE request_id = G_REQUEST_ID
471: AND record_status = G_RS_VALID;
472:
473: G_DEBUG_STATEMENT:='Deleted '||SQL%ROWCOUNT||' records from '||G_INTF_EXE_TABLE_NAME;

Line 562: UPDATE zx_exemptions_int exe_int

558: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
559: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
560: END IF;
561:
562: UPDATE zx_exemptions_int exe_int
563: SET record_status = NULL
564: WHERE request_id = G_REQUEST_ID
565: AND record_status = G_RS_VALID
566: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1

Line 830: FROM ZX_EXEMPTIONS_INT

826:
827: BEGIN
828: SELECT G_INTF_EXE_TABLE_NAME
829: INTO l_temp_char_30
830: FROM ZX_EXEMPTIONS_INT
831: WHERE NVL(record_status,G_RS_ERROR) <> G_RS_VALID
832: AND NVL(batch_id,G_MISS_NUM) =
833: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM))
834: AND ROWNUM = 1;

Line 4047: UPDATE zx_exemptions_int

4043:
4044: -------------------------
4045: -- Populate default values
4046: -------------------------
4047: UPDATE zx_exemptions_int
4048: SET request_id = G_REQUEST_ID
4049: ,record_status = G_RS_IN_PROCESS
4050: ,dml_type = UPPER(dml_type)
4051: ,prog_int_char1 = NULL

Line 4067: UPDATE zx_exemptions_int exe_int

4063: -------------------------
4064: -- Check Mandatory Paramters
4065: -------------------------
4066:
4067: UPDATE zx_exemptions_int exe_int
4068: SET error_number = G_ES_EXE_MAND_PARAM_MISSING
4069: WHERE request_id = G_REQUEST_ID
4070: AND record_status = G_RS_IN_PROCESS
4071: AND (NVL(tax_regime_code,tax_regime_name) IS NULL OR

Line 4104: UPDATE zx_exemptions_int orig

4100: -- Record level validations
4101: -------------------------
4102: --Exemptions with overlapping date ranges.
4103:
4104: UPDATE zx_exemptions_int orig
4105: SET error_number = error_number + G_ES_EXE_DATE_OVERLAP
4106: WHERE record_status = G_RS_IN_PROCESS
4107: AND request_id = G_REQUEST_ID
4108: AND EXISTS (

Line 4110: FROM zx_exemptions_int dup

4106: WHERE record_status = G_RS_IN_PROCESS
4107: AND request_id = G_REQUEST_ID
4108: AND EXISTS (
4109: SELECT /*+ FIRST_ROWS(1) */ 1
4110: FROM zx_exemptions_int dup
4111: WHERE dup.rowid <> orig.rowid
4112: AND dup.request_id = G_REQUEST_ID
4113: AND dup.record_status = G_RS_IN_PROCESS
4114: AND dup.intf_ptp_reference = orig.intf_ptp_reference

Line 4159: UPDATE zx_exemptions_int exe_int

4155: ----------------------------
4156: -- Tail End Activities
4157: ----------------------------
4158:
4159: UPDATE zx_exemptions_int exe_int
4160: SET record_status = DECODE(error_number,0,G_RS_VALID,G_RS_ERROR)
4161: WHERE request_id = G_REQUEST_ID
4162: AND record_status = G_RS_IN_PROCESS;
4163:

Line 4169: FROM zx_exemptions_int exe_int

4165: SET record_status = NULL
4166: WHERE request_id = G_REQUEST_ID
4167: AND record_status = G_RS_VALID
4168: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
4169: FROM zx_exemptions_int exe_int
4170: WHERE request_id = G_REQUEST_ID
4171: AND record_status = G_RS_ERROR
4172: AND exe_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
4173:

Line 4230: UPDATE zx_exemptions_int

4226:
4227: -- Field Validations
4228:
4229: -- Records with invalid dml_type
4230: UPDATE zx_exemptions_int
4231: SET error_number = error_number + G_ES_EXE_TRANS_TYPE_INVALID
4232: WHERE record_status = G_RS_IN_PROCESS
4233: AND request_id = G_REQUEST_ID
4234: AND dml_type <> 'CREATE';

Line 4242: UPDATE zx_exemptions_int exe_int

4238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4239: END IF;
4240:
4241: -- validating the fields exempt_reason_name and exempt_reason_code
4242: UPDATE zx_exemptions_int exe_int
4243: SET error_number = error_number + G_ES_EXE_EXMPT_RSN_INVALID
4244: WHERE (( exempt_reason_code IS NOT NULL
4245: AND NOT EXISTS
4246: (

Line 4279: UPDATE zx_exemptions_int exe_int

4275: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4276: END IF;
4277:
4278: -- value to id conversion for registration_reason_code
4279: UPDATE zx_exemptions_int exe_int
4280: SET exempt_reason_code = (
4281: SELECT fndlookup.lookup_code
4282: FROM fnd_lookups fndlookup
4283: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_REASON_CODE'

Line 4301: UPDATE zx_exemptions_int exe_int

4297: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4298: END IF;
4299:
4300: -- validating the fields exemption_status_name and exemption_status_code
4301: UPDATE zx_exemptions_int exe_int
4302: SET error_number = error_number + G_ES_EXE_EXMPT_STS_INVALID
4303: WHERE (( exemption_status_code IS NOT NULL
4304: AND NOT EXISTS
4305: (

Line 4338: UPDATE zx_exemptions_int exe_int

4334: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4335: END IF;
4336:
4337: -- value to id conversion for exempt_status_code
4338: UPDATE zx_exemptions_int exe_int
4339: SET exemption_status_code = (
4340: SELECT fndlookup.lookup_code
4341: FROM fnd_lookups fndlookup
4342: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_STATUS'

Line 4360: UPDATE zx_exemptions_int exe_int

4356: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4357: END IF;
4358:
4359: -- validating the fields tax_regime_name snd tax_regime_code
4360: UPDATE zx_exemptions_int exe_int
4361: SET error_number = error_number + G_ES_EXE_TAX_REG_INVALID
4362: WHERE (
4363: ( tax_regime_code IS NOT NULL
4364: AND NOT EXISTS

Line 4393: UPDATE zx_exemptions_int exe_int

4389: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4390: END IF;
4391:
4392: -- value to id conversion for tax_regime_code
4393: UPDATE zx_exemptions_int exe_int
4394: SET tax_regime_code = (
4395: SELECT tax_regime_code
4396: FROM zx_regimes_v
4397: WHERE has_sub_regime_flag <> 'Y'

Line 4412: UPDATE zx_exemptions_int exe_int

4408: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4409: END IF;
4410:
4411: -- validating the fields content_owner_id snd content_owner_name
4412: UPDATE zx_exemptions_int exe_int
4413: SET error_number = error_number + G_ES_EXE_CNT_OWN_INVALID
4414: WHERE (( content_owner_id IS NOT NULL
4415: AND NOT EXISTS
4416: (

Line 4463: UPDATE zx_exemptions_int exe_int

4459: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4460: END IF;
4461:
4462: -- value to id conversion for content_owner_id
4463: UPDATE zx_exemptions_int exe_int
4464: SET content_owner_id = (
4465: SELECT fpo.party_tax_profile_id
4466: FROM zx_first_party_orgs_moac_v fpo,
4467: fnd_lookups lkp,

Line 4492: UPDATE zx_exemptions_int exe_int

4488: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4489: END IF;
4490:
4491: -- validating the fields tax and tax_name
4492: UPDATE zx_exemptions_int exe_int
4493: SET error_number = error_number + G_ES_EXE_TAX_PARAM_INVALID
4494: WHERE (( tax_code IS NOT NULL
4495: AND NOT EXISTS
4496: (

Line 4560: UPDATE zx_exemptions_int exe_int

4556: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4557: END IF;
4558:
4559: -- value to id conversion for tax
4560: UPDATE zx_exemptions_int exe_int
4561: SET tax_code = (
4562: SELECT ztvl.tax
4563: FROM zx_taxes_vl ztvl,
4564: zx_subscription_details sd

Line 4598: UPDATE zx_exemptions_int exe_int

4594: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4595: END IF;
4596:
4597: -- validating the fields tax_status_code and tax_status_name
4598: UPDATE zx_exemptions_int exe_int
4599: SET error_number = error_number + G_ES_EXE_TAX_STS_INVALID
4600: WHERE (( tax_status_code IS NOT NULL
4601: AND NOT EXISTS
4602: (

Line 4669: UPDATE zx_exemptions_int exe_int

4665: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4666: END IF;
4667:
4668: -- value to id conversion for tax_status_code
4669: UPDATE zx_exemptions_int exe_int
4670: SET tax_status_code = (
4671: SELECT zsvl.TAX_STATUS_CODE
4672: FROM zx_status_vl zsvl,
4673: zx_subscription_details zsd

Line 4709: UPDATE zx_exemptions_int exe_int

4705: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4706: END IF;
4707:
4708: -- validating the fields tax_jurisdictin_code and tax_jurisdiction_name
4709: UPDATE zx_exemptions_int exe_int
4710: SET error_number = error_number + G_ES_EXE_TAX_JUR_INVALID
4711: WHERE ( tax_jurisdiction_id IS NOT NULL
4712: OR tax_jurisdiction_name IS NOT NULL
4713: )

Line 4724: UPDATE zx_exemptions_int exe_int

4720: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4721: END IF;
4722:
4723: -- validating the fields tax_jurisdiction_id and tax_jurisdiction_name
4724: UPDATE zx_exemptions_int exe_int
4725: SET error_number = error_number + G_ES_EXE_TAX_JUR_INVALID
4726: WHERE (( tax_jurisdiction_id IS NOT NULL
4727: AND NOT EXISTS
4728: (

Line 4762: UPDATE zx_exemptions_int exe_int

4758: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4759: END IF;
4760:
4761: -- value to id conversion for tax_jurisdictin_code
4762: UPDATE zx_exemptions_int exe_int
4763: SET tax_jurisdiction_id = (
4764: SELECT tax_jurisdiction_id
4765: FROM ZX_JURISDICTIONS_VL
4766: WHERE TAX_REGIME_CODE = exe_int.tax_regime_code

Line 4784: UPDATE zx_exemptions_int exe_int

4780: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4781: END IF;
4782:
4783: -- validating the fields tax_rate_code and tax_rate_name
4784: UPDATE zx_exemptions_int exe_int
4785: SET error_number = error_number + G_ES_EXE_TAX_RATE_INVALID
4786: WHERE (( tax_rate_code IS NOT NULL
4787: AND NOT EXISTS
4788: (

Line 4856: UPDATE zx_exemptions_int exe_int

4852: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4853: END IF;
4854:
4855: -- value to id conversion for tax_rate_code
4856: UPDATE zx_exemptions_int exe_int
4857: SET TAX_RATE_CODE = (
4858: SELECT zrvl.tax_rate_code
4859: FROM zx_rates_vl zrvl, zx_subscription_details sd
4860: WHERE zrvl.tax_regime_code = sd.tax_regime_code

Line 4897: UPDATE zx_exemptions_int exe_int

4893: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4894: END IF;
4895:
4896: -- Validate the fields apply_to_lower_levels_flag
4897: UPDATE zx_exemptions_int exe_int
4898: SET error_number = error_number + G_ES_EXE_LWR_LVL_FLG_INVALID
4899: WHERE record_status = G_RS_IN_PROCESS
4900: AND request_id = G_REQUEST_ID
4901: AND apply_to_lower_levels_flag NOT IN ('Y','N');

Line 4909: UPDATE zx_exemptions_int exe_int

4905: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4906: END IF;
4907:
4908: -- Validate the fields effective_to and effective_from
4909: UPDATE zx_exemptions_int exe_int
4910: SET error_number = error_number + G_ES_EXE_DATE_RANGE_INVALID
4911: WHERE record_status = G_RS_IN_PROCESS
4912: AND request_id = G_REQUEST_ID
4913: AND effective_to IS NOT NULL

Line 4922: UPDATE zx_exemptions_int exe_int

4918: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4919: END IF;
4920:
4921: -- validating the fields inventory_org_id, inventory_org_name
4922: UPDATE zx_exemptions_int exe_int
4923: SET error_number = error_number + G_ES_EXE_INV_ORG_INVALID
4924: WHERE (( inventory_org_id IS NOT NULL
4925: AND NOT EXISTS
4926: (

Line 4974: UPDATE zx_exemptions_int exe_int

4970: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4971: END IF;
4972:
4973: -- value to id conversion for inventory_org_id
4974: UPDATE zx_exemptions_int exe_int
4975: SET Inventory_Org_id =
4976: (
4977: SELECT OOD.ORGANIZATION_ID
4978: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

Line 5003: UPDATE zx_exemptions_int exe_int

4999: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5000: END IF;
5001:
5002: -- validating the fields item_number, inventory_item_id
5003: UPDATE zx_exemptions_int exe_int
5004: SET error_number = error_number + G_ES_EXE_INV_ITM_INVALID
5005: WHERE (( inventory_item_id IS NOT NULL
5006: AND NOT EXISTS
5007: (

Line 5036: UPDATE zx_exemptions_int exe_int

5032: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5033: END IF;
5034:
5035: -- value to id conversion for inventory_item_id
5036: UPDATE zx_exemptions_int exe_int
5037: SET inventory_item_id =
5038: (
5039: SELECT inventory_item_id
5040: FROM MTL_SYSTEM_ITEMS_B_KFV

Line 5057: UPDATE zx_exemptions_int exe_int

5053: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5054: END IF;
5055:
5056: -- validating the fields issuing_tax_authority_id, issuing_tax_authority_name
5057: UPDATE zx_exemptions_int exe_int
5058: SET error_number = error_number + G_ES_EXE_TAX_AUT_INVALID
5059: WHERE (( issuing_tax_authority_id IS NOT NULL
5060: AND NOT EXISTS
5061: (

Line 5093: UPDATE zx_exemptions_int exe_int

5089: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5090: END IF;
5091:
5092: -- value to id conversion for issuing_tax_authority_id
5093: UPDATE zx_exemptions_int exe_int
5094: SET issuing_tax_authority_id =
5095: (
5096: SELECT PTP.party_tax_profile_id
5097: FROM zx_party_tax_profile PTP,

Line 5115: UPDATE zx_exemptions_int exe_int

5111: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5112: END IF;
5113:
5114: -- validating the fields exemption_type_code and exemption_type_name
5115: UPDATE zx_exemptions_int exe_int
5116: SET error_number = error_number + G_ES_EXE_EXMPT_TYP_INVALID
5117: WHERE (( exemption_type_code IS NOT NULL
5118: AND NOT EXISTS
5119: (

Line 5153: UPDATE zx_exemptions_int exe_int

5149: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5150: END IF;
5151:
5152: -- value to id conversion for exemption_type_code
5153: UPDATE zx_exemptions_int exe_int
5154: SET exemption_type_code = (
5155: SELECT fndlookup.lookup_code
5156: FROM fnd_lookups fndlookup
5157: WHERE fndlookup.lookup_type = 'ZX_EXEMPTION_TYPE'

Line 5230: p_zx_exempt_rec IN zx_exemptions_int%ROWTYPE

5226: RAISE;
5227: END resetDFFFieldUsage;
5228:
5229: FUNCTION getAttrValue (
5230: p_zx_exempt_rec IN zx_exemptions_int%ROWTYPE
5231: ,p_column_name IN VARCHAR2
5232: ) RETURN VARCHAR2 IS
5233: BEGIN
5234:

Line 5315: l_last_attribute_category zx_exemptions_int.attribute_category%TYPE;

5311:
5312: l_std_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5313: l_dff_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5314:
5315: l_last_attribute_category zx_exemptions_int.attribute_category%TYPE;
5316: l_global_data_elements zx_exemptions_int.attribute_category%TYPE;
5317: l_global_ctx_index NUMBER;
5318:
5319: l_count NUMBER;

Line 5316: l_global_data_elements zx_exemptions_int.attribute_category%TYPE;

5312: l_std_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5313: l_dff_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5314:
5315: l_last_attribute_category zx_exemptions_int.attribute_category%TYPE;
5316: l_global_data_elements zx_exemptions_int.attribute_category%TYPE;
5317: l_global_ctx_index NUMBER;
5318:
5319: l_count NUMBER;
5320:

Line 5323: FROM zx_exemptions_int

5319: l_count NUMBER;
5320:
5321: CURSOR c_exempt_records IS
5322: SELECT *
5323: FROM zx_exemptions_int
5324: WHERE request_id = G_REQUEST_ID
5325: AND record_status = G_RS_IN_PROCESS
5326: ORDER BY attribute_category desc
5327: FOR UPDATE;

Line 5453: UPDATE zx_exemptions_int

5449: IF NOT FND_FLEX_DESCVAL.validate_desccols
5450: (appl_short_name => 'ZX'
5451: ,desc_flex_name => 'ZX_EXEMPTIONS'
5452: ) THEN
5453: UPDATE zx_exemptions_int
5454: SET error_number = error_number + G_ES_EXE_DFF_INVALID,
5455: prog_int_char1 = fnd_flex_descval.error_message
5456: WHERE CURRENT OF c_exempt_records;
5457: ELSE

Line 5459: UPDATE zx_exemptions_int intf

5455: prog_int_char1 = fnd_flex_descval.error_message
5456: WHERE CURRENT OF c_exempt_records;
5457: ELSE
5458: -- set to NULL all other DFF fields which are not defined
5459: UPDATE zx_exemptions_int intf
5460: SET attribute1 = DECODE(G_DFF_USAGE_RECORD.attribute1,G_TRUE,intf.attribute1,NULL)
5461: ,attribute2 = DECODE(G_DFF_USAGE_RECORD.attribute1,G_TRUE,intf.attribute2,NULL)
5462: ,attribute3 = DECODE(G_DFF_USAGE_RECORD.attribute1,G_TRUE,intf.attribute3,NULL)
5463: ,attribute4 = DECODE(G_DFF_USAGE_RECORD.attribute1,G_TRUE,intf.attribute4,NULL)

Line 5481: UPDATE zx_exemptions_int

5477: END LOOP;
5478: ELSE
5479: -- no context fields defined.
5480: -- flag all record where customer has populated data into attributes
5481: UPDATE zx_exemptions_int
5482: SET error_number = error_number + G_ES_EXE_DFF_INVALID,
5483: prog_int_char1 = 'Attributes have been populated but no Context has been defined.'
5484: WHERE request_id = G_REQUEST_ID
5485: AND record_status = G_RS_IN_PROCESS

Line 5994: UPDATE zx_exemptions_int exe_int

5990: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5991: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
5992: END IF;
5993:
5994: UPDATE zx_exemptions_int exe_int
5995: SET party_tax_profile_id =
5996: (
5997: SELECT party_tax_profile_id
5998: FROM zx_party_tax_profile_int ptp_int

Line 6408: FROM zx_exemptions_int

6404: PARTY_TAX_PROFILE_ID,
6405: NULL, --CUST_ACCOUNT_ID,
6406: NULL, --SITE_USE_ID,
6407: 0 --DUPLICATE_EXEMPTION
6408: FROM zx_exemptions_int
6409: WHERE record_status = G_RS_VALID
6410: AND request_id = G_REQUEST_ID
6411: AND error_number = 0);
6412:

Line 6508: FROM zx_exemptions_int exe_int, zx_party_tax_profile_int ptp_int

6504: AND ptp_int.request_id = reg_int.request_id;
6505:
6506: CURSOR c_exe_errors IS
6507: SELECT ptp_int.party_type_code, ptp_int.party_id, exe_int.*
6508: FROM zx_exemptions_int exe_int, zx_party_tax_profile_int ptp_int
6509: WHERE exe_int.request_id = G_REQUEST_ID
6510: AND exe_int.record_status = G_RS_ERROR
6511: AND ptp_int.intf_ptp_reference = exe_int.intf_ptp_reference
6512: AND ptp_int.request_id = exe_int.request_id;

Line 8196: FROM zx_exemptions_int

8192: ,l_msg_header_unit_length,' ');
8193:
8194: SELECT NVL(SUM(DECODE(record_status,G_RS_ERROR,1,0)),0), NVL(SUM(1),0)
8195: INTO l_count_exception_records, l_count_success_records
8196: FROM zx_exemptions_int
8197: WHERE request_id = G_REQUEST_ID;
8198: l_message_line1 := l_message_line1
8199: || RPAD(l_tot_records_msg||' '||l_count_success_records,
8200: l_msg_header_unit_length,' ');