APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_PROJ_OPP_ATTRS_PKG

Line 105: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,

101: debug('p_opportunity_value is null');
102: END IF;
103:
104: l_projfunc_opp_value := NULL;
105: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,
106: p_opportunity_value => NULL,
107: p_opp_value_currency_code => NULL,
108: p_projfunc_opp_value => NULL,
109: p_projfunc_opp_rate_type => NULL,

Line 125: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,

121: debug('p_opportunity_value = 0');
122: END IF;
123:
124: l_projfunc_opp_value := 0;
125: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,
126: p_opportunity_value => 0,
127: p_opp_value_currency_code => p_opp_value_currency_code, --changed from NULL to p_opp_value_currency_code for BUg 4129683
128: p_projfunc_opp_value => 0,
129: p_projfunc_opp_rate_type => NULL,

Line 186: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,

182: debug('SAME currency codes');
183: END IF;
184:
185: l_projfunc_opp_value := p_opportunity_value;
186: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,
187: p_opportunity_value => p_opportunity_value,
188: p_opp_value_currency_code => l_opp_value_currency_code,
189: p_projfunc_opp_value => p_opportunity_value,
190: p_projfunc_opp_rate_type => NULL,

Line 320: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,

316: PA_UTILS.add_message('PA', l_status);
317: RAISE l_can_not_convert_currency;
318: END IF;
319:
320: PA_PROJ_OPP_ATTRS_PKG.update_row (p_project_id => p_project_id,
321: p_opportunity_value => p_opportunity_value,
322: p_opp_value_currency_code => l_opp_value_currency_code,
323: p_projfunc_opp_value => l_projfunc_opp_value,
324: p_projfunc_opp_rate_type => l_default_rate_type,

Line 414: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_dest_project_id,

410: OPEN c1;
411: FETCH c1 INTO v_c1;
412: CLOSE c1;
413:
414: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_dest_project_id,
415: p_opportunity_value => v_c1.opportunity_value,
416: p_opp_value_currency_code => v_c1.opp_value_currency_code,
417: p_projfunc_opp_value => v_c1.projfunc_opp_value,
418: p_projfunc_opp_rate_type => v_c1.projfunc_opp_rate_type,

Line 486: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,

482: FETCH c1 INTO v_c1;
483: CLOSE c1;
484:
485: IF v_c1.project_value IS NULL THEN
486: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,
487: p_opportunity_value => NULL,
488: p_opp_value_currency_code => NULL,
489: p_projfunc_opp_value => NULL,
490: p_projfunc_opp_rate_type => NULL,

Line 499: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,

495: x_return_status => x_return_status,
496: x_msg_count => x_msg_count,
497: x_msg_data => x_msg_data);
498: ELSIF v_c1.projfunc_currency_code = v_c1.project_currency_code THEN
499: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,
500: p_opportunity_value => v_c1.project_value,
501: p_opp_value_currency_code => v_c1.projfunc_currency_code,
502: p_projfunc_opp_value => v_c1.project_value,
503: p_projfunc_opp_rate_type => NULL,

Line 557: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,

553: PA_UTILS.add_message('PA', l_status);
554: RAISE l_can_not_convert_currency;
555: END IF;
556:
557: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,
558: p_opportunity_value => v_c1.project_value,
559: p_opp_value_currency_code => v_c1.projfunc_currency_code,
560: p_projfunc_opp_value => v_c1.project_value,
561: p_projfunc_opp_rate_type => NULL,

Line 570: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,

566: x_return_status => x_return_status,
567: x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data);
569: ELSE
570: PA_PROJ_OPP_ATTRS_PKG.insert_row ( p_project_id => p_project_id,
571: p_opportunity_value => v_c1.project_value,
572: p_opp_value_currency_code => v_c1.projfunc_currency_code,
573: p_projfunc_opp_value => v_c1.project_value,
574: p_projfunc_opp_rate_type => NULL,

Line 651: PA_PROJ_OPP_ATTRS_PKG.delete_row(p_project_id => p_project_id,

647: BEGIN
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649:
650: -- Delete attributes from pa_proj_opportunity_attributes.
651: PA_PROJ_OPP_ATTRS_PKG.delete_row(p_project_id => p_project_id,
652: x_return_status => x_return_status,
653: x_msg_count => x_msg_count,
654: x_msg_data => x_msg_data);
655: