APPS.OKL_VENDOR_PROGRAM_PUB SQL Statements

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

Line: 86

PROCEDURE update_program(p_api_version             IN               NUMBER,
                         p_init_msg_list           IN               VARCHAR2 DEFAULT OKL_API.G_FALSE,
                         x_return_status           OUT              NOCOPY VARCHAR2,
                         x_msg_count               OUT              NOCOPY NUMBER,
                         x_msg_data                OUT              NOCOPY VARCHAR2,
                         p_hdr_rec                 IN               program_header_rec_type,
			 p_program_id              IN               NUMBER,
                         p_parent_agreement_id     IN               okc_k_headers_v.ID%TYPE DEFAULT NULL
                        ) IS


    l_hdr_rec                     program_header_rec_type;

Line: 99

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_program';

Line: 109

	-- call process api to update contract

    OKL_VENDOR_PROGRAM_Pvt.update_program(p_api_version         => p_api_version,
                                          p_init_msg_list       => p_init_msg_list,
              			          x_return_status       => l_return_status,
               			          x_msg_count           => x_msg_count,
                              	          x_msg_data            => x_msg_data,
                              	          p_hdr_rec             => l_hdr_rec,
                                          p_program_id          => p_program_id,
                                          p_parent_agreement_id => p_parent_agreement_id
                                          );

Line: 153

      FND_MSG_PUB.ADD_EXC_MSG('OKL_VENDOR_PROGRAM_PUB','update_program');

Line: 159

  END update_program;

Line: 172

		SELECT pdfv.wf_name, cpsv.process_id
		FROM okc_process_defs_b pdfv,
			okc_k_processes cpsv
		WHERE pdfv.id = cpsv.pdf_id
		  AND cpsv.chr_id = p_chr_id;

Line: 180

		SELECT end_date
	 	FROM wf_items
	 	WHERE item_type = l_wf_name
		  AND item_key = l_item_key;