DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_UNIT_PVT dependencies on EAM_CONSTRUCTION_UNIT_PUB

Line 34: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec

30:
31: PROCEDURE create_construction_unit(
32: p_api_version IN NUMBER
33: ,p_commit IN VARCHAR2
34: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
35: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
36: ,x_cu_id OUT NOCOPY NUMBER
37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER

Line 35: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl

31: PROCEDURE create_construction_unit(
32: p_api_version IN NUMBER
33: ,p_commit IN VARCHAR2
34: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
35: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
36: ,x_cu_id OUT NOCOPY NUMBER
37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2

Line 45: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;

41: ) IS
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONSTRUCTION_UNIT';
43: l_api_version CONSTANT NUMBER := 1.0;
44: l_debug_level NUMBER := 0;
45: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
46: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
47: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
48: l_time_stamp DATE := SYSDATE;
49: l_cu_id NUMBER;

Line 46: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;

42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONSTRUCTION_UNIT';
43: l_api_version CONSTANT NUMBER := 1.0;
44: l_debug_level NUMBER := 0;
45: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
46: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
47: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
48: l_time_stamp DATE := SYSDATE;
49: l_cu_id NUMBER;
50: l_cu_activity_id NUMBER;

Line 47: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;

43: l_api_version CONSTANT NUMBER := 1.0;
44: l_debug_level NUMBER := 0;
45: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
46: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
47: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
48: l_time_stamp DATE := SYSDATE;
49: l_cu_id NUMBER;
50: l_cu_activity_id NUMBER;
51: l_activity_index NUMBER;

Line 201: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec

197:
198: PROCEDURE update_construction_unit(
199: p_api_version IN NUMBER
200: ,p_commit IN VARCHAR2
201: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
202: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
203: ,x_cu_id OUT NOCOPY NUMBER
204: ,x_return_status OUT NOCOPY VARCHAR2
205: ,x_msg_count OUT NOCOPY NUMBER

Line 202: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl

198: PROCEDURE update_construction_unit(
199: p_api_version IN NUMBER
200: ,p_commit IN VARCHAR2
201: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
202: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
203: ,x_cu_id OUT NOCOPY NUMBER
204: ,x_return_status OUT NOCOPY VARCHAR2
205: ,x_msg_count OUT NOCOPY NUMBER
206: ,x_msg_data OUT NOCOPY VARCHAR2

Line 212: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;

208: ) IS
209: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONSTRUCTION_UNIT';
210: l_api_version CONSTANT NUMBER := 1.0;
211: l_debug_level NUMBER := 0;
212: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
213: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
214: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
215: l_time_stamp DATE := SYSDATE;
216: l_cu_id NUMBER;

Line 213: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;

209: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONSTRUCTION_UNIT';
210: l_api_version CONSTANT NUMBER := 1.0;
211: l_debug_level NUMBER := 0;
212: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
213: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
214: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
215: l_time_stamp DATE := SYSDATE;
216: l_cu_id NUMBER;
217: l_cu_activity_id NUMBER;

Line 214: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;

210: l_api_version CONSTANT NUMBER := 1.0;
211: l_debug_level NUMBER := 0;
212: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
213: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
214: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
215: l_time_stamp DATE := SYSDATE;
216: l_cu_id NUMBER;
217: l_cu_activity_id NUMBER;
218: l_activity_index NUMBER;

Line 385: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec

381:
382: PROCEDURE copy_construction_unit(
383: p_api_version IN NUMBER
384: ,p_commit IN VARCHAR2
385: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
386: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
387: ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl
388: ,x_cu_id OUT NOCOPY NUMBER
389: ,x_return_status OUT NOCOPY VARCHAR2

Line 386: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl

382: PROCEDURE copy_construction_unit(
383: p_api_version IN NUMBER
384: ,p_commit IN VARCHAR2
385: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
386: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
387: ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl
388: ,x_cu_id OUT NOCOPY NUMBER
389: ,x_return_status OUT NOCOPY VARCHAR2
390: ,x_msg_count OUT NOCOPY NUMBER

Line 387: ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl

383: p_api_version IN NUMBER
384: ,p_commit IN VARCHAR2
385: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
386: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
387: ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl
388: ,x_cu_id OUT NOCOPY NUMBER
389: ,x_return_status OUT NOCOPY VARCHAR2
390: ,x_msg_count OUT NOCOPY NUMBER
391: ,x_msg_data OUT NOCOPY VARCHAR2

Line 541: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec

537:
538: PROCEDURE validate_cu_details(
539: p_api_version IN NUMBER
540: ,p_commit IN VARCHAR2
541: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
542: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
543: ,p_action IN VARCHAR2
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER

Line 542: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl

538: PROCEDURE validate_cu_details(
539: p_api_version IN NUMBER
540: ,p_commit IN VARCHAR2
541: ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
542: ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
543: ,p_action IN VARCHAR2
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2

Line 551: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;

547: ) IS
548: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CU_DETAILS';
549: l_api_version CONSTANT NUMBER := 1.0;
550: l_debug_level NUMBER := 0;
551: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
552: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
553: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
554: l_activity_index NUMBER;
555: l_temp VARCHAR2(10);

Line 552: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;

548: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CU_DETAILS';
549: l_api_version CONSTANT NUMBER := 1.0;
550: l_debug_level NUMBER := 0;
551: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
552: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
553: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
554: l_activity_index NUMBER;
555: l_temp VARCHAR2(10);
556: l_qtantity NUMBER;

Line 553: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;

549: l_api_version CONSTANT NUMBER := 1.0;
550: l_debug_level NUMBER := 0;
551: l_cu_rec EAM_CONSTRUCTION_UNIT_PUB.CU_rec;
552: l_cu_activity_tbl EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl;
553: l_cu_activity_rec EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_rec;
554: l_activity_index NUMBER;
555: l_temp VARCHAR2(10);
556: l_qtantity NUMBER;
557: l_activity_name VARCHAR2(2000);