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 2731: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type

2727:
2728: procedure validate_action_attributes(
2729: p_ci_id IN NUMBER
2730: ,p_project_id IN NUMBER
2731: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
2732: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type
2733: ,x_return_status OUT NOCOPY VARCHAR2
2734: ,x_msg_count OUT NOCOPY NUMBER
2735: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2732: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type

2728: procedure validate_action_attributes(
2729: p_ci_id IN NUMBER
2730: ,p_project_id IN NUMBER
2731: ,p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
2732: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_in_tbl_type
2733: ,x_return_status OUT NOCOPY VARCHAR2
2734: ,x_msg_count OUT NOCOPY NUMBER
2735: ,x_msg_data OUT NOCOPY VARCHAR2
2736: )

Line 2783: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;

2779:
2780: l_action_status_code pa_project_statuses.project_status_code%type;
2781: l_ci_status_code pa_control_items.status_code%type;
2782: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2783: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2784: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2785:
2786: BEGIN
2787: -- initialize the return status to success

Line 3077: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type

3073: raise;
3074: END validate_action_attributes;
3075:
3076: procedure create_action(
3077: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
3078: ,p_ci_id IN NUMBER := null
3079: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type
3080: ,x_return_status OUT NOCOPY VARCHAR2
3081: ,x_msg_count OUT NOCOPY NUMBER

Line 3079: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type

3075:
3076: procedure create_action(
3077: p_action_tbl IN pa_control_api_pub.ci_actions_in_tbl_type
3078: ,p_ci_id IN NUMBER := null
3079: ,x_action_tbl OUT NOCOPY pa_control_api_pub.ci_actions_out_tbl_type
3080: ,x_return_status OUT NOCOPY VARCHAR2
3081: ,x_msg_count OUT NOCOPY NUMBER
3082: ,x_msg_data OUT NOCOPY VARCHAR2
3083: )

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

3372: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3373: l_module_name := 'validate_priv_and_action' || g_module_name;
3374:
3375: if l_debug_mode = 'Y' then
3376: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.validate_priv_and_action', p_debug_mode => l_debug_mode);
3377: end if;
3378:
3379: if l_debug_mode = 'Y' then
3380: pa_debug.write(l_module_name, 'start of validate_priv_and_action', l_debug_level3);

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

3548: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3549: l_module_name := 'Delete_CI' || g_module_name;
3550:
3551: if l_debug_mode = 'Y' then
3552: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.Delete_CI', p_debug_mode => l_debug_mode);
3553: end if;
3554:
3555: if l_debug_mode = 'Y' then
3556: pa_debug.write(l_module_name, 'start of Delete_CI', l_debug_level3);