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

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_TRANSACTION_TYPE_ID in NUMBER,
  X_LINE_ORDER_CATEGORY_CODE VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_REVISION_FLAG in VARCHAR2,
  X_END_DATE_ACTIVE in DATE,
  X_START_DATE_ACTIVE in DATE,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_CONTEXT in VARCHAR2,
  X_INSTALLED_CP_STATUS_ID in NUMBER,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_INSTALLED_STATUS_CODE in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_INSTALLED_CP_RETURN_REQUIRED in VARCHAR2,
  X_NO_CHARGE_FLAG in VARCHAR2,
  X_CREATE_CHARGE_FLAG IN VARCHAR2,  --
  X_CREATE_COST_FLAG IN VARCHAR2,----Added by bkanimoz for Service Costing
  X_DEPOT_REPAIR_FLAG in VARCHAR2,
  X_NEW_CP_STATUS_ID in NUMBER,
  X_NEW_CP_STATUS_CODE in VARCHAR2,
  X_TRANSFER_SERVICE in VARCHAR2,
  X_NEW_CP_RETURN_REQUIRED in VARCHAR2,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_MOVE_COUNTERS_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_INTERFACE_TO_OE_FLAG in VARCHAR2,
  X_TRAVEL_FLAG in VARCHAR2,  -- SHACHOUD
  X_CALCULATE_PRICE_FLAG in VARCHAR2, -- shachoud 12.2 Charges Logistics
  X_UPDATE_TASK_ACTUALS_FLAG in VARCHAR2 -- Added by nic for SUN 12.1.3 ER
) is
  cursor C is select ROWID from CS_TRANSACTION_TYPES_B
    where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    ;

Line: 56


  insert into CS_TRANSACTION_TYPES_B (
    TRANSACTION_TYPE_ID,
    LINE_ORDER_CATEGORY_CODE,
    SEEDED_FLAG,
    REVISION_FLAG,
    END_DATE_ACTIVE,
    START_DATE_ACTIVE,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    CONTEXT,
    INSTALLED_CP_STATUS_ID,
    ATTRIBUTE11,
    ATTRIBUTE12,
    INSTALLED_STATUS_CODE,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    INSTALLED_CP_RETURN_REQUIRED,
    NO_CHARGE_FLAG,
    CREATE_CHARGE_FLAG ,
    CREATE_COST_FLAG,----Added by bkanimoz for Service Costing
    DEPOT_REPAIR_FLAG,
    NEW_CP_STATUS_ID,
    NEW_CP_STATUS_CODE,
    TRANSFER_SERVICE,
    NEW_CP_RETURN_REQUIRED,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    MOVE_COUNTERS_FLAG,
    OBJECT_VERSION_NUMBER,
    INTERFACE_TO_OE_FLAG,
    TRAVEL_FLAG,  -- shachoud
    CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
    UPDATE_TASK_ACTUALS_FLAG --added by nic for sun 12.1.3 ER
  ) values (
    X_TRANSACTION_TYPE_ID,
    X_LINE_ORDER_CATEGORY_CODE,
    X_SEEDED_FLAG,
    X_REVISION_FLAG,
    X_END_DATE_ACTIVE,
    X_START_DATE_ACTIVE,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_CONTEXT,
    X_INSTALLED_CP_STATUS_ID,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_INSTALLED_STATUS_CODE,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_INSTALLED_CP_RETURN_REQUIRED,
    X_NO_CHARGE_FLAG,
    X_CREATE_CHARGE_FLAG ,
    X_CREATE_COST_FLAG,----Added by bkanimoz for Service Costing
    X_DEPOT_REPAIR_FLAG,
    X_NEW_CP_STATUS_ID,
    X_NEW_CP_STATUS_CODE,
    X_TRANSFER_SERVICE,
    X_NEW_CP_RETURN_REQUIRED,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_MOVE_COUNTERS_FLAG,
    X_OBJECT_VERSION_NUMBER,
    X_INTERFACE_TO_OE_FLAG,
    X_TRAVEL_FLAG, -- shachoud
    X_CALCULATE_PRICE_FLAG,  -- shachoud 12.2 Charges Logistics
    X_UPDATE_TASK_ACTUALS_FLAG  --added by nic for sun 12.1.3 ER
  );

Line: 148


  insert into CS_TRANSACTION_TYPES_TL (
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    TRANSACTION_TYPE_ID,
    NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LAST_UPDATE_LOGIN,
    X_DESCRIPTION,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_TRANSACTION_TYPE_ID,
    X_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from CS_TRANSACTION_TYPES_TL T
    where T.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 186


end INSERT_ROW;

Line: 230


  X_UPDATE_TASK_ACTUALS_FLAG in VARCHAR2 --added by nic for sun 12.1.3 ER
) is
  cursor c is select
      LINE_ORDER_CATEGORY_CODE,
      SEEDED_FLAG,
      REVISION_FLAG,
      END_DATE_ACTIVE,
      START_DATE_ACTIVE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      CONTEXT,
      INSTALLED_CP_STATUS_ID,
      ATTRIBUTE11,
      ATTRIBUTE12,
      INSTALLED_STATUS_CODE,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      INSTALLED_CP_RETURN_REQUIRED,
      NO_CHARGE_FLAG,
      CREATE_CHARGE_FLAG , --
      CREATE_COST_FLAG ,----Added by bkanimoz for Service Costing
      DEPOT_REPAIR_FLAG,
      NEW_CP_STATUS_ID,
      NEW_CP_STATUS_CODE,
      TRANSFER_SERVICE,
      NEW_CP_RETURN_REQUIRED,
      MOVE_COUNTERS_FLAG,
      OBJECT_VERSION_NUMBER,
      INTERFACE_TO_OE_FLAG,
      TRAVEL_FLAG,  -- shachoud
      CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
      UPDATE_TASK_ACTUALS_FLAG --added by nic for sun 12.1.3 ER
      from CS_TRANSACTION_TYPES_B
      where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
      for update of TRANSACTION_TYPE_ID nowait;

Line: 276


  cursor c1 is select
      NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
      from CS_TRANSACTION_TYPES_TL
      where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
      and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
      for update of TRANSACTION_TYPE_ID nowait;

Line: 289


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 384


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2 default NULL,
  X_TRANSACTION_TYPE_ID in NUMBER,
  X_LINE_ORDER_CATEGORY_CODE VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_REVISION_FLAG in VARCHAR2,
  X_END_DATE_ACTIVE in DATE,
  X_START_DATE_ACTIVE in DATE,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_CONTEXT in VARCHAR2,
  X_INSTALLED_CP_STATUS_ID in NUMBER,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_INSTALLED_STATUS_CODE in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_INSTALLED_CP_RETURN_REQUIRED in VARCHAR2,
  X_NO_CHARGE_FLAG in VARCHAR2,
  X_CREATE_CHARGE_FLAG IN VARCHAR2,  --
  X_CREATE_COST_FLAG IN VARCHAR2,----Added by bkanimoz for Service Costing
  X_DEPOT_REPAIR_FLAG in VARCHAR2,
  X_NEW_CP_STATUS_ID in NUMBER,
  X_NEW_CP_STATUS_CODE in VARCHAR2,
  X_TRANSFER_SERVICE in VARCHAR2,
  X_NEW_CP_RETURN_REQUIRED in VARCHAR2,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_MOVE_COUNTERS_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_INTERFACE_TO_OE_FLAG in VARCHAR2,
  X_TRAVEL_FLAG in VARCHAR2 ,
  X_CALCULATE_PRICE_FLAG  in VARCHAR2, -- shachoud
  X_UPDATE_TASK_ACTUALS_FLAG in VARCHAR2 -- added by nic for 12.1.3 SUN ER

) is
begin
  update CS_TRANSACTION_TYPES_B set
    LINE_ORDER_CATEGORY_CODE = X_LINE_ORDER_CATEGORY_CODE,
    SEEDED_FLAG = X_SEEDED_FLAG,
    REVISION_FLAG = X_REVISION_FLAG,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    CONTEXT = X_CONTEXT,
    INSTALLED_CP_STATUS_ID = X_INSTALLED_CP_STATUS_ID,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    INSTALLED_STATUS_CODE = X_INSTALLED_STATUS_CODE,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    INSTALLED_CP_RETURN_REQUIRED = X_INSTALLED_CP_RETURN_REQUIRED,
    NO_CHARGE_FLAG = X_NO_CHARGE_FLAG,
    CREATE_CHARGE_FLAG = X_CREATE_CHARGE_FLAG ,--
    CREATE_COST_FLAG = X_CREATE_COST_FLAG ,----Added by bkanimoz for Service Costing
    DEPOT_REPAIR_FLAG = X_DEPOT_REPAIR_FLAG,
    NEW_CP_STATUS_ID = X_NEW_CP_STATUS_ID,
    NEW_CP_STATUS_CODE = X_NEW_CP_STATUS_CODE,
    TRANSFER_SERVICE = X_TRANSFER_SERVICE,
    NEW_CP_RETURN_REQUIRED = X_NEW_CP_RETURN_REQUIRED,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    MOVE_COUNTERS_FLAG = X_MOVE_COUNTERS_FLAG,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    INTERFACE_TO_OE_FLAG = X_INTERFACE_TO_OE_FLAG,
    TRAVEL_FLAG = X_TRAVEL_FLAG,    -- shachoud
    CALCULATE_PRICE_FLAG =  X_CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
    UPDATE_TASK_ACTUALS_FLAG = X_UPDATE_TASK_ACTUALS_FLAG
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 481


  update CS_TRANSACTION_TYPES_TL set
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 494


end UPDATE_ROW;

Line: 496


procedure DELETE_ROW (
  X_TRANSACTION_TYPE_ID in NUMBER
) is
begin
  delete from CS_TRANSACTION_TYPES_TL
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 507


  delete from CS_TRANSACTION_TYPES_B
  where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;

Line: 513


end DELETE_ROW;

Line: 518


  delete from CS_TRANSACTION_TYPES_TL T
  where not exists
    (select NULL
    from CS_TRANSACTION_TYPES_B B
    where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
    );

Line: 525


  update CS_TRANSACTION_TYPES_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from CS_TRANSACTION_TYPES_TL B
    where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TRANSACTION_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TRANSACTION_TYPE_ID,
      SUBT.LANGUAGE
    from CS_TRANSACTION_TYPES_TL SUBB, CS_TRANSACTION_TYPES_TL SUBT
    where SUBB.TRANSACTION_TYPE_ID = SUBT.TRANSACTION_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 549


  insert into CS_TRANSACTION_TYPES_TL (
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    TRANSACTION_TYPE_ID,
    NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LAST_UPDATE_LOGIN,
    B.DESCRIPTION,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.TRANSACTION_TYPE_ID,
    B.NAME,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from CS_TRANSACTION_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from CS_TRANSACTION_TYPES_TL T
    where T.TRANSACTION_TYPE_ID = B.TRANSACTION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 587


     update CS_TRANSACTION_TYPES_TL set
	name = X_NAME,
	DESCRIPTION=X_DESCRIPTION,
	last_update_date  = sysdate,
     last_updated_by   = decode(X_OWNER, 'SEED', 1, 0),
     last_update_login = 0,
     source_lang       = userenv('LANG')
      where TRANSACTION_TYPE_ID = to_number(X_TRANSACTION_TYPE_ID)
      and userenv('LANG') in (language, source_lang);

Line: 641


     X_UPDATE_TASK_ACTUALS_FLAG	        in VARCHAR2 --Added by nic for 12.1.3 SUN ER
	) IS
begin
   declare
     l_user_id          number := 0 ;

Line: 655


     select last_updated_by into luby
     from cs_transaction_types_b
     where transaction_type_id = x_transaction_type_id;

Line: 660


       select object_version_number,rowid into l_object_ver,l_row_id
       from cs_transaction_types_b where transaction_type_id = x_transaction_type_id
       for update nowait;

Line: 665


       UPDATE_ROW (
	'',
  	X_TRANSACTION_TYPE_ID	=> to_number(X_TRANSACTION_TYPE_ID),
        X_LINE_ORDER_CATEGORY_CODE => X_LINE_ORDER_CATEGORY_CODE,
  	X_SEEDED_FLAG		=> X_SEEDED_FLAG,
  	X_REVISION_FLAG		=> X_REVISION_FLAG,
  	X_END_DATE_ACTIVE	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
  	X_START_DATE_ACTIVE	=> to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
  	X_ATTRIBUTE1		=> X_ATTRIBUTE1,
  	X_ATTRIBUTE2		=> X_ATTRIBUTE2,
  	X_ATTRIBUTE3		=> X_ATTRIBUTE3,
  	X_ATTRIBUTE4		=> X_ATTRIBUTE4,
  	X_ATTRIBUTE5		=> X_ATTRIBUTE5,
  	X_ATTRIBUTE6		=> X_ATTRIBUTE6,
  	X_ATTRIBUTE7		=> X_ATTRIBUTE7,
  	X_ATTRIBUTE8		=> X_ATTRIBUTE8,
  	X_ATTRIBUTE9		=> X_ATTRIBUTE9,
  	X_ATTRIBUTE10		=> X_ATTRIBUTE10,
  	X_CONTEXT		=> X_CONTEXT,
  	X_INSTALLED_CP_STATUS_ID	=> to_number(X_INSTALLED_CP_STATUS_ID),
  	X_ATTRIBUTE11		=> X_ATTRIBUTE11,
  	X_ATTRIBUTE12		=> X_ATTRIBUTE12,
  	X_INSTALLED_STATUS_CODE	=> X_INSTALLED_STATUS_CODE,
  	X_ATTRIBUTE13		=> X_ATTRIBUTE13,
  	X_ATTRIBUTE14		=> X_ATTRIBUTE14,
  	X_ATTRIBUTE15		=> X_ATTRIBUTE15,
  	X_INSTALLED_CP_RETURN_REQUIRED	=> X_INSTALLED_CP_RETURN_REQUIRED,
  	X_NO_CHARGE_FLAG		=> X_NO_CHARGE_FLAG,
	X_CREATE_CHARGE_FLAG 		=>X_CREATE_CHARGE_FLAG,--added by bkanimoz
	X_CREATE_COST_FLAG 		=>X_CREATE_COST_FLAG ,--
	X_DEPOT_REPAIR_FLAG => X_DEPOT_REPAIR_FLAG,
  	X_NEW_CP_STATUS_ID	=> to_number(X_NEW_CP_STATUS_ID),
  	X_NEW_CP_STATUS_CODE	=> X_NEW_CP_STATUS_CODE,
  	X_TRANSFER_SERVICE	=> X_TRANSFER_SERVICE,
  	X_NEW_CP_RETURN_REQUIRED  	=> X_NEW_CP_RETURN_REQUIRED,
  	X_NAME			=> X_NAME,
  	X_DESCRIPTION		=> X_DESCRIPTION,
  	X_LAST_UPDATE_DATE	=> sysdate,
  	X_LAST_UPDATED_BY	=> l_user_id,
  	X_LAST_UPDATE_LOGIN	=> 0,
	X_MOVE_COUNTERS_FLAG => X_MOVE_COUNTERS_FLAG,
	X_OBJECT_VERSION_NUMBER => l_object_ver,
        X_INTERFACE_TO_OE_FLAG => X_INTERFACE_TO_OE_FLAG,
	X_TRAVEL_FLAG => X_TRAVEL_FLAG, -- shachoud
	X_CALCULATE_PRICE_FLAG => X_CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
	X_UPDATE_TASK_ACTUALS_FLAG => X_UPDATE_TASK_ACTUALS_FLAG -- added by nic for SUN 12.1.3 ER
	);

Line: 716


     INSERT_ROW (
  	X_ROWID			=> l_row_id,
  	X_TRANSACTION_TYPE_ID	=> to_number(X_TRANSACTION_TYPE_ID),
        X_LINE_ORDER_CATEGORY_CODE => X_LINE_ORDER_CATEGORY_CODE,
  	X_SEEDED_FLAG		=> X_SEEDED_FLAG,
  	X_REVISION_FLAG		=> X_REVISION_FLAG,
  	X_END_DATE_ACTIVE	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
  	X_START_DATE_ACTIVE	=> to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
  	X_ATTRIBUTE1		=> X_ATTRIBUTE1,
  	X_ATTRIBUTE2		=> X_ATTRIBUTE2,
  	X_ATTRIBUTE3		=> X_ATTRIBUTE3,
  	X_ATTRIBUTE4		=> X_ATTRIBUTE4,
  	X_ATTRIBUTE5		=> X_ATTRIBUTE5,
  	X_ATTRIBUTE6		=> X_ATTRIBUTE6,
  	X_ATTRIBUTE7		=> X_ATTRIBUTE7,
  	X_ATTRIBUTE8		=> X_ATTRIBUTE8,
  	X_ATTRIBUTE9		=> X_ATTRIBUTE9 ,
  	X_ATTRIBUTE10		=> X_ATTRIBUTE10,
  	X_CONTEXT		=> X_CONTEXT,
  	X_INSTALLED_CP_STATUS_ID	=> to_number(X_INSTALLED_CP_STATUS_ID),
  	X_ATTRIBUTE11		=>  X_ATTRIBUTE11,
  	X_ATTRIBUTE12		=> X_ATTRIBUTE12,
  	X_INSTALLED_STATUS_CODE	=> X_INSTALLED_STATUS_CODE,
  	X_ATTRIBUTE13		=> X_ATTRIBUTE13,
  	X_ATTRIBUTE14		=> X_ATTRIBUTE14,
  	X_ATTRIBUTE15		=> X_ATTRIBUTE15,
  	X_INSTALLED_CP_RETURN_REQUIRED	=> X_INSTALLED_CP_RETURN_REQUIRED,
  	X_NO_CHARGE_FLAG		=> X_NO_CHARGE_FLAG,
	X_CREATE_CHARGE_FLAG 		=>X_CREATE_CHARGE_FLAG,--
	X_CREATE_COST_FLAG 		=>X_CREATE_COST_FLAG ,--
	X_DEPOT_REPAIR_FLAG      => X_DEPOT_REPAIR_FLAG,
  	X_NEW_CP_STATUS_ID	=> to_number(X_NEW_CP_STATUS_ID),
  	X_NEW_CP_STATUS_CODE	=> X_NEW_CP_STATUS_CODE,
  	X_TRANSFER_SERVICE	=> X_TRANSFER_SERVICE,
  	X_NEW_CP_RETURN_REQUIRED	=> X_NEW_CP_RETURN_REQUIRED,
  	X_NAME			=> X_NAME,
  	X_DESCRIPTION		=> X_DESCRIPTION,
  	X_CREATION_DATE		=> sysdate,
  	X_CREATED_BY		=> l_user_id ,
  	X_LAST_UPDATE_DATE	=> sysdate,
  	X_LAST_UPDATED_BY	=> l_user_id,
  	X_LAST_UPDATE_LOGIN	=> 0,
	X_MOVE_COUNTERS_FLAG =>X_MOVE_COUNTERS_FLAG,
	X_OBJECT_VERSION_NUMBER => l_object_ver,
	X_INTERFACE_TO_OE_FLAG => X_INTERFACE_TO_OE_FLAG,
	X_TRAVEL_FLAG => X_TRAVEL_FLAG, -- shachoud
        X_CALCULATE_PRICE_FLAG =>  X_CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
        X_UPDATE_TASK_ACTUALS_FLAG => X_UPDATE_TASK_ACTUALS_FLAG -- Added by nic fo 12.1.3 SUN ER
     );