eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_REQUEST_PVT dependencies on AS_INTERESTS_ALL

Line 1128: l_interest_type_id as_interests_all.interest_type_id%TYPE :=null;

1124: -- 2384213: p_classification is a concatinated string like
1125: -- 'interest_type_id/primary_interest_code_id/secondary_interest_id'. This string
1126: -- needs to be broken down into the following three local variables.
1127:
1128: l_interest_type_id as_interests_all.interest_type_id%TYPE :=null;
1129: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE :=null;
1130: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE :=null;
1131: l_position_1 NUMBER;
1132: l_position_2 NUMBER;

Line 1129: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE :=null;

1125: -- 'interest_type_id/primary_interest_code_id/secondary_interest_id'. This string
1126: -- needs to be broken down into the following three local variables.
1127:
1128: l_interest_type_id as_interests_all.interest_type_id%TYPE :=null;
1129: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE :=null;
1130: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE :=null;
1131: l_position_1 NUMBER;
1132: l_position_2 NUMBER;
1133:

Line 1130: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE :=null;

1126: -- needs to be broken down into the following three local variables.
1127:
1128: l_interest_type_id as_interests_all.interest_type_id%TYPE :=null;
1129: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE :=null;
1130: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE :=null;
1131: l_position_1 NUMBER;
1132: l_position_2 NUMBER;
1133:
1134: BEGIN

Line 1752: l_interest_type_id as_interests_all.interest_type_id%TYPE;

1748: -- 2384213: p_classification is a concatinated string like
1749: -- 'interest_type_id/primary_interest_code_id/secondary_interest_id'. This string
1750: -- needs to be broken down into the following three local variables.
1751:
1752: l_interest_type_id as_interests_all.interest_type_id%TYPE;
1753: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE;
1754: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE;
1755: l_position_1 NUMBER;
1756: l_position_2 NUMBER;

Line 1753: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE;

1749: -- 'interest_type_id/primary_interest_code_id/secondary_interest_id'. This string
1750: -- needs to be broken down into the following three local variables.
1751:
1752: l_interest_type_id as_interests_all.interest_type_id%TYPE;
1753: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE;
1754: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE;
1755: l_position_1 NUMBER;
1756: l_position_2 NUMBER;
1757:

Line 1754: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE;

1750: -- needs to be broken down into the following three local variables.
1751:
1752: l_interest_type_id as_interests_all.interest_type_id%TYPE;
1753: l_primary_interest_code_id as_interests_all.primary_interest_code_id%TYPE;
1754: l_secondary_interest_code_id as_interests_all.secondary_interest_code_id%TYPE;
1755: l_position_1 NUMBER;
1756: l_position_2 NUMBER;
1757:
1758: -- Added by Sachin for P1 bug 3765557