[Home] [Help]
43: IS
44: CURSOR cur_gst_regime IS
45: SELECT 'Y'
46: FROM JAI_RGM_DEFINITIONS jrd
47: WHERE jrd.regime_code IN (jai_constants.sgst_regime,jai_constants.cgst_regime);
48:
49: v_gst_enabled VARCHAR2(1) := 'N';
50:
51: BEGIN
385: ----------------------------------------------------------------------------------------------------------------------------------------------------
386:
387:
388: ----------------------------------------------------------------------------------------------------------------------------------------------------*/
389: v_debug := jai_constants.NO; --rpokkula for File.Sql.35
390: -- Add by Xiao to get release version on 24-Jul-2009
391: lb_result := fnd_release.get_release(lv_release_name,
392: lv_other_release_info);
393:
1115: SELECT to_number(accnts.attribute_value)
1116: FROM jai_rgm_registrations tax_types,
1117: jai_rgm_org_regns_v accnts
1118: WHERE tax_types.regime_id = cp_regime_id
1119: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1120: AND tax_types.attribute_code = cp_tax_type
1121: AND accnts.regime_id = tax_types.regime_id
1122: AND accnts.registration_type = jai_constants.regn_type_accounts
1123: AND accnts.parent_registration_id = tax_types.registration_id
1118: WHERE tax_types.regime_id = cp_regime_id
1119: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1120: AND tax_types.attribute_code = cp_tax_type
1121: AND accnts.regime_id = tax_types.regime_id
1122: AND accnts.registration_type = jai_constants.regn_type_accounts
1123: AND accnts.parent_registration_id = tax_types.registration_id
1124: AND accnts.attribute_code = cp_account_name
1125: AND accnts.organization_type = cp_organization_type
1126: AND accnts.organization_id = cp_organization_id
1133: BEGIN
1134:
1135: lv_regime_code := get_regime_code(p_regime_id);
1136:
1137: IF lv_regime_code in (jai_constants.cgst_regime, jai_constants.sgst_regime) THEN /* Use Package Variables -- Shyam */
1138:
1139: IF p_organization_type = jai_constants.orgn_type_io THEN
1140: ln_location_id := p_location_id;
1141: ELSIF p_organization_type = jai_constants.orgn_type_ou THEN
1135: lv_regime_code := get_regime_code(p_regime_id);
1136:
1137: IF lv_regime_code in (jai_constants.cgst_regime, jai_constants.sgst_regime) THEN /* Use Package Variables -- Shyam */
1138:
1139: IF p_organization_type = jai_constants.orgn_type_io THEN
1140: ln_location_id := p_location_id;
1141: ELSIF p_organization_type = jai_constants.orgn_type_ou THEN
1142: ln_location_id := NULL;
1143: END IF;
1137: IF lv_regime_code in (jai_constants.cgst_regime, jai_constants.sgst_regime) THEN /* Use Package Variables -- Shyam */
1138:
1139: IF p_organization_type = jai_constants.orgn_type_io THEN
1140: ln_location_id := p_location_id;
1141: ELSIF p_organization_type = jai_constants.orgn_type_ou THEN
1142: ln_location_id := NULL;
1143: END IF;
1144:
1145: OPEN c_orgn_tax_type_account(p_regime_id,
1182: ln_tax_code jai_cmn_taxes_all.tax_name%TYPE;
1183: v_debug char(1);
1184:
1185: BEGIN
1186: v_debug := jai_constants.NO;
1187:
1188: OPEN c_get_tax_code(pn_tax_id);
1189: FETCH c_get_tax_code INTO ln_tax_code;
1190: CLOSE c_get_tax_code;
1215: v_debug char(1);
1216:
1217:
1218: BEGIN
1219: v_debug := jai_constants.NO;
1220:
1221: OPEN c_get_tax_type_code(pn_tax_id);
1222: FETCH c_get_tax_type_code INTO ln_tax_type_code;
1223: CLOSE c_get_tax_type_code;
1248: ln_tax_type_id jai_cmn_taxes_all.tax_type_id%TYPE;
1249: ln_tax_regim_id jai_cmn_tax_types_all.regime_id%TYPE;
1250: v_debug char(1);
1251: BEGIN
1252: v_debug := jai_constants.NO;
1253:
1254: OPEN c_get_tax_regime_id(pn_tax_type_code);
1255: FETCH c_get_tax_regime_id INTO ln_tax_regim_id;
1256: CLOSE c_get_tax_regime_id;
1283: lv_attribute_value jai_rgm_registrations.attribute_value%TYPE;
1284: v_debug char(1);
1285:
1286: BEGIN
1287: v_debug := jai_constants.NO;
1288:
1289: OPEN get_others_attribute_value(pn_regime_id);
1290: FETCH get_others_attribute_value INTO lv_attribute_value;
1291: CLOSE get_others_attribute_value;
1378:
1379: BEGIN
1380:
1381:
1382: v_debug := jai_constants.NO;
1383:
1384: ln_regime_id := get_tax_regime_id_by_taxtype(pv_tax_type_code);
1385: lv_setup_type := get_regim_accounting_parameter(ln_regime_id);
1386:
1388: ln_location_id := pn_location_id;
1389: IF (lv_setup_type = 'TAX TYPE')
1390: THEN
1391: lv_attribute_code := pv_tax_type_code ;
1392: IF (pv_account_source = jai_constants.source_ar)
1393: THEN
1394: lv_account_class := 'LIABILITY';
1395: IF (pv_trx_type = 'MANUAL')
1396: THEN
1408: CLOSE get_account_setup;
1409:
1410: END IF; -- (pv_trx_type = 'MANUAL')
1411: END IF; -- (pv_account_source = 'AR')
1412: IF (pv_account_source = jai_constants.source_ap)
1413: THEN
1414: lv_account_class := 'RECOVERY';
1415: IF (pv_trx_type = 'MANUAL')
1416: THEN
1430:
1431: IF (lv_setup_type = 'TAX CODE')
1432: THEN
1433: lv_attribute_code := get_tax_code(pn_tax_id);
1434: IF (pv_account_source = jai_constants.source_ar)
1435: THEN
1436: lv_account_class := 'LIABILITY';
1437: IF (pv_trx_type = 'MANUAL')
1438: THEN
1450: CLOSE get_account_setup;
1451:
1452: END IF; -- (pv_trx_type = 'MANUAL')
1453: END IF; -- (pv_account_source = 'AR')
1454: IF (pv_account_source = jai_constants.source_ap)
1455: THEN
1456: lv_account_class := 'RECOVERY';
1457: IF (pv_trx_type = 'MANUAL')
1458: THEN