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.AS_SALES_CREDITS_LOG_PKG SQL Statements

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

Line: 3


 PROCEDURE Insert_Row(p_new_lead_id    	NUMBER,
  						p_new_lead_line_id 	NUMBER,
						p_new_sales_credit_id	NUMBER,
						p_new_last_update_date  DATE,
						p_new_last_updated_by   NUMBER,
						p_new_last_update_login NUMBER,
						p_new_creation_date     DATE,
  						p_new_created_by        NUMBER,
						p_new_salesforce_id	NUMBER,
						p_new_salesgroup_id	NUMBER,
						p_new_credit_type_id	NUMBER,
						p_new_credit_percent	NUMBER,
						p_new_credit_amount	NUMBER,
						p_new_opp_worst_frcst_amount NUMBER,
						p_new_opp_frcst_amount NUMBER,
						p_new_opp_best_frcst_amount NUMBER,
						p_endday_log_flag VARCHAR2,
						p_TRIGGER_MODE 	   	VARCHAR2)
 IS
 l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line: 25


	-- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');

Line: 29


	                      'asxtsclb: In AS_SALES_CREDITS_LOG_PKG Before Insert Statement');

Line: 31


  Insert into AS_SALES_CREDITS_LOG (
   log_id,
   lead_id,
   lead_line_id,
   sales_credit_id,
   last_update_date,
   last_updated_by,
   last_update_login,
   creation_date,
   created_by,
   log_mode,
   salesforce_id,
   salesgroup_id,
   credit_type_id,
   credit_percent,
   credit_amount,
   opp_worst_forecast_amount,
   opp_forecast_amount,
   opp_best_forecast_amount,
   endday_log_flag) VALUES (
            AS_SALES_CREDIT_LOG_S.nextval,
  decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
  decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
  decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
  decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
  decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
  decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
  decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
  decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
  p_TRIGGER_MODE,
  decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
  decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
  decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
  decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
  decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
  decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
  decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
  decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
  decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line: 72


	  -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');

Line: 77


	                      'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');

Line: 81


 END Insert_Row;

Line: 83


 PROCEDURE Update_Row(p_new_lead_id         NUMBER,
	p_new_lead_line_id              NUMBER,
	p_old_sales_credit_id		NUMBER,
	p_old_last_update_date          DATE,
	p_new_last_update_date		DATE,
	p_new_last_updated_by           NUMBER,
    	p_new_last_update_login         NUMBER,
    	p_new_creation_date             DATE,
    	p_new_created_by                NUMBER,
	p_new_salesforce_id		NUMBER,
	p_new_salesgroup_id		NUMBER,
	p_new_credit_type_id		NUMBER,
	p_new_credit_percent		NUMBER,
	p_new_credit_amount		NUMBER,
	p_new_opp_worst_frcst_amount NUMBER,
	p_new_opp_frcst_amount NUMBER,
	p_new_opp_best_frcst_amount NUMBER,
	p_endday_log_flag VARCHAR2,
	p_TRIGGER_MODE 	   		VARCHAR2)
 IS
 	l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line: 109


	                      'asxtsclb: In AS_SALES_CREDITS_LOG_PKG before Update_Row');

Line: 112


    Update AS_SALES_CREDITS_LOG
    SET object_version_number =  nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
    lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
    last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
    last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
    last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
    LOG_MODE = p_TRIGGER_MODE,
    salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
    salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
    credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
    credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
    credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
    opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
    opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
    opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
    endday_log_flag =   decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
    WHERE log_id = (select max(log_id)
          		  from AS_SALES_CREDITS_LOG
          		  where SALES_CREDIT_ID = p_old_sales_credit_id);

Line: 133


	 -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');

Line: 139


	 	                      'asxtsclb: In AS_SALES_CREDITS_LOG_PKG after Update statement : Data No found seems');

Line: 145


 END Update_Row;

Line: 147


 Procedure Delete_Row(p_old_lead_id   NUMBER,
  	p_old_lead_line_id 	NUMBER,
	p_old_sales_credit_id	NUMBER,
	p_old_last_update_date  DATE,
	p_old_last_updated_by   NUMBER,
	p_old_last_update_login NUMBER,
	p_old_creation_date     DATE,
  	p_old_created_by        NUMBER,
	p_endday_log_flag VARCHAR2)
 IS
 	l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line: 161


    Update AS_SALES_CREDITS_LOG
    set object_version_number =  nvl(object_version_number,0) + 1, log_mode = 'D'
    where sales_credit_id = p_old_sales_credit_id and last_update_date = p_old_last_update_date;

Line: 165


    Insert into AS_SALES_CREDITS_LOG (
   log_id,
   lead_id,
   lead_line_id,
   sales_credit_id,
   last_update_date,
   last_updated_by,
   last_update_login,
   creation_date,
   created_by,
   log_mode,
   endday_log_flag) VALUES (
            AS_SALES_CREDIT_LOG_S.nextval,
  decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
  decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
  decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
  sysdate,
  decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
  decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
  decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
  decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
  'D',
  decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line: 191


	  -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');

Line: 196


	  	 	                      'asxtsclb: In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');

Line: 201


 END Delete_Row;