APPS.PA_CONTROL_API_PVT dependencies on PA_CONTROL_API_PUB

Line 461: /*This Procedure will be called from PA_CONTROL_API_PUB.add_supplier_impact procedure

457:
458:
459:
460:
461: /*This Procedure will be called from PA_CONTROL_API_PUB.add_supplier_impact procedure
462: to insert the details of the supplier
463: You can also call this procedure independently by passing necessary info.
464: */
465:

Line 469: p_supplier_det_tbl IN PA_CONTROL_API_PUB.SUPP_DET_TBL_TYPE,

465:
466: Procedure add_supplier_details (
467: p_ci_id IN NUMBER := G_PA_MISS_NUM,
468: p_ci_impact_id IN NUMBER ,
469: p_supplier_det_tbl IN PA_CONTROL_API_PUB.SUPP_DET_TBL_TYPE,
470: x_return_status OUT NOCOPY VARCHAR2,
471: x_msg_count OUT NOCOPY NUMBER,
472: x_msg_data OUT NOCOPY VARCHAR2
473: )

Line 2748: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type

2744:
2745: procedure validate_action_attributes(
2746: p_ci_id IN NUMBER
2747: ,p_project_id IN NUMBER
2748: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
2749: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type
2750: ,x_return_status OUT NOCOPY VARCHAR2
2751: ,x_msg_count OUT NOCOPY NUMBER
2752: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2749: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type

2745: procedure validate_action_attributes(
2746: p_ci_id IN NUMBER
2747: ,p_project_id IN NUMBER
2748: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
2749: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type
2750: ,x_return_status OUT NOCOPY VARCHAR2
2751: ,x_msg_count OUT NOCOPY NUMBER
2752: ,x_msg_data OUT NOCOPY VARCHAR2
2753: )

Line 2800: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;

2796:
2797: l_action_status_code pa_project_statuses.project_status_code%type;
2798: l_ci_status_code pa_control_items.status_code%type;
2799: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2800: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2801: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2802:
2803: BEGIN
2804: -- initialize the return status to success

Line 3094: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type

3090: raise;
3091: END validate_action_attributes;
3092:
3093: procedure create_action(
3094: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
3095: ,p_ci_id IN NUMBER := null
3096: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type
3097: ,x_return_status OUT NOCOPY VARCHAR2
3098: ,x_msg_count OUT NOCOPY NUMBER

Line 3096: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type

3092:
3093: procedure create_action(
3094: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
3095: ,p_ci_id IN NUMBER := null
3096: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type
3097: ,x_return_status OUT NOCOPY VARCHAR2
3098: ,x_msg_count OUT NOCOPY NUMBER
3099: ,x_msg_data OUT NOCOPY VARCHAR2
3100: )

Line 3393: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.validate_priv_and_action', p_debug_mode => l_debug_mode);

3389: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3390: l_module_name := 'validate_priv_and_action' || g_module_name;
3391:
3392: if l_debug_mode = 'Y' then
3393: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.validate_priv_and_action', p_debug_mode => l_debug_mode);
3394: end if;
3395:
3396: if l_debug_mode = 'Y' then
3397: pa_debug.write(l_module_name, 'start of validate_priv_and_action', l_debug_level3);

Line 3569: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.Delete_CI', p_debug_mode => l_debug_mode);

3565: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3566: l_module_name := 'Delete_CI' || g_module_name;
3567:
3568: if l_debug_mode = 'Y' then
3569: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.Delete_CI', p_debug_mode => l_debug_mode);
3570: end if;
3571:
3572: if l_debug_mode = 'Y' then
3573: pa_debug.write(l_module_name, 'start of Delete_CI', l_debug_level3);