eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_CREATE_JOURNALS_PKG SQL Statements

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

Line: 31


|       insert_gl_interface						|
|  DESCRIPTION								|
|  	Insert analytical account journal lines into the GL_INTERFACE	|
|	table. 			  		  			|
|  CALLED BY                                                            |
|       Create_Journal_Allocations					|
|  RETURNS								|
|  	TRUE if row successfully created.			        |
 --------------------------------------------------------------------- */
FUNCTION insert_gl_interface(	lp_entered_dr            IN NUMBER,
				lp_entered_cr            IN NUMBER,
				lp_accounted_dr          IN NUMBER,
				lp_accounted_cr          IN NUMBER,
				lp_offset_group_bool	 IN BOOLEAN) RETURN BOOLEAN IS
BEGIN
  JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');

Line: 50


  INSERT INTO gl_interface (	STATUS,
				LEDGER_ID,  -- GC Ledger Architecture change
				ACCOUNTING_DATE,
				CURRENCY_CODE,
				USER_CURRENCY_CONVERSION_TYPE,
				CURRENCY_CONVERSION_DATE,
				CURRENCY_CONVERSION_RATE,
				DATE_CREATED,
				CREATED_BY,
				ACTUAL_FLAG,
				USER_JE_CATEGORY_NAME,
				USER_JE_SOURCE_NAME,
				ENCUMBRANCE_TYPE_ID,
				BUDGET_VERSION_ID,
				SEGMENT1,
				SEGMENT2,
				SEGMENT3,
				SEGMENT4,
				SEGMENT5,
				SEGMENT6,
				SEGMENT7,
				SEGMENT8,
				SEGMENT9,
				SEGMENT10,
				SEGMENT11,
				SEGMENT12,
				SEGMENT13,
				SEGMENT14,
				SEGMENT15,
				SEGMENT16,
				SEGMENT17,
				SEGMENT18,
				SEGMENT19,
				SEGMENT20,
				SEGMENT21,
				SEGMENT22,
				SEGMENT23,
				SEGMENT24,
				SEGMENT25,
				SEGMENT26,
				SEGMENT27,
				SEGMENT28,
				SEGMENT29,
				SEGMENT30,
				ENTERED_DR,
				ENTERED_CR,
				ACCOUNTED_DR,
				ACCOUNTED_CR,
				REFERENCE1, 	-- Batch Name
				REFERENCE2,	-- Batch Description
				REFERENCE4, 	-- Header Name
				REFERENCE5,	-- Header Description
				REFERENCE6,	-- Header Reference
				REFERENCE10, 	-- Line Description
				REFERENCE21, 	-- GL_JE_LINES.reference_1
				REFERENCE22, 	-- GL_JE_LINES.reference_2
				STAT_AMOUNT,
				SUBLEDGER_DOC_SEQUENCE_ID,
				SUBLEDGER_DOC_SEQUENCE_VALUE,
				ATTRIBUTE1,
				ATTRIBUTE2,
				ATTRIBUTE3,
				ATTRIBUTE4,
				ATTRIBUTE5,
				ATTRIBUTE6,
				ATTRIBUTE7,
				ATTRIBUTE8,
				ATTRIBUTE9,
				ATTRIBUTE10,
				ATTRIBUTE11,
				ATTRIBUTE12,
				ATTRIBUTE13,
				ATTRIBUTE14,
				ATTRIBUTE15,
				ATTRIBUTE16,
				ATTRIBUTE17,
				ATTRIBUTE18,
				ATTRIBUTE19,
				ATTRIBUTE20,
				CONTEXT,
				CONTEXT2,
				INVOICE_DATE,
				TAX_CODE,
				INVOICE_IDENTIFIER,
				INVOICE_AMOUNT,
				CONTEXT3,
				USSGL_TRANSACTION_CODE,
				JGZZ_RECON_REF,
				PERIOD_NAME)
  VALUES
( 				'NEW',
				JG_JOURNAL_ALLOCATIONS_PKG.G_destn_set_of_books_id,
				JG_JOURNAL_ALLOCATIONS_PKG.G_GL_end_date,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
										'A',
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
				       JG_JOURNAL_ALLOCATIONS_PKG.G_translated_user)),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
				       sysdate)),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
				       1)),
				SYSDATE,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_id,
				JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_category_name,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_source_name,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
						JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
						JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
				JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
				lp_entered_dr,
				lp_entered_cr,
				lp_accounted_dr,
				lp_accounted_cr,
			        JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
			        JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
	  		        JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
			        JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name ||
				  DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'A',
				  '/' ||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_doc_sequence_name || '/' ||
				  JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_doc_sequence_value || '/' ||
				  JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num, NULL), -- Reference 10
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_id,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.stat_amount,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.subledger_doc_sequence_id,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.subledger_doc_sequence_value,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute1,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute2,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute3,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute4,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute5,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute6,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute7,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute8,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute9,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute10,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute11,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute12,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute13,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute14,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute15,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute16,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute17,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute18,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute19,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute20,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context2,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_date,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.tax_code,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_identifier,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_amount,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context3,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.ussgl_transaction_code,
				JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.jgzz_recon_ref,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'B',
				  JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));

Line: 258


ELSE -- Inserting line for an offset group total


  INSERT INTO gl_interface (	STATUS,
				LEDGER_ID, -- GC Ledger Architecture change
				ACCOUNTING_DATE,
				CURRENCY_CODE,
				USER_CURRENCY_CONVERSION_TYPE,
				CURRENCY_CONVERSION_DATE,
				CURRENCY_CONVERSION_RATE,
				DATE_CREATED,
				CREATED_BY,
				ACTUAL_FLAG,
				USER_JE_CATEGORY_NAME,
				USER_JE_SOURCE_NAME,
				ENCUMBRANCE_TYPE_ID,
				BUDGET_VERSION_ID,
				SEGMENT1,
				SEGMENT2,
				SEGMENT3,
				SEGMENT4,
				SEGMENT5,
				SEGMENT6,
				SEGMENT7,
				SEGMENT8,
				SEGMENT9,
				SEGMENT10,
				SEGMENT11,
				SEGMENT12,
				SEGMENT13,
				SEGMENT14,
				SEGMENT15,
				SEGMENT16,
				SEGMENT17,
				SEGMENT18,
				SEGMENT19,
				SEGMENT20,
				SEGMENT21,
				SEGMENT22,
				SEGMENT23,
				SEGMENT24,
				SEGMENT25,
				SEGMENT26,
				SEGMENT27,
				SEGMENT28,
				SEGMENT29,
				SEGMENT30,
				ENTERED_DR,
				ENTERED_CR,
				ACCOUNTED_DR,
				ACCOUNTED_CR,
				REFERENCE1, 	-- Batch Name
				REFERENCE2,	-- Batch Description
				REFERENCE4, 	-- Header Name
				REFERENCE5,	-- Header Description
				REFERENCE6,	-- Header Reference
				REFERENCE10, 	-- Line Description
				REFERENCE21, 	-- GL_JE_LINES.reference_1
				REFERENCE22, 	-- GL_JE_LINES.reference_2
				STAT_AMOUNT,
				SUBLEDGER_DOC_SEQUENCE_ID,
				SUBLEDGER_DOC_SEQUENCE_VALUE,
				ATTRIBUTE1,
				ATTRIBUTE2,
				ATTRIBUTE3,
				ATTRIBUTE4,
				ATTRIBUTE5,
				ATTRIBUTE6,
				ATTRIBUTE7,
				ATTRIBUTE8,
				ATTRIBUTE9,
				ATTRIBUTE10,
				ATTRIBUTE11,
				ATTRIBUTE12,
				ATTRIBUTE13,
				ATTRIBUTE14,
				ATTRIBUTE15,
				ATTRIBUTE16,
				ATTRIBUTE17,
				ATTRIBUTE18,
				ATTRIBUTE19,
				ATTRIBUTE20,
				CONTEXT,
				CONTEXT2,
				INVOICE_DATE,
				TAX_CODE,
				INVOICE_IDENTIFIER,
				INVOICE_AMOUNT,
				CONTEXT3,
				USSGL_TRANSACTION_CODE,
				JGZZ_RECON_REF,
				PERIOD_NAME)
  VALUES
( 				'NEW',
				JG_JOURNAL_ALLOCATIONS_PKG.G_destn_set_of_books_id,
				JG_JOURNAL_ALLOCATIONS_PKG.G_GL_end_date,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
										'A',
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
				       JG_JOURNAL_ALLOCATIONS_PKG.G_translated_user)),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
				       SYSDATE)),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
                                     JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
										'A',
                                     DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
					    JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
				       JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
				       1)),
				SYSDATE,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_id,
				JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_category_name,
				JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_source_name,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
						JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
						JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
				JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
				lp_entered_dr,
				lp_entered_cr,
				lp_accounted_dr,
				lp_accounted_cr,
			        JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
			        JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
	  		        JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
			        JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
				NULL,-- Reference6
				NULL, -- Reference 10
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'B',
				  JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));

Line: 467


  JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

Line: 471


    JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

Line: 474


END insert_gl_interface;

Line: 543


       IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,
       	      	  	 	      	   	         l_net_cr_entered_offset_total,
						         l_net_dr_accted_offset_total,
				  		         l_net_cr_accted_offset_total,
						         TRUE) THEN
          FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');

Line: 666


|		Add allocation line to array for later reporting and inserting  |
|		IF offset account is defined against the rule line THEN		|
|		   Add offset allocation line to array	      	   		|
|		END IF								|
|	    END LOOP	      	   						|
|	    Compare original entered/accounted amounts with total of allocated  |
|	       amounts and calculate any rounding errors.   	     		|
|	    Add rounding errors to amounts of allocation line and offset line   |
|	       with the max percentage in the array	      	  	 	|
|	    Insert source journal allocation lines into GL_INTERFACE from array |
|	    (create_journal ends here)						|
|	END journal line LOOP	 						|
|  CALLED BY 									|
|	JG_ALLOCATE_JOURNALS_PKG.allocate					|
--------------------------------------------------------------------------------*/
PROCEDURE create_journal IS
  --
  -- Rule Line cursor
  --
  CURSOR 		c_rule_line IS
  SELECT 		natural_account		 NATURAL_ACCOUNT,
			allocation_percent	 ALLOCATION_PERCENT,
	   		offset_account		 OFFSET_ACCOUNT,
			rule_line_id		 RULE_LINE_ID
  FROM   		jg_zz_ta_rule_lines
  WHERE  		account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;

Line: 1000


         JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));

Line: 1003


         IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
	    		     (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
	  		      JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
			      JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
	  		      JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
 			      FALSE) THEN
	   FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');