[Home] [Help]
1430: l_parameter_prefix VARCHAR2(10) := ':flex';
1431: l_parameter_suffix NUMBER;
1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1431: l_parameter_suffix NUMBER;
1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value
1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value
1440: FROM AR_GTA_RULE_DFFS_ALL l
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value
1440: FROM AR_GTA_RULE_DFFS_ALL l
1441: WHERE l.org_id = P_ORG_ID
1442: AND l.rule_header_id = p_transfer_id
1443: AND l.condition_rule = 'I';
1444:
1443: AND l.condition_rule = 'I';
1444:
1445: CURSOR flex_cond_e IS
1446: SELECT l.context_code, l.attribute_column, l.attribute_value
1447: FROM ar_gta_rule_dffs_all l
1448: WHERE l.Org_Id = P_ORG_ID
1449: AND l.rule_header_id = p_transfer_id
1450: AND l.condition_rule = 'E';
1451: