DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_VWP_VISIT_CST_PR_PVT

Line 85: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,

81: -- x_msg_count OUT NUMBER Required
82: -- x_msg_data OUT VARCHAR2 Required
83: --
84: -- Get Task Cost Details Parameters:
85: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
86: -- Contains Cost/Price infor mation relates to Vist and its Task
87: --
88: -- Version :
89: -- Initial Version 1.0

Line 99: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

95: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
96: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
97: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
98: p_module_type IN VARCHAR2 := NULL,
99: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2
103: )

Line 190: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_x_cost_price_rec;

186: l_idx NUMBER;
187: j NUMBER := 0;
188:
189: l_task_cost_price_rec Get_task_cost_price_cur%ROWTYPE;
190: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_x_cost_price_rec;
191:
192: BEGIN
193: --
194: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 837: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

833: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
834: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
835: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
836: p_module_type IN VARCHAR2 := NULL,
837: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2
841: )

Line 918: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_cost_price_rec;

914: p_price_list_name VARCHAR2(30);
915: l_msg_count NUMBER;
916: i NUMBER;
917:
918: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_cost_price_rec;
919:
920: BEGIN
921:
922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1121: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',

1117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1118: fnd_log.string
1119: (
1120: fnd_log.level_error,
1121: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',
1122: 'Price List is not active on visit start date'
1123: );
1124: END IF;
1125:

Line 1142: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',

1138: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1139: fnd_log.string
1140: (
1141: fnd_log.level_error,
1142: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',
1143: 'Price List is not active on visit end date'
1144: );
1145: END IF;
1146:

Line 1167: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',

1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string
1165: (
1166: fnd_log.level_error,
1167: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_task_cost_details',
1168: 'Price List is not active on current todays date'
1169: );
1170: END IF;
1171:

Line 1294: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,

1290: -- x_msg_count OUT NUMBER Required
1291: -- x_msg_data OUT VARCHAR2 Required
1292: --
1293: -- Estimate Task Cost Parameters:
1294: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
1295: -- Contains Cost/Price infor mation relates to Vist and its Task
1296: --
1297: -- Version :
1298: -- Initial Version 1.0

Line 1308: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

1304: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1305: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1306: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1307: p_module_type IN VARCHAR2 := NULL,
1308: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
1309: x_return_status OUT NOCOPY VARCHAR2,
1310: x_msg_count OUT NOCOPY NUMBER,
1311: x_msg_data OUT NOCOPY VARCHAR2 )
1312: IS

Line 1336: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_x_cost_price_rec;

1332: l_return_status VARCHAR2(1);
1333: l_msg_count NUMBER;
1334: l_commit VARCHAR2(10) := Fnd_Api.G_FALSE;
1335: --
1336: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type := p_x_cost_price_rec;
1337: --
1338:
1339: l_release_visit_required VARCHAR2(1) :='N';
1340:

Line 1412: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit

1408: -- Need to release the visit only if this API is called from front-end direcly
1409:
1410: IF p_module_type = 'JSP' THEN
1411:
1412: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit
1413: (
1414: p_visit_id =>l_visit_task_rec.visit_id,
1415: x_release_visit_required =>l_release_visit_required
1416: );

Line 1588: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,

1584: -- x_msg_count OUT NUMBER Required
1585: -- x_msg_data OUT VARCHAR2 Required
1586: --
1587: -- Estimate Task Price Parameters:
1588: -- p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_Price_Rec_Type,
1589: -- Contains Cost/Price infor mation relates to Vist and its Task
1590: --
1591: -- Version :
1592: -- Initial Version 1.0

Line 1602: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

1598: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1599: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1600: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1601: p_module_type IN VARCHAR2 := NULL,
1602: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
1603: x_return_status OUT NOCOPY VARCHAR2,
1604: x_msg_count OUT NOCOPY NUMBER,
1605: x_msg_data OUT NOCOPY VARCHAR2
1606: )

Line 1672: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type :=p_x_cost_price_rec;

1668: l_msg_count NUMBER;
1669: l_dummy NUMBER;
1670:
1671: --
1672: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type :=p_x_cost_price_rec;
1673:
1674: l_route_id NUMBER;
1675: l_estimated_price NUMBER :=0;
1676: l_actual_price NUMBER :=0;

Line 2649: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type

2645: p_module_type IN VARCHAR2 := NULL,
2646: x_return_status OUT NOCOPY VARCHAR2,
2647: x_msg_count OUT NOCOPY NUMBER,
2648: x_msg_data OUT NOCOPY VARCHAR2,
2649: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type
2650: )
2651: AS
2652:
2653: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;

Line 2653: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;

2649: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type
2650: )
2651: AS
2652:
2653: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_x_cost_price_rec;
2654: l_api_version CONSTANT NUMBER := 1.0;
2655: l_api_name CONSTANT VARCHAR2(30) := 'GET_NODE_COST_DETAILS';
2656:
2657: -- yazhou 09Aug2005 starts

Line 2873: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,

2869: p_module_type IN VARCHAR2 := NULL,
2870: x_return_status OUT NOCOPY VARCHAR2,
2871: x_msg_count OUT NOCOPY NUMBER,
2872: x_msg_data OUT NOCOPY VARCHAR2,
2873: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
2874: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
2875: )
2876: AS
2877: -- Local Variables

Line 2874: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type

2870: x_return_status OUT NOCOPY VARCHAR2,
2871: x_msg_count OUT NOCOPY NUMBER,
2872: x_msg_data OUT NOCOPY VARCHAR2,
2873: p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
2874: x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
2875: )
2876: AS
2877: -- Local Variables
2878:

Line 2882: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;

2878:
2879: l_valid_flag varchar2(1);
2880: l_error_msg_code varchar2(30);
2881:
2882: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type:=p_cost_price_rec;
2883:
2884: l_job_status_code VARCHAR2(30);
2885: l_job_status_mean VARCHAR2(80);
2886:

Line 2890: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;

2886:
2887: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2888: l_x_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2889:
2890: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
2891:
2892: l_api_name VARCHAR2(30) := 'GET_TASK_ITEMS_NO_PRICE';
2893: l_api_version NUMBER := 1.0;
2894: l_msg_data VARCHAR2(2000);

Line 3100: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit

3096:
3097:
3098: If p_module_type = 'JSP' then
3099:
3100: AHL_VWP_VISIT_CST_PR_PVT.check_for_release_visit
3101: (
3102: p_visit_id =>l_task_rec.visit_id,
3103: x_release_visit_required =>l_release_visit_required
3104: );