APPS.ASO_APR_INT SQL Statements

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

Line: 19

      SELECT full_name
      FROM per_all_people_f
      WHERE person_id = c_person_id
            AND SYSDATE BETWEEN effective_start_date
                            AND NVL (
                                  effective_end_date,
                                  SYSDATE
                                );

Line: 32

      SELECT source_name
      FROM jtf_rs_resource_extns
      WHERE user_id = c_user_id
            AND SYSDATE BETWEEN start_date_active
                            AND NVL (
                                  end_date_active,
                                  SYSDATE
                                );

Line: 629

      SELECT NVL (
               (MAX (
                  approval_instance_id
                ) + 1
               ),
               1
             )
      FROM aso_apr_obj_approvals
      WHERE object_id = c_object_id;

Line: 640

   select employee_id
   from fnd_user
   where user_id = l_user_id;

Line: 645

    SELECT count(*)
    FROM   aso_apr_obj_approvals
    WHERE  object_id = p_object_id
    AND    approval_status = 'PEND';

Line: 858

        'Inserting a row into the header table ',
        1,
        'N'
      );

Line: 865

    aso_apr_approvals_pkg.header_insert_row (
      p_object_approval_id,
      p_object_id,
      p_object_type,
      p_approval_instance_id,
      'PEND',
      p_application_id,
      SYSDATE -- p_START_DATE
      ,
      NULL -- p_END_DATE
      ,
      SYSDATE -- p_CREATION_DATE
      ,
      g_user_id -- p_CREATED_BY
      ,
      SYSDATE -- p_LAST_UPDATE_DATE
      ,
      g_user_id -- P_UPDATED_BY
      ,
      fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
      ,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
      NULL,
	 NULL -- p_CONTEXT
      ,
      NULL -- p_SECURITY_GROUP_ID
      ,
      NULL -- p_OBJECT_VERSION_NUMBER
      ,
      g_user_id -- p_REQUESTER_USERID
      ,
      p_requester_comments -- p_REQUESTER_COMMENTS
      ,
      l_requester_group_id -- p_REQUESTER_GROUP_ID
    );

Line: 1016

            'Inserting  rows into the detail table ',
            1,
            'N'
          );

Line: 1022

        aso_apr_approvals_pkg.detail_insert_row (
          p_approval_det_id,
          p_object_approval_id,
          l_employee_id  --p_APPROVER_PERSON_ID
          ,
          x_approvers_list (
            i
          ).approver_user_id ---p_APPROVER_USER_ID
          ,
          i -- P_APPROVER_SEQUENCE
          ,
          l_approver_status -- p_APPROVER_STATUS
          ,
          NULL -- p_APPROVER_COMMENTS
          ,
          NULL -- p_DATE_SENT
          ,
          NULL -- p_DATE_RECEIVED
          ,
          SYSDATE -- p_CREATION_DATE
          ,
          SYSDATE -- p_LAST_UPDATE_DATE
          ,
          g_user_id -- P_CREATED_BY
          ,
          g_user_id -- P_UPDATED_BY
          ,
          fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
          ,
          NULL -- p_ATTRIBUTE1
          ,
          NULL -- p_ATTRIBUTE2
          ,
          NULL -- p_ATTRIBUTE3
          ,
          NULL -- p_ATTRIBUTE4
          ,
          NULL -- p_ATTRIBUTE5
          ,
          NULL -- p_ATTRIBUTE6
          ,
          NULL -- p_ATTRIBUTE7
          ,
          NULL -- p_ATTRIBUTE8
          ,
          NULL -- p_ATTRIBUTE9
          ,
          NULL -- p_ATTRIBUTE10
          ,
          NULL -- p_ATTRIBUTE11
          ,
          NULL -- p_ATTRIBUTE12
          ,
          NULL -- p_ATTRIBUTE13
          ,
          NULL -- p_ATTRIBUTE14
          ,
          NULL -- p_ATTRIBUTE15
          ,
          NULL -- p_Attribute16
		,
          NULL -- p_Attribute17
		,
          NULL  -- p_Attribute18
		,
          NULL -- p_Attribute19
		,
          NULL -- p_Attribute20
		,
		NULL   -- p_CONTEXT
          ,
          NULL -- p_SECURITY_GROUP_ID
          ,
          NULL -- p_OBJECT_VERSION_NUMBER
        );

Line: 1101

          'Inserting rows into the rule table ',
          1,
          'N'
        );

Line: 1109

        aso_apr_approvals_pkg.rule_insert_row (
          p_rule_id,
          x_rules_list (
            i
          ).rule_id,
          x_rules_list (
            i
          ).rule_action_id,
          SYSDATE -- P_CREATION_DATE
          ,
          g_user_id -- P_CREATED_BY
          ,
          SYSDATE -- p_LAST_UPDATE_DATE
          ,
          g_user_id -- P_UPDATED_BY
          ,
          fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
          ,
          p_object_approval_id,
          NULL -- p_ATTRIBUTE1
          ,
          NULL -- p_ATTRIBUTE2
          ,
          NULL -- p_ATTRIBUTE3
          ,
          NULL -- p_ATTRIBUTE4
          ,
          NULL -- p_ATTRIBUTE5
          ,
          NULL -- p_ATTRIBUTE6
          ,
          NULL -- p_ATTRIBUTE7
          ,
          NULL -- p_ATTRIBUTE8
          ,
          NULL -- p_ATTRIBUTE9
          ,
          NULL -- p_ATTRIBUTE10
          ,
          NULL -- p_ATTRIBUTE11
          ,
          NULL -- p_ATTRIBUTE12
          ,
          NULL -- p_ATTRIBUTE13
          ,
          NULL -- p_ATTRIBUTE14
          ,
          NULL -- p_ATTRIBUTE15
          ,
          NULL -- p_Attribute16
          ,
          NULL -- p_Attribute17
          ,
          NULL  -- p_Attribute18
          ,
          NULL -- p_Attribute19
          ,
          NULL -- p_Attribute20
          ,
          NULL -- p_CONTEXT
          ,
          NULL -- p_SECURITY_GROUP_ID
          ,
          NULL -- p_OBJECT_VERSION_NUMBER
        );

Line: 1189

      update aso_apr_obj_approvals
	 set approval_status = 'APPR',
	     end_date = sysdate
	 where object_approval_id = p_object_approval_id;

Line: 1330

      SELECT object_approval_id
      FROM aso_apr_obj_approvals
      WHERE object_id = c_object_id
            AND object_type = c_object_type
            AND approval_instance_id = (SELECT MAX (
                                                 approval_instance_id
                                               )
                                        FROM aso_apr_obj_approvals
                                        WHERE object_id = c_object_id
                                              AND object_type = c_object_type);

Line: 1680

     SELECT oam_rule_id,rule_id
     FROM   aso_apr_rules
     WHERE  object_approval_id = c_obj_app_id;

Line: 1989

    p_last_update_date          IN             DATE,
    x_obj_ver_num               OUT NOCOPY     NUMBER,
    x_last_update_date          OUT NOCOPY     DATE,
    x_return_status             OUT NOCOPY /* file.sql.39 change */      VARCHAR2,
    x_msg_count                 OUT NOCOPY /* file.sql.39 change */      NUMBER,
    x_msg_data                  OUT NOCOPY /* file.sql.39 change */      VARCHAR2
  )
IS

    l_api_name                  CONSTANT VARCHAR2 (240) := 'upd_status_self_appr';

Line: 1999

    l_last_update_date          DATE;

Line: 2004

    select last_update_date,object_version_number
    from aso_quote_headers_all
    where quote_header_id = l_qte_hdr_id;

Line: 2009

    SELECT Quote_Status_Id
    FROM ASO_QUOTE_STATUSES_B
    WHERE Status_Code = 'APPROVAL PENDING';

Line: 2027

       aso_debug_pub.add('upd_status_self_appr: p_last_update_date:  || p_last_update_date ', 1, 'Y');

Line: 2031

      Fetch c_get_qte_info into l_LAST_UPDATE_DATE,l_object_version_number;

Line: 2034

              FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');

Line: 2043

          aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE:      '|| l_LAST_UPDATE_DATE, 1, 'Y');

Line: 2047

      If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
              FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

Line: 2050

              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 2057

      If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
              FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

Line: 2074

     x_last_update_date := sysdate;

Line: 2078

    update aso_quote_headers_all
    set    quote_status_id       = l_status_id,
           object_version_number = x_obj_ver_num,
           last_update_date      = x_last_update_date
    where  quote_header_id = p_qte_hdr_id;