APPS.AMS_DELIVERABLERULES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

   SELECT 'Y'
   FROM   ams_custom_setup_attr
   WHERE  custom_setup_id = p_custom_setup_id
   AND    object_attribute IN ('ECON'); --,'CPAGE') ;

Line: 38

   SELECT custom_setup_id
   FROM ams_deliverables_all_b
   WHERE deliverable_id = p_deliverable_id;

Line: 120

PROCEDURE update_delv_status(
    p_deliverable_id   IN   NUMBER
   ,p_user_status_id   IN   NUMBER
)
IS

   l_budget_exist      NUMBER;

Line: 138

   SELECT user_status_id, object_version_number,
          status_code,custom_setup_id
   FROM   ams_deliverables_all_b
   WHERE  deliverable_id = p_deliverable_id;

Line: 144

   SELECT 1
   FROM   DUAL
   WHERE  EXISTS(
          SELECT 1
          FROM   ams_act_budgets
          WHERE  arc_act_budget_used_by = 'DELV'
          AND    act_budget_used_by_id = p_deliverable_id);

Line: 254

   update_status(p_deliverable_id      =>   p_deliverable_id,
                 p_new_status_id    =>   l_new_status_id,
                 p_new_status_code  =>   AMS_Utility_PVT.get_system_status_code(l_new_status_id)
                                 ) ;

Line: 259

END update_delv_status;

Line: 271

PROCEDURE update_status(
    p_deliverable_id          IN   NUMBER
   ,p_new_status_id           IN   NUMBER
   ,p_new_status_code         IN   VARCHAR2
   )
IS

--   CURSOR c_get_type IS
--   SELECT d.can_fulfill_electronic_flag
--   FROM ams_custom_Setup_attr a
--       ,ams_custom_setups_b b
--       ,ams_deliverables_vl d
--   WHERE a.object_attribute  = 'ECON'
--   AND a.custom_Setup_id = b.custom_setup_id
--   AND b.object_type ='DELV'
--   AND d.custom_setup_id = b.custom_setup_id
--   AND d.deliverable_id = p_deliverable_id;

Line: 319

   UPDATE ams_deliverables_all_b
   SET    user_status_id = p_new_status_id,
          status_code = p_new_status_code,
          status_date = SYSDATE,
          private_flag = DECODE(p_new_status_code,'AVAILABLE','N',private_flag)
   WHERE  deliverable_id = p_deliverable_id;

Line: 326

END update_status;

Line: 363

     SELECT ci.content_item_id, ver.citem_version_id, ci.object_version_number, content_item_status
     FROM ibc_associations assoc,ibc_content_items ci , ibc_citem_versions_vl ver
      WHERE assoc.associated_object_val1 = to_char(p_deliverable_id)  ---musman: bug 4145845 Fix
      AND ci.content_type_code = 'IBC_CONTENT_BLOCK'     --anchaudh on 27 Oct '03: changed AMF_EMAIL_DELIVERABLE to IBC_CONTENT_BLOCK
      AND ci.content_item_id = ver.content_item_id
      --AND ci.content_type_code = assoc.association_type_code
      AND assoc.association_type_code = 'AMS_DELV'
      AND assoc.content_item_id = ci.content_item_id
      AND ver.citem_Version_id = (select max(citem_version_id) from ibc_citem_versions_b where content_item_id = ci.content_item_id);