73: -- Parameters :
74: --
75: -- Standard IN Parameters :
76: -- p_api_version IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
78: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
80: --
81: -- Standard OUT Parameters :
74: --
75: -- Standard IN Parameters :
76: -- p_api_version IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
78: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
80: --
81: -- Standard OUT Parameters :
82: -- x_return_status OUT VARCHAR2 Required
75: -- Standard IN Parameters :
76: -- p_api_version IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
78: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
80: --
81: -- Standard OUT Parameters :
82: -- x_return_status OUT VARCHAR2 Required
83: -- x_msg_count OUT NUMBER Required
91: -- 09/08/2003 SSURAPAN Initial Creation
92: --------------------------------------------------------------------
93: PROCEDURE Create_Wo_Cost_Structure (
94: p_api_version IN NUMBER,
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_visit_id IN NUMBER,
99: x_cost_session_id OUT NOCOPY NUMBER,
92: --------------------------------------------------------------------
93: PROCEDURE Create_Wo_Cost_Structure (
94: p_api_version IN NUMBER,
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_visit_id IN NUMBER,
99: x_cost_session_id OUT NOCOPY NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2,
93: PROCEDURE Create_Wo_Cost_Structure (
94: p_api_version IN NUMBER,
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_visit_id IN NUMBER,
99: x_cost_session_id OUT NOCOPY NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
115: -- x_return_status OUT VARCHAR2 Required
116: --
117: -- Standard IN Parameters :
118: -- p_api_version IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
122: --
123: -- Standard OUT Parameters :
116: --
117: -- Standard IN Parameters :
118: -- p_api_version IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
122: --
123: -- Standard OUT Parameters :
124: -- x_return_status OUT VARCHAR2 Required
117: -- Standard IN Parameters :
118: -- p_api_version IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
122: --
123: -- Standard OUT Parameters :
124: -- x_return_status OUT VARCHAR2 Required
125: -- x_msg_count OUT NUMBER Required
134: --------------------------------------------------------------------
135: PROCEDURE Create_Wo_Dependencies
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
139: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
140: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
141: p_visit_id IN NUMBER,
142: x_MR_session_id OUT NOCOPY NUMBER,
135: PROCEDURE Create_Wo_Dependencies
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
139: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
140: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
141: p_visit_id IN NUMBER,
142: x_MR_session_id OUT NOCOPY NUMBER,
143: x_return_status OUT NOCOPY VARCHAR2,
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
139: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
140: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
141: p_visit_id IN NUMBER,
142: x_MR_session_id OUT NOCOPY NUMBER,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
167: -- 09/08/2003 SSURAPAN Initial Creation
168: --------------------------------------------------------------------
169: PROCEDURE Insert_Cst_Wo_Hierarchy (
170: p_cst_job_tbl IN Cst_Job_Tbl,
171: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
172: x_session_id OUT NOCOPY NUMBER,
173: x_return_status OUT NOCOPY VARCHAR2
174: );
175:
316: -- Initial Version 1.0
317: ----------------------------------------------------------------------------
318: PROCEDURE Push_MR_Cost_Hierarchy(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
321: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
322: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
323: p_visit_id IN NUMBER,
324:
317: ----------------------------------------------------------------------------
318: PROCEDURE Push_MR_Cost_Hierarchy(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
321: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
322: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
323: p_visit_id IN NUMBER,
324:
325: x_cost_session_id OUT NOCOPY NUMBER,
318: PROCEDURE Push_MR_Cost_Hierarchy(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
321: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
322: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
323: p_visit_id IN NUMBER,
324:
325: x_cost_session_id OUT NOCOPY NUMBER,
326: x_MR_session_id OUT NOCOPY NUMBER,
352: -- Initial Version 1.0
353: ----------------------------------------------------------------------------
354: PROCEDURE Rollup_MR_Cost_Hierarchy(
355: p_api_version IN NUMBER := 1.0,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_visit_id IN NUMBER,
360: p_MR_session_Id IN NUMBER,
353: ----------------------------------------------------------------------------
354: PROCEDURE Rollup_MR_Cost_Hierarchy(
355: p_api_version IN NUMBER := 1.0,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_visit_id IN NUMBER,
360: p_MR_session_Id IN NUMBER,
361: p_cost_session_id IN NUMBER,
354: PROCEDURE Rollup_MR_Cost_Hierarchy(
355: p_api_version IN NUMBER := 1.0,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_visit_id IN NUMBER,
360: p_MR_session_Id IN NUMBER,
361: p_cost_session_id IN NUMBER,
362: x_return_status OUT NOCOPY VARCHAR2
386: -- Initial Version 1.0
387: ----------------------------------------------------------------------------
388: PROCEDURE Calculate_WO_Cost(
389: p_api_version IN NUMBER := 1.0,
390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
393:
394: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
387: ----------------------------------------------------------------------------
388: PROCEDURE Calculate_WO_Cost(
389: p_api_version IN NUMBER := 1.0,
390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
393:
394: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
395: x_return_status OUT NOCOPY VARCHAR2);
388: PROCEDURE Calculate_WO_Cost(
389: p_api_version IN NUMBER := 1.0,
390: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
391: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
392: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
393:
394: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
395: x_return_status OUT NOCOPY VARCHAR2);
396:
417: -- Initial Version 1.0
418: ----------------------------------------------------------------------------
419: PROCEDURE Estimate_WO_Cost(
420: p_api_version IN NUMBER := 1.0,
421: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
422: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
423: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
424:
425: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
418: ----------------------------------------------------------------------------
419: PROCEDURE Estimate_WO_Cost(
420: p_api_version IN NUMBER := 1.0,
421: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
422: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
423: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
424:
425: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
426: x_return_status OUT NOCOPY VARCHAR2);
419: PROCEDURE Estimate_WO_Cost(
420: p_api_version IN NUMBER := 1.0,
421: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
422: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
423: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
424:
425: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.Cost_price_rec_type,
426: x_return_status OUT NOCOPY VARCHAR2);
427: