APPS.CHV_CONFIRM_SCHEDULES SQL Statements

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

Line: 46

      UPDATE chv_schedule_items
      SET    item_confirm_status = 'CONFIRMED',
             last_update_date    = SYSDATE,
             last_updated_by     = x_user_id,
             last_update_login   = x_login_id
      WHERE  schedule_item_id    = p_schedule_item_id ;

Line: 66

      INSERT INTO po_interface_errors(interface_type,
                                      interface_transaction_id,
                                      column_name,
                                      error_message,
                                      processing_date,
                                      creation_date,
                                      created_by,
                                      last_update_date,
                                      last_updated_by,
                                      last_update_login)
                               VALUES('SCHEDULE_BUILD',
                                      p_schedule_item_id,
                                      'ITEM_CONFIRM_STATUS',
				      x_message,
                                      SYSDATE,
                                      SYSDATE,
                                      x_user_id,
                                      SYSDATE,
                                      x_user_id,
                                      x_login_id);

Line: 145

    SELECT csh.schedule_horizon_start,
	   csh.vendor_id,
	   csh.vendor_site_id,
           csi.schedule_item_id,
           csi.item_id,
           csi.organization_id,
           csi.item_confirm_status,
           csi.primary_unit_of_measure,
	   csi.purchasing_unit_of_measure,
           coo.enable_cum_flag
    FROM   chv_schedule_items csi,
           chv_schedule_headers csh,
	   chv_org_options coo
    WHERE  csi.schedule_id     =    p_schedule_id
    AND    csi.schedule_id     =    csh.schedule_id
    AND    csi.organization_id =    coo.organization_id ;

Line: 221

         SELECT 'Y'
         INTO x_open_cum_period
         FROM chv_cum_periods ccp
         WHERE x_schedule_horizon_start between ccp.cum_period_start_date
				      and     ccp.cum_period_end_date
           AND    ccp.organization_id = x_item_org_id;

Line: 249

           SELECT ccp.cum_period_id
           INTO   x_cum_period_id
           FROM   chv_cum_periods ccp
           WHERE  x_schedule_horizon_start
 	          BETWEEN ccp.cum_period_start_date
                      AND ccp.cum_period_end_date
           AND    ccp.organization_id = x_item_org_id;

Line: 264

           SELECT paa.using_organization_id,
                  paa.asl_id,
                  paa.enable_authorizations_flag
           INTO   x_dummy_org,
	          x_asl_id,
                  x_enable_authorization_flag
           FROM   po_asl_attributes_val_v paa
	   WHERE  ((paa.using_organization_id = -1 and not exists
                (SELECT *
                 FROM   po_asl_attributes_val_v paa2
                 WHERE  paa2.using_organization_id = x_item_org_id
                 AND    paa2.vendor_id = x_vendor_id
                 AND    paa2.vendor_site_id = x_vendor_site_id
                 AND    paa2.item_id = x_item_id))
                or
                (paa.using_organization_id = x_item_org_id))
           AND    paa.vendor_id             = x_vendor_id
           AND    paa.vendor_site_id        = x_vendor_site_id
           AND    paa.item_id               = x_item_id;

Line: 300

		SELECT cum_period_item_id
	 	INTO   x_cum_period_item_id
                FROM   chv_cum_period_items
                WHERE  cum_period_id  = x_cum_period_id
                AND    vendor_id      = x_vendor_id
		AND    vendor_site_id = x_vendor_site_id
                AND    item_id        = x_item_id ;

Line: 314

                SELECT chv_cum_period_items_s.nextval
		INTO   x_cum_period_item_id
                FROM   dual ;

Line: 318

	        INSERT into chv_cum_period_items(cum_period_item_id,
					         cum_period_id,
					         organization_id,
						 vendor_id,
						 vendor_site_id,
						 item_id,
						 last_update_date,
						 last_updated_by,
						 creation_date,
						 created_by,
						 last_update_login)
					  VALUES(x_cum_period_item_id,
						 x_cum_period_id,
						 x_item_org_id,
				                 x_vendor_id,
						 x_vendor_site_id,
						 x_item_id,
						 SYSDATE,
						 x_user_id,
						 SYSDATE,
						 x_user_id,
						 x_login_id) ;

Line: 385

      UPDATE chv_schedule_headers
      SET    schedule_status    = 'CONFIRMED',
     	     confirm_date       = SYSDATE,
             last_update_date   = SYSDATE,
             last_updated_by    = x_user_id,
             last_update_login  = x_login_id,
	     communication_code = p_communication_code
      WHERE  schedule_id        = p_schedule_id;