10: X_BOX2 IN OUT NOCOPY VARCHAR2,
11: X_BOX3 IN OUT NOCOPY VARCHAR2) IS
12: -- Local Variables
13: P_ret VARCHAR2(1) := 'N';
14: P_User_Id Number := FND_PROFILE.Value('USER_ID');
15: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
16: P_i Number := 0;
17: p_taxability_rules_date_id number;
18: p_valid_date_from date;
11: X_BOX3 IN OUT NOCOPY VARCHAR2) IS
12: -- Local Variables
13: P_ret VARCHAR2(1) := 'N';
14: P_User_Id Number := FND_PROFILE.Value('USER_ID');
15: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
16: P_i Number := 0;
17: p_taxability_rules_date_id number;
18: p_valid_date_from date;
19: p_valid_date_to date;
226: X_classification_id,
227: p_taxability_rules_date_id);
228: --
229: elsif X_MODE = 'UPDATE' then
230: P_User_Id := FND_PROFILE.Value('USER_ID');
231: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
232:
233: SELECT taxability_rules_date_id
234: INTO p_taxability_rules_date_id
227: p_taxability_rules_date_id);
228: --
229: elsif X_MODE = 'UPDATE' then
230: P_User_Id := FND_PROFILE.Value('USER_ID');
231: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
232:
233: SELECT taxability_rules_date_id
234: INTO p_taxability_rules_date_id
235: FROM pay_taxability_rules_dates