APPS.PA_PROJ_OPP_ATTRS_PKG dependencies on PA_PROJECT_OPP_ATTRS

Line 6: -- Purpose : Create a Row in PA_PROJECT_OPP_ATTRS.

2: /* $Header: PAYOPKGB.pls 120.1 2005/08/19 17:23:36 mwasowic noship $ */
3:
4: --
5: -- Procedure : Insert_row
6: -- Purpose : Create a Row in PA_PROJECT_OPP_ATTRS.
7: --
8: --
9: PROCEDURE insert_row
10: ( p_project_id IN NUMBER,

Line 27: INSERT INTO pa_project_opp_attrs

23:
24: BEGIN
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: INSERT INTO pa_project_opp_attrs
28: ( project_id ,
29: opportunity_value ,
30: opp_value_currency_code ,
31: projfunc_opp_value ,

Line 70: -- Purpose : Delete a row in pa_project_opp_attrs.

66:
67:
68: --
69: -- Procedure : delete_row
70: -- Purpose : Delete a row in pa_project_opp_attrs.
71: --
72: --
73: PROCEDURE delete_row
74: ( p_project_id IN NUMBER ,

Line 83: DELETE FROM pa_project_opp_attrs

79:
80: BEGIN
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: DELETE FROM pa_project_opp_attrs
84: WHERE project_id = p_project_id;
85:
86: EXCEPTION
87: WHEN OTHERS THEN

Line 98: -- Purpose : Update a row in pa_project_opp_attrs.

94:
95:
96: --
97: -- Procedure : update_row
98: -- Purpose : Update a row in pa_project_opp_attrs.
99: --
100: --
101: PROCEDURE update_row
102: ( p_project_id IN NUMBER ,

Line 119: UPDATE pa_project_opp_attrs

115:
116: BEGIN
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: UPDATE pa_project_opp_attrs
120: SET
121: opportunity_value = p_opportunity_value,
122: opp_value_currency_code = p_opp_value_currency_code,
123: projfunc_opp_value = p_projfunc_opp_value,