APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_FORMULA_DETAILS

Line 730: * ZX_FORMULA_TL and ZX_FORMULA_DETAILS. *

726:
727: /****************************************************************************************
728: * Procedure: CREATE_FORMULA *
729: * Based on the input parameters, row(s) would be created in to , *
730: * ZX_FORMULA_TL and ZX_FORMULA_DETAILS. *
731: *****************************************************************************************/
732:
733:
734: PROCEDURE CREATE_FORMULA

Line 743: -- for zx_formula_details

739: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
740: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
741: p_discount_flag IN CHAR,
742: p_charge_flag IN CHAR,
743: -- for zx_formula_details
744: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
745: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
746: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
747: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,

Line 904: -- Inserting values in table zx_formula_details

900: x_return_status := FND_API.G_RET_STS_ERROR;
901: RETURN;
902: END;
903:
904: -- Inserting values in table zx_formula_details
905:
906: arp_util_tax.debug('l_formula_id:'|| l_formula_id);
907:
908:

Line 913: INSERT INTO zx_formula_details (

909: IF p_taxable_basis = 'PRIOR_TAX' THEN
910:
911: BEGIN
912:
913: INSERT INTO zx_formula_details (
914: formula_detail_id,
915: formula_id,
916: compounding_tax_regime_code,
917: compounding_tax,

Line 932: zx_formula_details_s.NEXTVAL,

928: program_login_id,
929: object_version_number
930: )
931: SELECT
932: zx_formula_details_s.NEXTVAL,
933: l_formula_id,
934: p_parent_regime_code,
935: p_parent_tax_code,
936: 'ADD',

Line 953: FROM zx_formula_details, zx_formula_b

949: WHERE t.child_regime_code = p_child_regime_code
950: AND t.child_tax_code = p_child_tax_code
951: AND t.tax_group_id = p_group_id
952: AND NOT EXISTS (SELECT 1
953: FROM zx_formula_details, zx_formula_b
954: WHERE zx_formula_details.formula_id = l_formula_id
955: AND compounding_tax_regime_code = p_parent_regime_code
956: AND compounding_tax = p_parent_tax_code
957: --AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

Line 954: WHERE zx_formula_details.formula_id = l_formula_id

950: AND t.child_tax_code = p_child_tax_code
951: AND t.tax_group_id = p_group_id
952: AND NOT EXISTS (SELECT 1
953: FROM zx_formula_details, zx_formula_b
954: WHERE zx_formula_details.formula_id = l_formula_id
955: AND compounding_tax_regime_code = p_parent_regime_code
956: AND compounding_tax = p_parent_tax_code
957: --AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0
958: )

Line 974: INSERT INTO zx_formula_details (

970: ELSIF p_taxable_basis <> 'PRIOR_TAX' THEN
971:
972: BEGIN
973:
974: INSERT INTO zx_formula_details (
975: formula_detail_id,
976: formula_id,
977: compounding_tax,
978: compounding_tax_regime_code,

Line 992: SELECT zx_formula_details_s.NEXTVAL,

988: program_id,
989: program_login_id,
990: object_version_number
991: )
992: SELECT zx_formula_details_s.NEXTVAL,
993: l_formula_id, -- Bug 8429806
994: p_parent_tax_code, -- 8726049
995: parent_regime_code,
996: 'ADD',

Line 1013: FROM zx_formula_details, zx_formula_b

1009: WHERE t.child_regime_code = p_child_regime_code
1010: AND t.child_tax_code = p_child_tax_code
1011: AND t.tax_group_id = p_group_id
1012: AND NOT EXISTS (SELECT 1
1013: FROM zx_formula_details, zx_formula_b
1014: WHERE zx_formula_details.formula_id = l_formula_id -- Bug 8429806
1015: AND compounding_tax_regime_code = p_parent_regime_code
1016: AND compounding_tax = p_parent_tax_code
1017: -- AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0

Line 1014: WHERE zx_formula_details.formula_id = l_formula_id -- Bug 8429806

1010: AND t.child_tax_code = p_child_tax_code
1011: AND t.tax_group_id = p_group_id
1012: AND NOT EXISTS (SELECT 1
1013: FROM zx_formula_details, zx_formula_b
1014: WHERE zx_formula_details.formula_id = l_formula_id -- Bug 8429806
1015: AND compounding_tax_regime_code = p_parent_regime_code
1016: AND compounding_tax = p_parent_tax_code
1017: -- AND contains(zx_formula_b.formula_code, t.tax_group_code) > 0
1018: )