APPS.IEX_STATUS_RULE_PVT dependencies on IEX_CUST_STATUS_RULES

Line 62: FROM iex_cust_status_rules

58: X_Msg_Data OUT NOCOPY VARCHAR2)
59: IS
60: CURSOR C_GET_STATUS_RULE_name (IN_STATUS_RULE_Name VARCHAR2) IS
61: SELECT status_rule_Name
62: FROM iex_cust_status_rules
63: WHERE STATUS_RULE_Name = IN_STATUS_RULE_Name;
64: --
65: l_status_rule_Name VARCHAR2(50);
66:

Line 124: FROM iex_cust_status_rules

120: X_Msg_Data OUT NOCOPY VARCHAR2)
121: IS
122: CURSOR C_GET_STATUS_RULE_ID_name (IN_STATUS_RULE_Name VARCHAR2, IN_STATUS_RULE_ID NUMBER) IS
123: SELECT status_rule_Name
124: FROM iex_cust_status_rules
125: WHERE STATUS_RULE_Name = IN_STATUS_RULE_Name and status_rule_id <> IN_Status_Rule_ID;
126: --
127: l_status_rule_Name VARCHAR2(50);
128:

Line 187: SELECT iex_cust_status_rules_s.nextval

183: x_msg_data OUT NOCOPY VARCHAR2,
184: X_STATUS_RULE_ID OUT NOCOPY NUMBER)
185: IS
186: CURSOR get_seq_csr is
187: SELECT iex_cust_status_rules_s.nextval
188: FROM sys.dual;
189: --
190: l_api_name CONSTANT VARCHAR2(30) := 'Create_Status_Rule';
191: l_api_version_number CONSTANT NUMBER := 1.0;

Line 361: from iex_cust_status_rules

357: CREATION_DATE,
358: CREATED_BY ,
359: LAST_UPDATE_LOGIN,
360: OBJECT_VERSION_NUMBER
361: from iex_cust_status_rules
362: where status_rule_id = in_status_rule_id
363: FOR UPDATE NOWAIT;
364: --
365: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status_Rule';

Line 547: FROM IEX_CUST_STATUS_RULES

543:
544: IS
545: CURSOR C_GET_STATUS_RULE (IN_STATUS_RULE_ID NUMBER) IS
546: SELECT rowid
547: FROM IEX_CUST_STATUS_RULES
548: WHERE STATUS_RULE_ID = IN_STATUS_RULE_ID;
549: --
550: CURSOR C_GET_Status_Rule_LineS (IN_STATUS_RULE_ID NUMBER) IS
551: SELECT Status_Rule_line_ID