APPS.FV_AP_PREPAY_PKG_PVT SQL Statements

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

Line: 379

PROCEDURE BC_Packets_Insert(p_packet_id		IN NUMBER,
			    p_set_of_books_id	IN NUMBER,
			    p_ccid		IN NUMBER,
			    p_period_year	IN NUMBER,
			    p_period_num	IN NUMBER,
			    p_quarter_num	IN NUMBER,
                       	    p_gl_user		IN NUMBER,
			    p_enc_type_id	IN NUMBER,
                       	    p_ref1		IN VARCHAR2,
			    p_ref2		IN NUMBER,
			    p_ref3		IN NUMBER,
			    p_ref4		IN VARCHAR2,
			    p_ref5		IN VARCHAR2,
                       	    p_je_source		IN VARCHAR2,
			    p_je_category	IN VARCHAR2,
			    p_actual_flag	IN VARCHAR2,
                       	    p_period_name	IN VARCHAR2,
			    p_base_currency_code IN VARCHAR2,
			    p_status_code	IN VARCHAR2,
                       	    p_ussgl_code	IN VARCHAR2,
                       	    p_base_amt		IN NUMBER,
			    p_reversal_flag	IN VARCHAR2,
			    p_calling_sequence 	IN VARCHAR2) IS
BEGIN
 null;

Line: 404

END BC_Packets_Insert;

Line: 408

ENCUMBRANCE_LINES_INSERT : This Procedure inserts lines into ap_encumbrance
lines. The p_conc_flag determines whether to set the extended who columns
if called by a concurrent program
==========================================================================**/

PROCEDURE Encumbrance_Lines_Insert (
			p_invoice_distribution_id	IN	NUMBER,
			p_encum_line_type		IN	VARCHAR2,
			p_accounting_date		IN	DATE,
			p_period_name			IN	VARCHAR2,
			p_encum_type_id			IN	NUMBER,
			p_code_combination_id		IN	NUMBER,
			p_accounted_cr			IN 	NUMBER,
			p_accounted_dr			IN	NUMBER,
			p_reversal_flag			IN	VARCHAR2,
			p_user_id			IN	NUMBER,
			p_conc_flag			IN 	VARCHAR2,
			p_calling_sequence		IN	VARCHAR2) IS

BEGIN
null;

Line: 429

END Encumbrance_Lines_Insert;

Line: 645

		  p_update_line_num	IN OUT NOCOPY NUMBER,
		  p_calling_sequence    IN VARCHAR2) IS

BEGIN
  	   null;

Line: 708

PROCEDURE Update_InvDists_Wth_PacketId(p_invoice_id 	IN NUMBER,
				       p_dist_line_num	IN NUMBER,
				       p_packet_id 	IN NUMBER) IS
BEGIN
   null;

Line: 713

END Update_InvDists_Wth_PacketId;

Line: 742

PROCEDURE Update_InvDist_Wth_Encum_Flag(p_invoice_id	IN NUMBER,
					  p_packet_id	IN NUMBER,
					  p_encum_flag	IN VARCHAR2,
					  p_calling_sequence IN VARCHAR2) IS
  BEGIN

 null;

Line: 749

END Update_InvDist_Wth_Encum_Flag;