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_ASSIGNMENT_UTILS dependencies on PA_PROJECT_STATUSES

Line 32: ( p_status_code IN pa_project_statuses.project_status_code%TYPE

28: -- HISTORY
29: -- 16-JUL-2000 R. Krishnamurthy Created
30: --
31: PROCEDURE Check_Status_Is_In_use
32: ( p_status_code IN pa_project_statuses.project_status_code%TYPE
33: ,x_in_use_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
36:

Line 57: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

53: -- This procedure returns the default assignment statuses
54: -- 17-JUL-2000 R. Krishnamurthy Created
55:
56: PROCEDURE Get_Def_Asgmt_Statuses
57: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
58: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
59: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
60: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61: x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 58: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

54: -- 17-JUL-2000 R. Krishnamurthy Created
55:
56: PROCEDURE Get_Def_Asgmt_Statuses
57: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
58: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
59: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
60: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61: x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62:

Line 59: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

55:
56: PROCEDURE Get_Def_Asgmt_Statuses
57: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
58: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
59: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
60: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61: x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62:
63: -- FUNCTION

Line 71: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

67: -- 17-JUL-2000 R. Krishnamurthy Created
68: FUNCTION Get_Project_Id (p_assignment_id IN NUMBER) RETURN NUMBER;
69:
70: FUNCTION Is_Confirmed_Status
71: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
72: p_status_type IN pa_project_statuses.status_type%TYPE )
73: return VARCHAR2;
74: -- This function returns whether a given assignment status is
75: -- a confirmed status or not

Line 72: p_status_type IN pa_project_statuses.status_type%TYPE )

68: FUNCTION Get_Project_Id (p_assignment_id IN NUMBER) RETURN NUMBER;
69:
70: FUNCTION Is_Confirmed_Status
71: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
72: p_status_type IN pa_project_statuses.status_type%TYPE )
73: return VARCHAR2;
74: -- This function returns whether a given assignment status is
75: -- a confirmed status or not
76: -- 18-JUL-2000 R. Krishnamurthy Created

Line 81: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

77:
78: pragma RESTRICT_REFERENCES (Is_Confirmed_Status, WNDS, WNPS);
79:
80: FUNCTION Is_Provisional_Status
81: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
82: p_status_type IN pa_project_statuses.status_type%TYPE )
83: return VARCHAR2;
84: -- This function returns whether a given assignment status is
85: -- a Provisional status or not

Line 82: p_status_type IN pa_project_statuses.status_type%TYPE )

78: pragma RESTRICT_REFERENCES (Is_Confirmed_Status, WNDS, WNPS);
79:
80: FUNCTION Is_Provisional_Status
81: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
82: p_status_type IN pa_project_statuses.status_type%TYPE )
83: return VARCHAR2;
84: -- This function returns whether a given assignment status is
85: -- a Provisional status or not
86: -- 18-JUL-2000 R. Krishnamurthy Created

Line 90: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

86: -- 18-JUL-2000 R. Krishnamurthy Created
87: pragma RESTRICT_REFERENCES (Is_Provisional_Status, WNDS, WNPS);
88:
89: FUNCTION Is_Asgmt_Filled
90: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
91: p_status_type IN pa_project_statuses.status_type%TYPE )
92: return VARCHAR2;
93: -- This function returns whether a given assignment status is
94: -- a Filled status or not

Line 91: p_status_type IN pa_project_statuses.status_type%TYPE )

87: pragma RESTRICT_REFERENCES (Is_Provisional_Status, WNDS, WNPS);
88:
89: FUNCTION Is_Asgmt_Filled
90: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
91: p_status_type IN pa_project_statuses.status_type%TYPE )
92: return VARCHAR2;
93: -- This function returns whether a given assignment status is
94: -- a Filled status or not
95: -- 18-JUL-2000 R. Krishnamurthy Created

Line 99: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

95: -- 18-JUL-2000 R. Krishnamurthy Created
96: pragma RESTRICT_REFERENCES (Is_Asgmt_Filled, WNDS, WNPS);
97:
98: FUNCTION Is_Asgmt_In_Open_Status
99: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
100: p_status_type IN pa_project_statuses.status_type%TYPE )
101: return VARCHAR2;
102: -- This function returns whether a given assignment status is
103: -- an Open status or not

Line 100: p_status_type IN pa_project_statuses.status_type%TYPE )

96: pragma RESTRICT_REFERENCES (Is_Asgmt_Filled, WNDS, WNPS);
97:
98: FUNCTION Is_Asgmt_In_Open_Status
99: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
100: p_status_type IN pa_project_statuses.status_type%TYPE )
101: return VARCHAR2;
102: -- This function returns whether a given assignment status is
103: -- an Open status or not
104: -- 18-JUL-2000 R. Krishnamurthy Created

Line 108: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

104: -- 18-JUL-2000 R. Krishnamurthy Created
105: pragma RESTRICT_REFERENCES (Is_Asgmt_In_Open_Status, WNDS, WNPS);
106:
107: FUNCTION Is_Open_Asgmt_Cancelled
108: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
109: p_status_type IN pa_project_statuses.status_type%TYPE )
110: return VARCHAR2;
111: -- This function returns whether a given open assignment status is
112: -- a cancelled status or not

Line 109: p_status_type IN pa_project_statuses.status_type%TYPE )

105: pragma RESTRICT_REFERENCES (Is_Asgmt_In_Open_Status, WNDS, WNPS);
106:
107: FUNCTION Is_Open_Asgmt_Cancelled
108: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
109: p_status_type IN pa_project_statuses.status_type%TYPE )
110: return VARCHAR2;
111: -- This function returns whether a given open assignment status is
112: -- a cancelled status or not
113: -- 18-JUL-2000 R. Krishnamurthy Created

Line 117: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

113: -- 18-JUL-2000 R. Krishnamurthy Created
114: pragma RESTRICT_REFERENCES (Is_Open_Asgmt_Cancelled, WNDS, WNPS);
115:
116: FUNCTION Is_Staffed_Asgmt_Cancelled
117: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
118: p_status_type IN pa_project_statuses.status_type%TYPE )
119: return VARCHAR2;
120: -- This function returns whether a given staffed assignment status is
121: -- a cancelled status or not

Line 118: p_status_type IN pa_project_statuses.status_type%TYPE )

114: pragma RESTRICT_REFERENCES (Is_Open_Asgmt_Cancelled, WNDS, WNPS);
115:
116: FUNCTION Is_Staffed_Asgmt_Cancelled
117: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
118: p_status_type IN pa_project_statuses.status_type%TYPE )
119: return VARCHAR2;
120: -- This function returns whether a given staffed assignment status is
121: -- a cancelled status or not
122: -- 18-JUL-2000 R. Krishnamurthy Created

Line 126: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

122: -- 18-JUL-2000 R. Krishnamurthy Created
123: pragma RESTRICT_REFERENCES (Is_Staffed_Asgmt_Cancelled, WNDS, WNPS);
124:
125: FUNCTION Check_input_system_status
126: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
127: p_status_type IN pa_project_statuses.status_type%TYPE ,
128: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
129: return VARCHAR2;
130: -- This function returns whether a given status

Line 127: p_status_type IN pa_project_statuses.status_type%TYPE ,

123: pragma RESTRICT_REFERENCES (Is_Staffed_Asgmt_Cancelled, WNDS, WNPS);
124:
125: FUNCTION Check_input_system_status
126: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
127: p_status_type IN pa_project_statuses.status_type%TYPE ,
128: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
129: return VARCHAR2;
130: -- This function returns whether a given status
131: -- has the specified system status

Line 128: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)

124:
125: FUNCTION Check_input_system_status
126: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
127: p_status_type IN pa_project_statuses.status_type%TYPE ,
128: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
129: return VARCHAR2;
130: -- This function returns whether a given status
131: -- has the specified system status
132: -- 18-JUL-2000 R. Krishnamurthy Created

Line 194: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,

190: p_msg_name IN VARCHAR2,
191: p_token1 IN VARCHAR2 DEFAULT NULL,
192: p_value1 IN VARCHAR2 DEFAULT NULL);
193:
194: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,
195: p_project_id IN pa_projects_all.project_id%TYPE,
196: p_add_message IN VARCHAR2)
197: RETURN VARCHAR2;
198: