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

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

Line: 74


      SELECT AMS_IBA_PS_RULES_s.NEXTVAL
      FROM dual;

Line: 78


      SELECT 1
      FROM AMS_IBA_PS_RULES
      WHERE RULE_ID = l_id;

Line: 83


      SELECT DISTINCT STRATEGY_ID
      FROM AMS_IBA_PS_RULES
      WHERE (POSTING_ID = l_p_id AND RULEGROUP_ID = l_r_id);

Line: 202


 SELECT COUNT(1) into l_no_of_records  FROM AMS_IBA_PS_RULES ps_rule
  WHERE (ps_rule.posting_id =   p_ps_rules_rec.posting_id   AND   ps_rule.rulegroup_id =  p_ps_rules_rec.rulegroup_id
  AND ps_rule.CLAUSEVALUE2 =  p_ps_rules_rec.CLAUSEVALUE2   AND   ps_rule.CLAUSEVALUE3 = p_ps_rules_rec.CLAUSEVALUE3 );

Line: 232


    SELECT strategy_type, exec_priority INTO l_strat_type, l_exec_priority
    FROM ams_iba_ps_rulegrps_b
    WHERE posting_id = p_ps_rules_rec.posting_id AND rulegroup_id = p_ps_rules_rec.rulegroup_id;

Line: 238


	Select content_type into l_content_type from ams_iba_ps_postings_b
	where posting_id = p_ps_rules_rec.posting_id;

Line: 248


        elsif l_strat_type = 'MANUAL_SELECTION' then
          l_strategy_id := 7;

Line: 258


        elsif l_strat_type = 'MANUAL_SELECTION' then
          l_strategy_id := 9;

Line: 268


        elsif l_strat_type = 'MANUAL_SELECTION' then
          l_strategy_id := 8;

Line: 329


      AMS_IBA_PS_RULES_PKG.Insert_Row(

	  p_created_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          px_object_version_number  => l_object_version_number,
          px_rule_id  => l_RULE_ID,
          p_rulegroup_id  => p_ps_rules_rec.rulegroup_id,
          p_posting_id  => p_ps_rules_rec.posting_id,
          -- p_strategy_id  => p_ps_rules_rec.strategy_id,
          p_strategy_id  => l_strategy_id,
          p_exec_priority  => l_exec_priority,
          -- p_exec_priority  => p_ps_rules_rec.exec_priority,
          p_bus_priority_code  => p_ps_rules_rec.bus_priority_code,
          p_bus_priority_disp_order  => p_ps_rules_rec.bus_priority_disp_order,
          p_clausevalue1  => p_ps_rules_rec.clausevalue1,
          p_clausevalue2  => p_ps_rules_rec.clausevalue2,
          p_clausevalue3  => p_ps_rules_rec.clausevalue3,
          p_clausevalue4  => p_ps_rules_rec.clausevalue4,
          p_clausevalue5  => p_ps_rules_rec.clausevalue5,
          p_clausevalue6  => p_ps_rules_rec.clausevalue6,
          p_clausevalue7  => p_ps_rules_rec.clausevalue7,
          p_clausevalue8  => p_ps_rules_rec.clausevalue8,
          p_clausevalue9  => p_ps_rules_rec.clausevalue9,
          p_clausevalue10  => p_ps_rules_rec.clausevalue10,
          p_use_clause6  => p_ps_rules_rec.use_clause6,
          p_use_clause7  => p_ps_rules_rec.use_clause7,
          p_use_clause8  => p_ps_rules_rec.use_clause8,
          p_use_clause9  => p_ps_rules_rec.use_clause9,
          p_use_clause10  => p_ps_rules_rec.use_clause10);

Line: 396


	 AMS_IBA_PS_RULES_PKG.Insert_Row(

	   p_created_by  => FND_GLOBAL.USER_ID,
           p_creation_date  => SYSDATE,
           p_last_updated_by  => FND_GLOBAL.USER_ID,
           p_last_update_date  => SYSDATE,
           p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
           px_object_version_number  => l_object_version_number,
           px_rule_id  => l_RULE_ID,
           p_rulegroup_id  => p_ps_rules_rec.rulegroup_id,
           p_posting_id  => p_ps_rules_rec.posting_id,
           -- p_strategy_id  => p_ps_rules_rec.strategy_id,
           -- p_exec_priority  => p_ps_rules_rec.exec_priority,
		 p_strategy_id  => l_strategy_id,
		 p_exec_priority  => l_exec_priority,

           p_bus_priority_code  => p_ps_rules_rec.bus_priority_code,
           p_bus_priority_disp_order => p_ps_rules_rec.bus_priority_disp_order,
   --      p_clausevalue1  => p_ps_rules_rec.clausevalue1,
           p_clausevalue1  => l_vt(l_ii),
           p_clausevalue2  => p_ps_rules_rec.clausevalue2,
           p_clausevalue3  => p_ps_rules_rec.clausevalue3,
           p_clausevalue4  => p_ps_rules_rec.clausevalue4,
           p_clausevalue5  => p_ps_rules_rec.clausevalue5,
           p_clausevalue6  => p_ps_rules_rec.clausevalue6,
           p_clausevalue7  => p_ps_rules_rec.clausevalue7,
           p_clausevalue8  => p_ps_rules_rec.clausevalue8,
           p_clausevalue9  => p_ps_rules_rec.clausevalue9,
           p_clausevalue10  => p_ps_rules_rec.clausevalue10,
           p_use_clause6  => p_ps_rules_rec.use_clause6,
           p_use_clause7  => p_ps_rules_rec.use_clause7,
           p_use_clause8  => p_ps_rules_rec.use_clause8,
           p_use_clause9  => p_ps_rules_rec.use_clause9,
           p_use_clause10  => p_ps_rules_rec.use_clause10);

Line: 512


PROCEDURE Update_Ps_Rule(
    p_api_version_number IN  NUMBER,
    p_init_msg_list      IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit             IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level   IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,

    x_return_status      OUT NOCOPY VARCHAR2,
    x_msg_count          OUT NOCOPY NUMBER,
    x_msg_data           OUT NOCOPY VARCHAR2,

    p_ps_rules_rec       IN  ps_rules_rec_type,
    p_visitor_rec        IN  visitor_type_rec,
    p_ps_filter_tbl      IN  ps_rules_tuple_tbl_type,
    p_ps_strategy_tbl    IN  ps_rules_tuple_tbl_type,

    x_object_version_number OUT NOCOPY NUMBER
    )

 IS
L_API_NAME               CONSTANT VARCHAR2(30) := 'Update_Ps_Rule';

Line: 538


    SELECT object_version_number
    FROM  AMS_IBA_PS_RULES
    WHERE rulegroup_id = rgp_id
    and rownum <= 1;

Line: 545


      SAVEPOINT UPDATE_Ps_Rule_PVT;

Line: 574


      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 582


        AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
          p_token_name   => 'INFO',
          p_token_value  => 'Rule');

Line: 638


      update_filters(p_ps_rules_rec.rulegroup_id, p_ps_filter_tbl, x_return_status);

Line: 644


      update_strategy_params(p_ps_rules_rec.rulegroup_id, p_ps_strategy_tbl, x_return_status);

Line: 653


      AMS_UTILITY_PVT.debug_message('Private API: Calling update ');

Line: 656


      Update AMS_IBA_PS_RULES
      SET
        last_updated_by = FND_GLOBAL.user_id,
        last_update_date = SYSDATE,
        last_update_login = FND_GLOBAL.conc_login_id,
        object_version_number = p_ps_rules_rec.object_version_number+1,
	exec_priority = DECODE(p_ps_rules_rec.exec_priority,FND_API.g_miss_num,exec_priority,p_ps_rules_rec.exec_priority),--added this line to update priority of a rule also:anchaudh 2003/01/27.
        strategy_id = DECODE( p_ps_rules_rec.strategy_id, FND_API.g_miss_num,strategy_id, p_ps_rules_rec.strategy_id),
        bus_priority_code = DECODE( p_ps_rules_rec.bus_priority_code, FND_API.g_miss_char, bus_priority_code, p_ps_rules_rec.bus_priority_code),
        bus_priority_disp_order = DECODE( p_ps_rules_rec.bus_priority_disp_order, FND_API.g_miss_char, bus_priority_disp_order, p_ps_rules_rec.bus_priority_disp_order),
        clausevalue1 = DECODE( p_ps_rules_rec.clausevalue1, FND_API.g_miss_char, clausevalue1, p_ps_rules_rec.clausevalue1),
        clausevalue2 = DECODE( p_ps_rules_rec.clausevalue2, FND_API.g_miss_num, clausevalue2, p_ps_rules_rec.clausevalue2),
        clausevalue3 = DECODE( p_ps_rules_rec.clausevalue3, FND_API.g_miss_char, clausevalue3, p_ps_rules_rec.clausevalue3),
        clausevalue4 = DECODE( p_ps_rules_rec.clausevalue4, FND_API.g_miss_char, clausevalue4, p_ps_rules_rec.clausevalue4),
        clausevalue5 = DECODE( p_ps_rules_rec.clausevalue5, FND_API.g_miss_num, clausevalue5, p_ps_rules_rec.clausevalue5),
        clausevalue6 = DECODE( p_ps_rules_rec.clausevalue6, FND_API.g_miss_char, clausevalue6, p_ps_rules_rec.clausevalue6),
        clausevalue7 = DECODE( p_ps_rules_rec.clausevalue7, FND_API.g_miss_char, clausevalue7, p_ps_rules_rec.clausevalue7),
        clausevalue8 = DECODE( p_ps_rules_rec.clausevalue8, FND_API.g_miss_char, clausevalue8, p_ps_rules_rec.clausevalue8),
        clausevalue9 = DECODE( p_ps_rules_rec.clausevalue9, FND_API.g_miss_char, clausevalue9, p_ps_rules_rec.clausevalue9),
        clausevalue10 = DECODE(p_ps_rules_rec.clausevalue10, FND_API.g_miss_char, clausevalue10, p_ps_rules_rec.clausevalue10),
       use_clause6 = DECODE( p_ps_rules_rec.use_clause6, FND_API.g_miss_char, use_clause6, p_ps_rules_rec.use_clause6),
       use_clause7 = DECODE( p_ps_rules_rec.use_clause7, FND_API.g_miss_char, use_clause7, p_ps_rules_rec.use_clause7),
       use_clause8 = DECODE( p_ps_rules_rec.use_clause8, FND_API.g_miss_char, use_clause8, p_ps_rules_rec.use_clause8),
       use_clause9 = DECODE( p_ps_rules_rec.use_clause9, FND_API.g_miss_char, use_clause9, p_ps_rules_rec.use_clause9),
       use_clause10 = DECODE( p_ps_rules_rec.use_clause10, FND_API.g_miss_char, use_clause10, p_ps_rules_rec.use_clause10)

     WHERE RULEGROUP_ID = p_ps_rules_rec.RULEGROUP_ID;

Line: 716


     ROLLBACK TO UPDATE_Ps_Rule_PVT;

Line: 726


     ROLLBACK TO UPDATE_Ps_Rule_PVT;

Line: 736


     ROLLBACK TO UPDATE_Ps_Rule_PVT;

Line: 749


End Update_Ps_Rule;

Line: 754


 The Procedure Update_Ps_Rule_Alt is called only in the PsRuleEO.
 It is only called when there is a visitor type and/or
 clauses CL4 - CL10 change.
*/


PROCEDURE Update_Ps_Rule_Alt(
    p_api_version_number    IN  NUMBER,
    p_init_msg_list         IN  VARCHAR2  := FND_API.G_FALSE,
    p_commit                IN  VARCHAR2  := FND_API.G_FALSE,
    p_validation_level      IN  NUMBER    := FND_API.G_VALID_LEVEL_FULL,

    x_return_status         OUT NOCOPY  VARCHAR2,
    x_msg_count             OUT NOCOPY  NUMBER,
    x_msg_data              OUT NOCOPY  VARCHAR2,

    p_ps_rules_rec          IN   ps_rules_rec_type,
    p_visitor_rec           IN   visitor_type_rec,
    p_ps_filter_tbl         IN   ps_rules_tuple_tbl_type,
    p_ps_strategy_tbl       IN   ps_rules_tuple_tbl_type,
    p_vistype_change        IN   BOOLEAN,
    p_rem_change            IN   BOOLEAN,

    x_object_version_number OUT NOCOPY  NUMBER
    )

 IS

L_API_NAME                 CONSTANT VARCHAR2(30) := 'Update_Ps_Rule_Alt';

Line: 812


    SELECT AMS_IBA_PS_RULES_s.NEXTVAL FROM dual;

Line: 815


    SELECT 1
    FROM AMS_IBA_PS_RULES
    WHERE RULE_ID = l_id;

Line: 827


  oe_debug_pub.add('Begining of  Update_Ps_Rule_Alt');

Line: 830


    SAVEPOINT UPDATE_Ps_Rule_PVT;

Line: 888


        SELECT DISTINCT clausevalue2, clausevalue3
-- , rulegroup_id,
                      -- posting_id, strategy_id, exec_priority,
                      -- bus_priority_code, bus_priority_disp_order
        BULK COLLECT INTO l_cl2, l_cl3 -- l_rgid, l_pstng_id, l_strat_id
			  -- ,l_ex_pty, l_bus_pc, l_bus_do
        FROM ams_iba_ps_rules
        WHERE posting_id = p_ps_rules_rec.posting_id
            AND rulegroup_id = p_ps_rules_rec.rulegroup_id;

Line: 900


        DELETE FROM ams_iba_ps_rules
        WHERE posting_id = p_ps_rules_rec.posting_id
            AND rulegroup_id = p_ps_rules_rec.rulegroup_id
            AND clausevalue1 IS NOT NULL;

Line: 925


	            AMS_IBA_PS_RULES_PKG.Insert_Row(
	               p_created_by  => FND_GLOBAL.USER_ID,
	               p_creation_date  => SYSDATE,
	               p_last_updated_by  => FND_GLOBAL.USER_ID,
	               p_last_update_date  => SYSDATE,
	               p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
	               px_object_version_number  => l_object_version_number,
	               px_rule_id  => l_RULE_ID,
	               p_rulegroup_id  => p_ps_rules_rec.rulegroup_id,
	               p_posting_id  => p_ps_rules_rec.posting_id,
	               p_strategy_id  => p_ps_rules_rec.strategy_id,
          		p_exec_priority  => p_ps_rules_rec.exec_priority,
		       p_bus_priority_code  => p_ps_rules_rec.bus_priority_code,
	               p_bus_priority_disp_order => p_ps_rules_rec.bus_priority_disp_order,
              --        p_clausevalue1  => p_ps_rules_rec.clausevalue1,
	                p_clausevalue1  => l_vt(j),
	                p_clausevalue2  => l_cl2(i),
	                p_clausevalue3  => l_cl3(i),
	                p_clausevalue4  => p_ps_rules_rec.clausevalue4,
	                p_clausevalue5  => p_ps_rules_rec.clausevalue5,
	                p_clausevalue6  => p_ps_rules_rec.clausevalue6,
	                p_clausevalue7  => p_ps_rules_rec.clausevalue7,
	                p_clausevalue8  => p_ps_rules_rec.clausevalue8,
	                p_clausevalue9  => p_ps_rules_rec.clausevalue9,
	                p_clausevalue10  => p_ps_rules_rec.clausevalue10,
                        p_use_clause6  => p_ps_rules_rec.use_clause6,
                        p_use_clause7  => p_ps_rules_rec.use_clause7,
                        p_use_clause8  => p_ps_rules_rec.use_clause8,
                        p_use_clause9  => p_ps_rules_rec.use_clause9,
                        p_use_clause10  => p_ps_rules_rec.use_clause10);

Line: 978


                 AMS_IBA_PS_RULES_PKG.Insert_Row(
                    p_created_by  => FND_GLOBAL.USER_ID,
                    p_creation_date  => SYSDATE,
                    p_last_updated_by  => FND_GLOBAL.USER_ID,
                    p_last_update_date  => SYSDATE,
                    p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
                    px_object_version_number  => l_object_version_number,
                    px_rule_id  => l_RULE_ID,
                    p_rulegroup_id  => p_ps_rules_rec.rulegroup_id,
                    p_posting_id  => p_ps_rules_rec.posting_id,
                    p_strategy_id  => p_ps_rules_rec.strategy_id,
          	    p_exec_priority  => p_ps_rules_rec.exec_priority,
                    p_bus_priority_code  => p_ps_rules_rec.bus_priority_code,
                    p_bus_priority_disp_order => p_ps_rules_rec.bus_priority_disp_order,
            --        p_clausevalue1  => p_ps_rules_rec.clausevalue1,
                    p_clausevalue1  => null,
                    p_clausevalue2  => l_cl2(i),
                    p_clausevalue3  => l_cl3(i),
                    p_clausevalue4  => p_ps_rules_rec.clausevalue4,
                    p_clausevalue5  => p_ps_rules_rec.clausevalue5,
                    p_clausevalue6  => p_ps_rules_rec.clausevalue6,
                    p_clausevalue7  => p_ps_rules_rec.clausevalue7,
                    p_clausevalue8  => p_ps_rules_rec.clausevalue8,
                    p_clausevalue9  => p_ps_rules_rec.clausevalue9,
                    p_clausevalue10  => p_ps_rules_rec.clausevalue10,
                    p_use_clause6  => p_ps_rules_rec.use_clause6,
                    p_use_clause7  => p_ps_rules_rec.use_clause7,
                    p_use_clause8  => p_ps_rules_rec.use_clause8,
                    p_use_clause9  => p_ps_rules_rec.use_clause9,
                    p_use_clause10  => p_ps_rules_rec.use_clause10);

Line: 1015


       UPDATE ams_iba_ps_rules
       SET
         clausevalue4  = p_ps_rules_rec.clausevalue4,
         clausevalue5  = p_ps_rules_rec.clausevalue5,
         clausevalue6  = p_ps_rules_rec.clausevalue6,
         clausevalue7  = p_ps_rules_rec.clausevalue7,
         clausevalue8  = p_ps_rules_rec.clausevalue8,
         clausevalue9  = p_ps_rules_rec.clausevalue9,
         clausevalue10 = p_ps_rules_rec.clausevalue10,
         use_clause6  = p_ps_rules_rec.use_clause6,
         use_clause7  = p_ps_rules_rec.use_clause7,
         use_clause8  = p_ps_rules_rec.use_clause8,
         use_clause9  = p_ps_rules_rec.use_clause9,
         use_clause10 = p_ps_rules_rec.use_clause10

        WHERE posting_id = p_ps_rules_rec.posting_id
          AND rulegroup_id = p_ps_rules_rec.rulegroup_id;

Line: 1035


END Update_Ps_Rule_Alt;

Line: 1038


PROCEDURE Delete_Ps_Rule(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2   := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_rule_id                    IN   NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                 CONSTANT VARCHAR2(30) := 'Delete_Ps_Rule';

Line: 1057


      SAVEPOINT DELETE_Ps_Rule_PVT;

Line: 1089


     AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');

Line: 1093


      AMS_IBA_PS_RULES_PKG.Delete_Row(
          p_RULE_ID  => p_RULE_ID);

Line: 1123


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1133


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1143


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1155


End Delete_Ps_Rule;

Line: 1157


PROCEDURE Delete_Ps_Rule_Alt(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2   := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_ps_rules_rec               IN   ps_rules_rec_type,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                 CONSTANT VARCHAR2(30) := 'Delete_Ps_Rule_Alt';

Line: 1176


      SAVEPOINT DELETE_Ps_Rule_PVT;

Line: 1208


    AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 1212


      DELETE FROM ams_iba_ps_rules
      WHERE posting_id = p_ps_rules_rec.posting_id
	    AND rulegroup_id = p_ps_rules_rec.rulegroup_id
	    AND clausevalue2 = p_ps_rules_rec.clausevalue2
	    AND clausevalue3 = p_ps_rules_rec.clausevalue3;

Line: 1245


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1255


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1265


     ROLLBACK TO DELETE_Ps_Rule_PVT;

Line: 1277


End Delete_Ps_Rule_Alt;

Line: 1299


   SELECT RULE_ID
   FROM AMS_IBA_PS_RULES
   WHERE RULE_ID = p_RULE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 1464


      IF p_ps_rules_rec.last_updated_by = FND_API.g_miss_num OR p_ps_rules_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');

Line: 1471


      IF p_ps_rules_rec.last_update_date = FND_API.g_miss_date OR p_ps_rules_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');

Line: 1521


      IF p_ps_rules_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');

Line: 1528


      IF p_ps_rules_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');

Line: 1603


PROCEDURE update_filters(
    p_rulegroup_id  IN NUMBER,
    p_ps_filter_tbl IN ps_rules_tuple_tbl_type,
    x_return_status OUT NOCOPY VARCHAR2
)
IS
l_tuple                    ps_rules_tuple_rec_type;

Line: 1615


      SELECT AMS_IBA_PS_RL_ST_FLTRS_s.NEXTVAL
      FROM dual;

Line: 1619


      SELECT 1
      FROM AMS_IBA_PS_RL_ST_FLTRS
      WHERE RULE_STRAT_FILTER_ID = l_id;

Line: 1636


   DELETE FROM AMS_IBA_PS_RL_ST_FLTRS
      WHERE rulegroup_id = p_rulegroup_id;

Line: 1643


   AMS_UTILITY_PVT.debug_message('Private API: - deleted existing filters');

Line: 1678


   INSERT INTO AMS_IBA_PS_RL_ST_FLTRS(
           created_by,
           creation_date,
           last_updated_by,
           last_update_date,
           last_update_login,
           object_version_number,
           rule_strat_filter_id,
           rulegroup_id,
           filter_id,
           filter_ref_code
      ) VALUES (
          FND_GLOBAL.USER_ID,
          SYSDATE,
          FND_GLOBAL.USER_ID,
          SYSDATE,
          FND_GLOBAL.CONC_LOGIN_ID,
          1,
          l_id,
          DECODE( p_rulegroup_id, FND_API.g_miss_num, NULL, p_rulegroup_id),
          DECODE( to_number(l_tuple.name), FND_API.g_miss_num, NULL, to_number(l_tuple.name)),
          DECODE( l_tuple.value, FND_API.g_miss_char, NULL, l_tuple.value));

Line: 1712


END update_filters;

Line: 1717


PROCEDURE update_strategy_params(
    p_rulegroup_id  IN NUMBER,
    p_ps_strategy_tbl IN    ps_rules_tuple_tbl_type,
    x_return_status OUT NOCOPY VARCHAR2
)
IS
l_tuple                    ps_rules_tuple_rec_type;

Line: 1729


      SELECT AMS_IBA_PS_RL_ST_PARAMS_s.NEXTVAL
      FROM dual;

Line: 1733


      SELECT 1
      FROM AMS_IBA_PS_RL_ST_PARAMS
      WHERE RULE_STRAT_PARAM_ID = l_id;

Line: 1750


   DELETE FROM AMS_IBA_PS_RL_ST_PARAMS
      WHERE rulegroup_id = p_rulegroup_id;

Line: 1757


   AMS_UTILITY_PVT.debug_message('Private API: - deleted existing strategy parameters');

Line: 1794


       INSERT INTO AMS_IBA_PS_RL_ST_PARAMS(
             created_by,
             creation_date,
             last_updated_by,
             last_update_date,
             last_update_login,
             object_version_number,
             rule_strat_param_id,
             rulegroup_id,
             parameter_name,
             parameter_value
        ) VALUES (
            FND_GLOBAL.USER_ID,
            SYSDATE,
            FND_GLOBAL.USER_ID,
            SYSDATE,
            FND_GLOBAL.CONC_LOGIN_ID,
            1,
            l_id,
            DECODE( p_rulegroup_id, FND_API.g_miss_num, NULL, p_rulegroup_id),
            DECODE( l_tuple.name, FND_API.g_miss_char, NULL, l_tuple.name),
            DECODE( l_tuple.value, FND_API.g_miss_char, NULL, l_tuple.value));

Line: 1829


END update_strategy_params;

Line: 1839


      SELECT *
      FROM ams_iba_ps_rules
      WHERE rule_id = p_ps_rules_rec.rule_id;

Line: 1862


   IF p_ps_rules_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_ps_rules_rec.last_updated_by;

Line: 1867


   IF p_ps_rules_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_ps_rules_rec.last_update_date;

Line: 1872


   IF p_ps_rules_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_ps_rules_rec.last_update_login;

Line: 2000


                 p_validation_mode   => JTF_PLSQL_API.g_update,
                 x_return_status     => x_return_status
              );