DBA Data[Home] [Help]

APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on FND_PROFILE

Line 104: P_User_Id Number := FND_PROFILE.Value('USER_ID');

100: X_BOX5 IN OUT NOCOPY VARCHAR2,
101: X_BOX6 IN OUT NOCOPY VARCHAR2) IS
102: -- Local Variables
103: P_ret VARCHAR2(1) := 'N';
104: P_User_Id Number := FND_PROFILE.Value('USER_ID');
105: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
106: P_i Number := 0;
107: p_taxability_rules_date_id number;
108: p_valid_date_from date;

Line 105: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');

101: X_BOX6 IN OUT NOCOPY VARCHAR2) IS
102: -- Local Variables
103: P_ret VARCHAR2(1) := 'N';
104: P_User_Id Number := FND_PROFILE.Value('USER_ID');
105: P_login_id Number := FND_PROFILE.Value('LOGIN_ID');
106: P_i Number := 0;
107: p_taxability_rules_date_id number;
108: p_valid_date_from date;
109: p_valid_date_to date;

Line 412: P_User_Id := FND_PROFILE.Value('USER_ID');

408:
409: end if;
410: --
411: elsif X_MODE = 'UPDATE' then
412: P_User_Id := FND_PROFILE.Value('USER_ID');
413: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
414: select taxability_rules_date_id
415: into p_taxability_rules_date_id
416: from pay_taxability_rules_dates

Line 413: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');

409: end if;
410: --
411: elsif X_MODE = 'UPDATE' then
412: P_User_Id := FND_PROFILE.Value('USER_ID');
413: P_Login_Id := FND_PROFILE.Value('LOGIN_ID');
414: select taxability_rules_date_id
415: into p_taxability_rules_date_id
416: from pay_taxability_rules_dates
417: where sysdate between valid_date_from and valid_date_to