APPS.PA_CI_ACTIONS_PVT dependencies on PA_CONTROL_ITEMS

Line 47: from pa_control_items

43: l_item_key pa_wf_processes.item_key%TYPE;
44:
45: Cursor getRecordVersionNumber IS
46: select record_version_number
47: from pa_control_items
48: where ci_id = p_ci_id;
49:
50: Cursor getStatusCode IS
51: select sv.project_system_status_code

Line 52: from pa_control_items ci , pa_ci_statuses_v sv where

48: where ci_id = p_ci_id;
49:
50: Cursor getStatusCode IS
51: select sv.project_system_status_code
52: from pa_control_items ci , pa_ci_statuses_v sv where
53: ci.ci_id = p_ci_id and ci.ci_type_id = sv.ci_type_id
54: and sv.project_status_code = ci.status_code ;
55:
56: BEGIN

Line 136: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (

132: CLOSE getRecordVersionNumber;
133:
134: If (x_return_status = fnd_api.g_ret_sts_success
135: AND p_validate_only <> fnd_api.g_true) then
136: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
137: p_api_version => P_API_VERSION,
138: p_init_msg_list => P_INIT_MSG_LIST,
139: p_commit => P_COMMIT,
140: p_validate_only => P_VALIDATE_ONLY,

Line 168: pa_control_items_workflow.START_NOTIFICATION_WF

164: -- Launch the workflow notification if it is not validate only mode and no errors occured till now.
165: -- Bug 3297238. FP M Changes.
166:
167: IF ( p_validate_only = FND_API.G_FALSE AND x_return_status = FND_API.g_ret_sts_success )THEN
168: pa_control_items_workflow.START_NOTIFICATION_WF
169: ( p_item_type => 'PAWFCIAC'
170: ,p_process_name => l_process_name
171: ,p_ci_id => p_ci_id
172: ,p_action_id => l_ci_action_id

Line 264: from pa_control_items

260: l_item_key pa_wf_processes.item_key%TYPE;
261:
262: Cursor getRecordVersionNumber IS
263: select record_version_number
264: from pa_control_items
265: where ci_id = l_ci_id;
266: BEGIN
267: -- Initialize the Error Stack
268: PA_DEBUG.init_err_stack('PA_CI_ACTIONS_PVT.CLOSE_CI_ACTION');

Line 368: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (

364: CLOSE getRecordVersionNumber;
365:
366: If (x_return_status = fnd_api.g_ret_sts_success
367: AND p_validate_only <> fnd_api.g_true) then
368: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
369: p_api_version => P_API_VERSION,
370: p_init_msg_list => P_INIT_MSG_LIST,
371: p_commit => P_COMMIT,
372: p_validate_only => P_VALIDATE_ONLY,

Line 387: pa_control_items_workflow.START_NOTIFICATION_WF

383:
384: -- Launch the workflow notification if it is not validate only mode and no errors occured till now and calling context is CLOSE.
385: -- Bug 3297238. FP M Changes.
386: IF ( p_validate_only = FND_API.G_FALSE AND x_return_status = FND_API.g_ret_sts_success AND P_calling_context = 'CLOSE' )THEN
387: pa_control_items_workflow.START_NOTIFICATION_WF
388: ( p_item_type => 'PAWFCIAC'
389: ,p_process_name => 'PA_CI_ACTION_CLOSE_FYI'
390: ,p_ci_id => l_ci_id
391: ,p_action_id => p_ci_action_id

Line 658: from pa_control_items

654: l_comment_text varchar2(32767);
655:
656: Cursor getRecordVersionNumber IS
657: select record_version_number
658: from pa_control_items
659: where ci_id = l_ci_id;
660:
661: BEGIN
662: x_return_status := fnd_api.g_ret_sts_success;

Line 756: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (

752: CLOSE getRecordVersionNumber;
753:
754: If (x_return_status = fnd_api.g_ret_sts_success
755: AND p_validate_only <> fnd_api.g_true) then
756: PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS (
757: p_api_version => P_API_VERSION,
758: p_init_msg_list => P_INIT_MSG_LIST,
759: p_commit => P_COMMIT,
760: p_validate_only => P_VALIDATE_ONLY,

Line 772: PA_CONTROL_ITEMS_WORKFLOW.cancel_notif_and_abort_wf(

768: x_msg_data => x_msg_data);
769: End if;
770:
771: -- Cancel the action Bug#12409104
772: PA_CONTROL_ITEMS_WORKFLOW.cancel_notif_and_abort_wf(
773: p_ci_action_id => P_CI_ACTION_ID ,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data ,
776: x_return_status => x_return_status );