17: l_aw_name1 varchar2(200);
18: l_stmtnum number;
19: l_rownum number;
20: l_price_plan_id number;
21: l_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: l_error varchar2(1) := FND_API.G_RET_STS_ERROR;
23: l_output1 varchar2(1);
24: l_output2 varchar2(1);
25: l_output3 varchar2(1);
18: l_stmtnum number;
19: l_rownum number;
20: l_price_plan_id number;
21: l_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
22: l_error varchar2(1) := FND_API.G_RET_STS_ERROR;
23: l_output1 varchar2(1);
24: l_output2 varchar2(1);
25: l_output3 varchar2(1);
26: l_table_name varchar2(30);
109: l_table_name := 'CHANGED STATUS FOR REPORTS';
110:
111: qpr_user_plan_init_pvt.Initialize
112: ( p_api_version =>1.0,
113: p_init_msg_list =>FND_API.G_TRUE,
114: p_commit =>FND_API.G_FALSE,
115: p_validation_level=>FND_API.G_VALID_LEVEL_NONE,
116: p_user_id =>null,
117: p_plan_id =>P_PRICE_PLAN_ID,
110:
111: qpr_user_plan_init_pvt.Initialize
112: ( p_api_version =>1.0,
113: p_init_msg_list =>FND_API.G_TRUE,
114: p_commit =>FND_API.G_FALSE,
115: p_validation_level=>FND_API.G_VALID_LEVEL_NONE,
116: p_user_id =>null,
117: p_plan_id =>P_PRICE_PLAN_ID,
118: p_event_id =>qpr_user_plan_init_pvt.g_maintain_datamart,
111: qpr_user_plan_init_pvt.Initialize
112: ( p_api_version =>1.0,
113: p_init_msg_list =>FND_API.G_TRUE,
114: p_commit =>FND_API.G_FALSE,
115: p_validation_level=>FND_API.G_VALID_LEVEL_NONE,
116: p_user_id =>null,
117: p_plan_id =>P_PRICE_PLAN_ID,
118: p_event_id =>qpr_user_plan_init_pvt.g_maintain_datamart,
119: x_return_status =>L_OUTPUT2,