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

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

Line: 48


  SELECT rule_type_code FROM ahl_mc_rules_b
   WHERE rule_id = p_rule_id;

Line: 52


    SELECT  'X'
     FROM   ahl_mc_rule_statements
    WHERE   rule_statement_id = p_rule_stmt_id;

Line: 59


  SELECT 'X'
   FROM AHL_MC_HEADERS_B header,
	AHL_MC_PATH_POSITION_NODES pnodes, AHL_MC_RULES_B rule
  WHERE pnodes.path_position_id = p_position_id
    AND rule.rule_id = p_rule_id
    AND rule.mc_header_id = header.mc_header_id
    AND pnodes.sequence = 0
    AND pnodes.mc_id = header.mc_id
    AND nvl(pnodes.version_number,header.version_number) = header.version_number;

Line: 71


  SELECT 'X'
   FROM  MTL_SYSTEM_ITEMS_KFV
   WHERE inventory_item_id = p_inventory_item_id;

Line: 78


  SELECT 'X'
    FROM  AHL_MC_HEADERS_B
   WHERE mc_id = p_mc_id
     AND version_number = nvl(p_ver_number, version_number);

Line: 409


PROCEDURE Insert_Rule_Stmt (
    p_api_version         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_module		  IN 	       VARCHAR2  := 'JSP',
    p_x_rule_stmt_rec 	  IN OUT NOCOPY  AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
IS
--
CURSOR next_rule_stmt_id_csr IS
SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

Line: 425


l_api_name         CONSTANT VARCHAR2(30) := 'Insert_Rule_Stmt';

Line: 429


  SAVEPOINT Insert_Rule_Stmt_pvt;

Line: 535


  INSERT INTO ahl_mc_rule_statements(
        RULE_STATEMENT_ID,
	OBJECT_VERSION_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
 	RULE_ID                 ,
	TOP_RULE_STMT_FLAG      ,
	NEGATION_FLAG           ,
	SUBJECT_ID   		,
	SUBJECT_TYPE		,
	OPERATOR		,
	OBJECT_ID		,
	OBJECT_TYPE		,
	OBJECT_ATTRIBUTE1	,
	OBJECT_ATTRIBUTE2	,
	OBJECT_ATTRIBUTE3	,
	OBJECT_ATTRIBUTE4	,
	OBJECT_ATTRIBUTE5	,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15
        )
  VALUES (
        p_x_rule_stmt_rec.rule_statement_id,
	1,
        sysdate,
        fnd_global.user_id,
        sysdate,
        fnd_global.user_id,
        fnd_global.login_id,
     	p_x_rule_stmt_rec.RULE_ID                 ,
     	p_x_rule_stmt_rec.TOP_RULE_STMT_FLAG      ,
	p_x_rule_stmt_rec.NEGATION_FLAG           ,
	p_x_rule_stmt_rec.SUBJECT_ID   		,
	p_x_rule_stmt_rec.SUBJECT_TYPE		,
	p_x_rule_stmt_rec.OPERATOR		,
	p_x_rule_stmt_rec.OBJECT_ID		,
	p_x_rule_stmt_rec.OBJECT_TYPE		,
	p_x_rule_stmt_rec.OBJECT_ATTRIBUTE1	,
	p_x_rule_stmt_rec.OBJECT_ATTRIBUTE2	,
	p_x_rule_stmt_rec.OBJECT_ATTRIBUTE3	,
	p_x_rule_stmt_rec.OBJECT_ATTRIBUTE4	,
	p_x_rule_stmt_rec.OBJECT_ATTRIBUTE5	,
        p_x_rule_stmt_rec.ATTRIBUTE_CATEGORY,
        p_x_rule_stmt_rec.ATTRIBUTE1,
        p_x_rule_stmt_rec.ATTRIBUTE2,
        p_x_rule_stmt_rec.ATTRIBUTE3,
        p_x_rule_stmt_rec.ATTRIBUTE4,
        p_x_rule_stmt_rec.ATTRIBUTE5,
        p_x_rule_stmt_rec.ATTRIBUTE6,
        p_x_rule_stmt_rec.ATTRIBUTE7,
        p_x_rule_stmt_rec.ATTRIBUTE8,
        p_x_rule_stmt_rec.ATTRIBUTE9,
        p_x_rule_stmt_rec.ATTRIBUTE10,
        p_x_rule_stmt_rec.ATTRIBUTE11,
        p_x_rule_stmt_rec.ATTRIBUTE12,
        p_x_rule_stmt_rec.ATTRIBUTE13,
        p_x_rule_stmt_rec.ATTRIBUTE14,
        p_x_rule_stmt_rec.ATTRIBUTE15
       )
      RETURNING object_version_number INTO p_x_rule_stmt_rec.object_version_number;

Line: 625


   Rollback to Insert_Rule_Stmt_pvt;

Line: 631


   Rollback to Insert_Rule_Stmt_pvt;

Line: 637


   Rollback to Insert_Rule_Stmt_pvt;

Line: 645


END Insert_Rule_Stmt;

Line: 661


PROCEDURE Update_Rule_Stmt (
    p_api_version         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_module		  IN 	       VARCHAR2  := 'JSP',
    p_rule_stmt_rec 	  IN           AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
IS
--
CURSOR ahl_mc_rule_stmt_csr (p_rstmt_id IN NUMBER)  IS
SELECT *
FROM AHL_MC_RULE_STATEMENTS
WHERE rule_statement_id = p_rstmt_id;

Line: 679


l_api_name         CONSTANT VARCHAR2(30) := 'Update_Rule_Stmt';

Line: 685


  SAVEPOINT Update_Rule_Stmt_pvt;

Line: 852


  UPDATE ahl_mc_rule_statements SET
	OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
        LAST_UPDATE_DATE      = sysdate,
        LAST_UPDATED_BY       = fnd_global.USER_ID,
        LAST_UPDATE_LOGIN     = fnd_global.LOGIN_ID,
 	RULE_ID             = l_rule_stmt_rec.RULE_ID,
 	TOP_RULE_STMT_FLAG  = l_rule_stmt_rec.TOP_RULE_STMT_FLAG,
	NEGATION_FLAG      =l_rule_stmt_rec.NEGATION_FLAG     ,
	SUBJECT_ID   	   =l_rule_stmt_rec.SUBJECT_ID   ,
	SUBJECT_TYPE	   =l_rule_stmt_rec.SUBJECT_TYPE,
	OPERATOR	   =l_rule_stmt_rec.OPERATOR	,
	OBJECT_ID	   =l_rule_stmt_rec.OBJECT_ID	,
	OBJECT_TYPE	   =l_rule_stmt_rec.OBJECT_TYPE,
	OBJECT_ATTRIBUTE1	=l_rule_stmt_rec.OBJECT_ATTRIBUTE1,
	OBJECT_ATTRIBUTE2	=l_rule_stmt_rec.OBJECT_ATTRIBUTE2,
	OBJECT_ATTRIBUTE3	=l_rule_stmt_rec.OBJECT_ATTRIBUTE3,
	OBJECT_ATTRIBUTE4	=l_rule_stmt_rec.OBJECT_ATTRIBUTE4,
	OBJECT_ATTRIBUTE5	=l_rule_stmt_rec.OBJECT_ATTRIBUTE5,
        ATTRIBUTE_CATEGORY = l_rule_stmt_rec.ATTRIBUTE_CATEGORY,
        ATTRIBUTE1   = l_rule_stmt_rec.ATTRIBUTE1,
        ATTRIBUTE2 = l_rule_stmt_rec.ATTRIBUTE2,
        ATTRIBUTE3 = l_rule_stmt_rec.ATTRIBUTE3,
        ATTRIBUTE4 = l_rule_stmt_rec.ATTRIBUTE4,
        ATTRIBUTE5 = l_rule_stmt_rec.ATTRIBUTE5,
        ATTRIBUTE6 = l_rule_stmt_rec.ATTRIBUTE6,
        ATTRIBUTE7 = l_rule_stmt_rec.ATTRIBUTE7,
        ATTRIBUTE8 = l_rule_stmt_rec.ATTRIBUTE8,
        ATTRIBUTE9 = l_rule_stmt_rec.ATTRIBUTE9,
        ATTRIBUTE10 = l_rule_stmt_rec.ATTRIBUTE10,
        ATTRIBUTE11 = l_rule_stmt_rec.ATTRIBUTE11,
        ATTRIBUTE12 = l_rule_stmt_rec.ATTRIBUTE12,
        ATTRIBUTE13 = l_rule_stmt_rec.ATTRIBUTE13,
        ATTRIBUTE14 = l_rule_stmt_rec.ATTRIBUTE14,
        ATTRIBUTE15 = l_rule_stmt_rec.ATTRIBUTE15
    WHERE RULE_STATEMENT_ID =  l_rule_stmt_rec.rule_statement_id;

Line: 900


   Rollback to Update_Rule_Stmt_pvt;

Line: 906


   Rollback to Update_Rule_Stmt_pvt;

Line: 912


   Rollback to Update_Rule_Stmt_pvt;

Line: 920


END Update_Rule_Stmt;

Line: 952


 SELECT *
    FROM ahl_mc_rule_statements rs
   WHERE rs.rule_statement_id = p_rulestmt_id;

Line: 1068


     Insert_Rule_Stmt (p_api_version         => 1.0,
    		     p_commit              => FND_API.G_FALSE,
		     p_module              => 'PLSQL',
		     p_x_rule_stmt_rec     => l_rstmt_rec,
                     x_return_status       => x_return_status,
                     x_msg_count           => x_msg_count,
                     x_msg_data            => x_msg_data);

Line: 1166


      Insert_Rule_Stmt (p_api_version         => 1.0,
    		     p_commit              => FND_API.G_FALSE,
		     p_module              => 'PLSQL',
		     p_x_rule_stmt_rec     => l_rstmt_rec,
                     x_return_status       => x_return_status,
                     x_msg_count           => x_msg_count,
                     x_msg_data            => x_msg_data);

Line: 1225


PROCEDURE Delete_Rule_Stmts (
    p_api_version         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)
IS
--
 CURSOR  ahl_rule_stmts_csr (p_rule_id IN NUMBER) IS
    SELECT  rule_statement_id
     FROM    ahl_mc_rule_statements stmt
    WHERE   rule_id = p_rule_id;

Line: 1242


l_api_name         CONSTANT VARCHAR2(30) := 'Delete_Rule_Stmts';

Line: 1247


  SAVEPOINT Delete_Rule_Stmts_pvt;

Line: 1274


        DELETE FROM AHL_MC_RULE_STATEMENTS
        WHERE rule_statement_id = l_stmt_id;

Line: 1293


   Rollback to Delete_Rule_Stmts_pvt;

Line: 1299


   Rollback to Delete_Rule_Stmts_pvt;

Line: 1305


   Rollback to Delete_Rule_Stmts_pvt;

Line: 1313


End Delete_Rule_Stmts;

Line: 1336


else we will get as many records as the versions of the MC, unless the user deleted the relation in one of the versions.
*/
CURSOR get_relationships_csr (p_position_id IN NUMBER) IS
  SELECT header.mc_header_id, header.name, header.revision, rels.position_key, rels.relationship_id
   FROM AHL_MC_HEADERS_B header,
        AHL_MC_PATH_POSITION_NODES pnodes,
        AHL_MC_RELATIONSHIPS rels
  WHERE pnodes.path_position_id = p_position_id
    AND pnodes.sequence = (select max(sequence) from AHL_MC_PATH_POSITION_NODES where path_position_id = p_position_id)
    AND pnodes.mc_id = header.mc_id
    AND nvl(pnodes.version_number,header.version_number) = header.version_number
    AND rels.mc_header_id = header.mc_header_id
    AND rels.position_key = pnodes.position_key;

Line: 1351


  SELECT relationship_id
    FROM AHL_MC_RELATIONSHIPS
   WHERE parent_relationship_id = p_relationship_id;

Line: 1356


  SELECT 1
    FROM AHL_MC_RELATIONSHIPS
   WHERE parent_relationship_id = p_relationship_id
     AND rownum = 1;

Line: 1362


  SELECT relationship_id
    FROM ahl_mc_config_relations
   WHERE relationship_id = p_relationship_id
     AND rownum = 1;

Line: 1528


   SELECT ruls.subject_id,
          ruls.object_id,
          ruls.rule_statement_id,
          ruls.rule_id,
          ruls.top_rule_stmt_flag,
          ruls.negation_flag,
          ruls.subject_type,
          ruls.operator,
          ruls.object_type,
          ruls.OBJECT_ATTRIBUTE1
     FROM ahl_mc_rules_b rul, ahl_mc_rule_statements ruls
    WHERE rul.rule_id = ruls.rule_id
      AND rul.mc_header_id = p_mc_header_id
      AND ruls.object_type = 'TOT_CHILD_QUANTITY'
      AND TRUNC(nvl(rul.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
      AND TRUNC(nvl(rul.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 1668


SELECT fnd.meaning
  FROM fnd_lookups fnd
   WHERE fnd.lookup_code = decode (p_neg, 'T', p_oper||'_NOT', p_oper)
    AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';

Line: 1692


SELECT fnd.meaning
  FROM fnd_lookups fnd
 WHERE fnd.lookup_code = p_lookup_code
   AND fnd.lookup_type = p_lookup_type;