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_TASK_PROG_ACTSET dependencies on PA_ACTION_SET_UTILS

Line 12: l_line_number_tbl pa_action_set_utils.number_tbl_type;

8: , p_action_set_id IN NUMBER
9: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
10: , x_return_status OUT NOCOPY VARCHAR2
11: ) IS
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= 'S';

Line 13: l_line_id_tbl pa_action_set_utils.number_tbl_type;

9: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
10: , x_return_status OUT NOCOPY VARCHAR2
11: ) IS
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= 'S';
17: l_loop_cnt NUMBER;

Line 14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;

10: , x_return_status OUT NOCOPY VARCHAR2
11: ) IS
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= 'S';
17: l_loop_cnt NUMBER;
18:

Line 15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;

11: ) IS
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= 'S';
17: l_loop_cnt NUMBER;
18:
19: BEGIN

Line 92: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

88: PROCEDURE perform_action_set_line(
89: p_action_set_type_code IN VARCHAR2 := 'PA_TASK_PROGRESS'
90: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
91: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
92: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
93: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
94: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
95: IS
96: CURSOR c_proj_info(cp_project_id NUMBER) IS

Line 93: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type

89: p_action_set_type_code IN VARCHAR2 := 'PA_TASK_PROGRESS'
90: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
91: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
92: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
93: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
94: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
95: IS
96: CURSOR c_proj_info(cp_project_id NUMBER) IS
97: SELECT p.start_date proj_start_date,

Line 118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

114: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_TASK_PROG_ACTSET.perform_action_set_line.begin'
115: ,x_Msg => 'in PA_TASK_PROG_ACTSET.perform_action_set_line'
116: ,x_Log_Level => 6);
117:
118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
119:
120: if validate_action_type_code(p_action_set_type_code) = FALSE then
121: PA_ACTION_SET_UTILS.Add_Message(
122: p_app_short_name => 'PA'

Line 121: PA_ACTION_SET_UTILS.Add_Message(

117:
118: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
119:
120: if validate_action_type_code(p_action_set_type_code) = FALSE then
121: PA_ACTION_SET_UTILS.Add_Message(
122: p_app_short_name => 'PA'
123: ,p_msg_name => 'PA_AS_INVALID_ACTION_TYPE');
124: PA_DEBUG.RESET_ERR_STACK;
125: return;

Line 130: PA_ACTION_SET_UTILS.Add_Message(

126: end if;
127: l_project_id := p_action_set_details_rec.object_id; --2643
128: --get_project_id(p_action_set_type_code,p_action_set_line_rec);
129: if (l_project_id is null or l_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
130: PA_ACTION_SET_UTILS.Add_Message(
131: p_app_short_name => 'PA'
132: ,p_msg_name => 'PA_NO_PROJECT_ID');
133: PA_DEBUG.RESET_ERR_STACK;
134: return;

Line 141: PA_ACTION_SET_UTILS.Add_Message(

137: OPEN c_proj_info(l_project_id);
138: FETCH c_proj_info INTO cp_proj_info;
139: if c_proj_info%NOTFOUND then
140: close c_proj_info;
141: PA_ACTION_SET_UTILS.Add_Message(
142: p_app_short_name => 'PA'
143: ,p_msg_name => 'PA_NO_PROJECT_ID');
144: PA_DEBUG.RESET_ERR_STACK;
145: return;

Line 165: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;

161: x_msg_data => l_msg_data);
162:
163: --per Xiouyuan,hard-coding statu code, bug 2383406
164: if p_action_set_line_rec.status_code = 'REVERSE_PENDING' then
165: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;
166: else
167: if ok_to_perform_action(l_project_id,l_proj_start_date) then
168: l_msg_count := 0;
169: PA_TASK_PROG_INQUIRY_PKG.request_all_tasks_in_project(

Line 181: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;

177: --x_action_line_audit_tbl := PA_TASK_PROG_ACTSET.g_action_line_audit_tbl;
178: l_action_is_repeating := is_action_repeating(p_action_line_conditions_tbl);
179: if (l_action_is_repeating) then
180: /*Don't set the staus to "Complete", it's a repeating action */
181: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;
182: else
183: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
184: end if;
185: end if;

Line 183: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;

179: if (l_action_is_repeating) then
180: /*Don't set the staus to "Complete", it's a repeating action */
181: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;
182: else
183: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
184: end if;
185: end if;
186: end if;
187: PA_DEBUG.RESET_ERR_STACK;

Line 194: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;

190: WHEN OTHERS THEN
191: -- Set the excetption Message and the stack
192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.peform_action_set_line'
193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
194: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
195: RAISE;
196:
197: END perform_action_set_line;
198: /*-----------------------------------------------------------------------------------*/

Line 301: p_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type) return BOOLEAN

297:
298: END ok_to_perform_action;
299: /*-----------------------------------------------------------------------------*/
300: FUNCTION is_action_repeating(
301: p_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type) return BOOLEAN
302: IS
303: BEGIN
304: --if (p_action_line_conditions_tbl(0).condition_attribute2 is NULL) then
305: -- return FALSE;

Line 327: pa_action_set_utils.get_action_set_id

323: where object_type = 'PA_PROJECTS'
324: and object_id = p_project_id_from;
325: */
326: SELECT
327: pa_action_set_utils.get_action_set_id
328: ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) action_set_id
329: FROM dual
330: WHERE pa_action_set_utils.get_action_set_id
331: ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) is not null;

Line 330: WHERE pa_action_set_utils.get_action_set_id

326: SELECT
327: pa_action_set_utils.get_action_set_id
328: ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) action_set_id
329: FROM dual
330: WHERE pa_action_set_utils.get_action_set_id
331: ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) is not null;
332:
333: l_action_set_id NUMBER;
334: l_new_action_set_id NUMBER;

Line 502: l_curr_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code

498:
499: x_return_status := 'S';
500: l_record_version_number := p_record_version_number;
501:
502: l_curr_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code
503: ,p_object_type
504: ,p_object_id);
505: if l_curr_action_set_id is not NULL then
506: OPEN c_action_set_info(l_curr_action_set_id);