63: TYPE character_data_table IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
64:
65: -- Local Variables
66: P_ret VARCHAR2(1) := 'N';
67: P_User_Id Number := FND_PROFILE.Value('USER_ID');
68: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
69: p_comp VARCHAR2(1) := 'N';
70: l_fed_tax_type character_data_table;
71: l_qbc_tax_type character_data_table;
64:
65: -- Local Variables
66: P_ret VARCHAR2(1) := 'N';
67: P_User_Id Number := FND_PROFILE.Value('USER_ID');
68: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
69: p_comp VARCHAR2(1) := 'N';
70: l_fed_tax_type character_data_table;
71: l_qbc_tax_type character_data_table;
72: l_prv_tax_type character_data_table;
336: X_taxability_rules_date_id);
337: end if;
338: --
339: elsif X_MODE = 'UPDATE' then
340: P_User_Id := FND_PROFILE.Value('USER_ID');
341: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
342: if X_taxability_rules_date_id IS NULL then
343: select taxability_rules_date_id
344: into X_taxability_rules_date_id
337: end if;
338: --
339: elsif X_MODE = 'UPDATE' then
340: P_User_Id := FND_PROFILE.Value('USER_ID');
341: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
342: if X_taxability_rules_date_id IS NULL then
343: select taxability_rules_date_id
344: into X_taxability_rules_date_id
345: from pay_taxability_rules_dates