APPS.PSA_MFAR_UTILS SQL Statements

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

Line: 33

PROCEDURE insert_ccid (p_ccid         IN NUMBER,
                       p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,
                       p_num_segments IN NUMBER)
IS
    l_count number := 0;

Line: 41

       l_full_path VARCHAR2(1000) := g_path || 'insert_ccid.';

Line: 49

     psa_utils.debug_other_string(g_state_level,l_full_path,' Inside insert_ccid ');

Line: 106

       psa_utils.debug_other_string(g_state_level,l_full_path,' END - insert ccid ');

Line: 112

            psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_MFAR_UTILS.insert_ccid');

Line: 118

End insert_ccid;

Line: 366

     SELECT chart_of_accounts_id
     INTO   g_chart_of_accounts_id
     FROM   gl_sets_of_books
     WHERE  set_of_books_id = p_set_of_books_id;

Line: 463

          insert_ccid(l_ccid, l_primary_segments, l_num_segments);

Line: 511

          insert_ccid(l_ccid, l_override_segments, l_num_segments);

Line: 636

           insert_ccid(p_ccid, l_segments, l_segments.count);

Line: 723

/* ========================== INSERT_DISTRIBUTIONS_LOG ===================== */

PROCEDURE INSERT_DISTRIBUTIONS_LOG (p_error_id	      IN NUMBER,
				    p_activity 	      IN VARCHAR2,
				    p_customer_trx_id IN NUMBER,
				    p_activity_id     IN NUMBER,
				    p_error_message   IN VARCHAR2) AS

	PRAGMA AUTONOMOUS_TRANSACTION;

Line: 733

	l_last_updated_by	PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATED_BY%TYPE;

Line: 734

	l_last_update_login	PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATE_LOGIN%TYPE;

Line: 738

    	 l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 740

	 IF l_last_updated_by IS NULL THEN
	      l_last_updated_by := -1;

Line: 744

	 l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 746

	 IF l_last_update_login IS NULL THEN
		l_last_update_login := -1;

Line: 750

	 INSERT INTO PSA_MF_DISTRIBUTIONS_LOG ( ERROR_ID,
						ACTIVITY,
						CUSTOMER_TRX_ID,
						LAST_UPDATE_DATE,
						LAST_UPDATED_BY,
						LAST_UPDATE_LOGIN,
						CREATED_BY,
						CREATED_DATE,
						ACTIVITY_ID,
						ERROR_MESSAGE)
 				VALUES (p_error_id,
					p_activity,
					p_customer_trx_id,
					SYSDATE,
					l_last_updated_by,
					l_last_update_login,
					l_last_update_login,
					SYSDATE,
					p_activity_id,
					p_error_message);

Line: 773

END INSERT_DISTRIBUTIONS_LOG;

Line: 785

	 SELECT  SUBSTR(v.compiled_value_attributes,5,1) account_code
	   FROM  gl_sets_of_books     b,
	         fnd_flex_values      v,
	         fnd_id_flex_segments s
	  WHERE  v.flex_value_set_id    = s.flex_value_set_id
	    AND  v.flex_value           = p_natural_account
	    AND  b.set_of_books_id      = p_set_of_books_id
	    AND  b.chart_of_accounts_id = p_chart_of_accounts_id
	    AND  (s.application_id, s.id_flex_code, s.id_flex_num, s.application_column_name) =
	              (SELECT application_id, id_flex_code, id_flex_num, application_column_name
	                 FROM fnd_segment_attribute_values a
	                WHERE id_flex_code           = 'GL#'
	                  AND segment_attribute_type = 'GL_ACCOUNT'
	                  AND attribute_value        = 'Y'
			  AND id_flex_num            = b.chart_of_accounts_id
	                  AND application_id =
	                                 (SELECT application_id
	                                    FROM fnd_application
	                                   WHERE application_short_name = 'SQLGL'));

Line: 808

	SELECT b.target_account mapped_account
	  FROM PSA_MF_ACCT_MAP_HEADER_ALL A,
	       PSA_MF_ACCOUNT_MAPPING_ALL B
	 WHERE a.psa_acct_mapping_id	= b.psa_acct_mapping_id
	   AND a.org_id                	= l_org_id
	   AND a.document_code		= p_transaction_type
	   AND a.lookup_code            = c_lookup_code
	   AND b.source_account         = c_source_account
  	   AND trunc(sysdate) 		>= trunc(b.start_date_active)
	   AND trunc(sysdate) 		<= trunc(nvl(b.end_date_active,sysdate));

Line: 868

   SELECT *
   FROM psa_implementation_all
   WHERE org_id = c_org_id;

Line: 915

  SELECT set_of_books_id
  INTO   l_ar_sob_id
  FROM   ar_system_parameters;

Line: 936

     SELECT previous_customer_trx_id
     FROM   ra_customer_trx_all
     WHERE  customer_trx_id = p_trx_id;

Line: 986

  SELECT code_combination_id
  INTO  l_ret_code_combination
  FROM  ra_cust_trx_line_gl_dist_all
  WHERE customer_trx_id = l_customer_trx_id
  AND   account_class = 'REC'
  AND   account_set_flag = 'N';

Line: 1021

  SELECT chart_of_accounts_id
  INTO   l_ret_coa_id
  FROM   gl_sets_of_books
  WHERE  set_of_books_id = sob_id;

Line: 1054

  SELECT user_je_category_name
  INTO   l_user_cat_name
  FROM   gl_je_categories
  WHERE  je_category_name = cat_name;