APPS.ECEPOCI SQL Statements

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

Line: 45

	select map_type into i_map_type
        from ece_mappings
        where map_id = i_map_id
          and enabled ='Y';

Line: 74

	ec_utils.g_stack.DELETE;

Line: 91

            		argument4   => 'UPDATE',-- Operation code = UPDATE
            		argument5   => 'N',	-- Validate_Only = 'N'
            		argument6   => '1',	-- Debug Level = 1
                        argument7   => i_num_instances -- No. of Instances
			);

Line: 152

  IF (UPPER(p_operation_code) = 'INSERT') AND
           p_creation_date_in IS NULL THEN
    p_creation_date_out := SYSDATE;

Line: 169

  IF (UPPER(p_operation_code) = 'INSERT') AND
           p_automatic_flag_in IS NULL THEN
    p_automatic_flag_out := 'N';

Line: 186

  IF (UPPER(p_operation_code) = 'INSERT') AND
           p_calc_prc_flag_in IS NULL THEN
    p_calc_prc_flag_out := 'Y';

Line: 203

  IF (UPPER(p_operation_code) = 'INSERT') AND
           p_created_by_in IS NULL THEN
    p_created_by_out := FND_GLOBAL.USER_ID;