DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on ENG_CHANGE_POLICY_PKG

Line 901: ENG_CHANGE_POLICY_PKG.GetChangePolicy

897: l_is_policy := 'Y';
898: -- finding the policy for each operational attribute
899: FOR rec in cr_op_attr_grps LOOP
900: Debug_Message('Getting change Policy for operational attribute Attr_Group_Id, Attr_Group_Name='||TO_CHAR(rec.ATTR_GROUP_ID)||', '||rec.ATTR_GROUP_NAME);
901: ENG_CHANGE_POLICY_PKG.GetChangePolicy
902: ( p_policy_object_name => 'CATALOG_LIFECYCLE_PHASE'
903: , p_policy_code => 'CHANGE_POLICY'
904: , p_policy_pk1_value => l_catalog_id
905: , p_policy_pk2_value => l_lifecycle_id

Line 1580: ENG_CHANGE_POLICY_PKG.GetChangePolicy

1576: Debug_Message('Processing attribute group - '||rec_attr.ATTR_GROUP_INT_NAME);
1577: -- if change policy may be present THEN get the Change policy for each attr grp
1578: IF (l_is_policy = 'Y') THEN
1579: Debug_Message('Getting change policy for attribute group - '||rec_attr.ATTR_GROUP_INT_NAME);
1580: ENG_CHANGE_POLICY_PKG.GetChangePolicy
1581: ( p_policy_object_name => 'CATALOG_LIFECYCLE_PHASE'
1582: , p_policy_code => 'CHANGE_POLICY'
1583: , p_policy_pk1_value => l_catalog_id
1584: , p_policy_pk2_value => l_lifecycle_id

Line 2034: ENG_CHANGE_POLICY_PKG.GetChangePolicy

2030: Debug_Message('With Data Level: ' || rec_attr.DATA_LEVEL_ID);
2031: -- if change policy may be present THEN get the Change policy for each attr grp
2032: IF (l_is_policy = 'Y') THEN
2033: Debug_Message('Getting change policy for attribute group - '||rec_attr.ATTR_GROUP_INT_NAME);
2034: ENG_CHANGE_POLICY_PKG.GetChangePolicy
2035: ( p_policy_object_name => 'CATALOG_LIFECYCLE_PHASE'
2036: , p_policy_code => 'CHANGE_POLICY'
2037: , p_policy_pk1_value => l_catalog_id
2038: , p_policy_pk2_value => l_lifecycle_id

Line 2536: ENG_CHANGE_POLICY_PKG.GetChangePolicy

2532: -- Finding the Change Policy for an Attribute Group
2533: -- The condition (l_attGrp_old <> l_attGrp_new) is to calculate Change Policy only once for
2534: -- each Attribute Group.
2535: IF l_attGrp_old <> l_attGrp_new AND l_is_policy = 'Y' THEN
2536: ENG_CHANGE_POLICY_PKG.GetChangePolicy
2537: ( p_policy_object_name => 'CATALOG_LIFECYCLE_PHASE'
2538: , p_policy_code => 'CHANGE_POLICY'
2539: , p_policy_pk1_value => l_catalog_id
2540: , p_policy_pk2_value => l_lifecycle_id

Line 2676: ENG_CHANGE_POLICY_PKG.GetChangePolicy

2672: -- Finding the Change Policy for an Attribute Group
2673: -- The condition (l_attGrp_old <> l_attGrp_new) is to calculate Change Policy only once for
2674: -- each Attribute Group.
2675: IF l_attGrp_old <> l_attGrp_new AND l_is_policy = 'Y' THEN
2676: ENG_CHANGE_POLICY_PKG.GetChangePolicy
2677: ( p_policy_object_name => 'CATALOG_LIFECYCLE_PHASE'
2678: , p_policy_code => 'CHANGE_POLICY'
2679: , p_policy_pk1_value => l_catalog_id
2680: , p_policy_pk2_value => l_lifecycle_id