DBA Data[Home] [Help]

APPS.HZ_LOCATION_BO_PUB dependencies on HZ_LOCATION_OBJ

Line 7: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

3:
4: PROCEDURE do_create_location_bo(
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
7: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
8: p_created_by_module IN VARCHAR2,
9: p_obj_source IN VARCHAR2 := null,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,

Line 20: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

16: );
17:
18: PROCEDURE do_update_location_bo(
19: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
20: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
21: p_created_by_module IN VARCHAR2,
22: p_obj_source IN VARCHAR2 := null,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,

Line 34: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

30:
31: PROCEDURE do_save_location_bo(
32: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
33: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
34: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
35: p_created_by_module IN VARCHAR2,
36: p_obj_source IN VARCHAR2 := null,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

Line 69: p_location_obj IN HZ_LOCATION_OBJ,

65: -- 14-DEC-2004 Arnold Ng Created.
66: --
67:
68: PROCEDURE assign_location_rec(
69: p_location_obj IN HZ_LOCATION_OBJ,
70: p_loc_os IN VARCHAR2,
71: p_loc_osr IN VARCHAR2,
72: p_create_or_update IN VARCHAR2 := 'C',
73: px_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

Line 144: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

140: -- Create a location business object.
141: PROCEDURE do_create_location_bo(
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
144: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
145: p_created_by_module IN VARCHAR2,
146: p_obj_source IN VARCHAR2 := null,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,

Line 384: p_location_obj IN HZ_LOCATION_OBJ,

380:
381: PROCEDURE create_location_bo(
382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
383: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
384: p_location_obj IN HZ_LOCATION_OBJ,
385: p_created_by_module IN VARCHAR2,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,

Line 393: l_location_obj HZ_LOCATION_OBJ;

389: x_location_id OUT NOCOPY NUMBER,
390: x_location_os OUT NOCOPY VARCHAR2,
391: x_location_osr OUT NOCOPY VARCHAR2
392: ) IS
393: l_location_obj HZ_LOCATION_OBJ;
394: BEGIN
395: l_location_obj := p_location_obj;
396: do_create_location_bo(
397: p_init_msg_list => p_init_msg_list,

Line 413: p_location_obj IN HZ_LOCATION_OBJ,

409: END create_location_bo;
410:
411: PROCEDURE create_location_bo(
412: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
413: p_location_obj IN HZ_LOCATION_OBJ,
414: p_created_by_module IN VARCHAR2,
415: p_obj_source IN VARCHAR2 := null,
416: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
417: x_return_status OUT NOCOPY VARCHAR2,

Line 419: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,

415: p_obj_source IN VARCHAR2 := null,
416: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
417: x_return_status OUT NOCOPY VARCHAR2,
418: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
419: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
420: x_location_id OUT NOCOPY NUMBER,
421: x_location_os OUT NOCOPY VARCHAR2,
422: x_location_osr OUT NOCOPY VARCHAR2
423: ) IS

Line 426: l_location_obj HZ_LOCATION_OBJ;

422: x_location_osr OUT NOCOPY VARCHAR2
423: ) IS
424: l_msg_count NUMBER;
425: l_msg_data VARCHAR2(2000);
426: l_location_obj HZ_LOCATION_OBJ;
427: BEGIN
428: l_location_obj := p_location_obj;
429: do_create_location_bo(
430: p_init_msg_list => fnd_api.g_true,

Line 457: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

453: -- DESCRIPTION
454: -- Update a location business object.
455: PROCEDURE do_update_location_bo(
456: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
457: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
458: p_created_by_module IN VARCHAR2,
459: p_obj_source IN VARCHAR2 := null,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,

Line 693: p_location_obj IN HZ_LOCATION_OBJ,

689: END do_update_location_bo;
690:
691: PROCEDURE update_location_bo(
692: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
693: p_location_obj IN HZ_LOCATION_OBJ,
694: p_created_by_module IN VARCHAR2,
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,
697: x_msg_data OUT NOCOPY VARCHAR2,

Line 702: l_location_obj HZ_LOCATION_OBJ;

698: x_location_id OUT NOCOPY NUMBER,
699: x_location_os OUT NOCOPY VARCHAR2,
700: x_location_osr OUT NOCOPY VARCHAR2
701: ) IS
702: l_location_obj HZ_LOCATION_OBJ;
703: BEGIN
704: l_location_obj := p_location_obj;
705: do_update_location_bo(
706: p_init_msg_list => p_init_msg_list,

Line 720: p_location_obj IN HZ_LOCATION_OBJ,

716: );
717: END update_location_bo;
718:
719: PROCEDURE update_location_bo(
720: p_location_obj IN HZ_LOCATION_OBJ,
721: p_created_by_module IN VARCHAR2,
722: p_obj_source IN VARCHAR2 := null,
723: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
724: x_return_status OUT NOCOPY VARCHAR2,

Line 726: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,

722: p_obj_source IN VARCHAR2 := null,
723: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
726: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
727: x_location_id OUT NOCOPY NUMBER,
728: x_location_os OUT NOCOPY VARCHAR2,
729: x_location_osr OUT NOCOPY VARCHAR2
730: ) IS

Line 733: l_location_obj HZ_LOCATION_OBJ;

729: x_location_osr OUT NOCOPY VARCHAR2
730: ) IS
731: l_msg_count NUMBER;
732: l_msg_data VARCHAR2(2000);
733: l_location_obj HZ_LOCATION_OBJ;
734: BEGIN
735: l_location_obj := p_location_obj;
736: do_update_location_bo(
737: p_init_msg_list => fnd_api.g_true,

Line 764: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,

760: -- Create or update a location business object.
761: PROCEDURE do_save_location_bo(
762: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
763: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
764: p_location_obj IN OUT NOCOPY HZ_LOCATION_OBJ,
765: p_created_by_module IN VARCHAR2,
766: p_obj_source IN VARCHAR2 := null,
767: x_return_status OUT NOCOPY VARCHAR2,
768: x_msg_count OUT NOCOPY NUMBER,

Line 928: p_location_obj IN HZ_LOCATION_OBJ,

924:
925: PROCEDURE save_location_bo(
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
928: p_location_obj IN HZ_LOCATION_OBJ,
929: p_created_by_module IN VARCHAR2,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,
932: x_msg_data OUT NOCOPY VARCHAR2,

Line 939: l_location_obj HZ_LOCATION_OBJ;

935: x_location_osr OUT NOCOPY VARCHAR2
936: ) IS
937: l_msg_count NUMBER;
938: l_msg_data VARCHAR2(2000);
939: l_location_obj HZ_LOCATION_OBJ;
940: BEGIN
941: l_location_obj := p_location_obj;
942: do_save_location_bo(
943: p_init_msg_list => p_init_msg_list,

Line 959: p_location_obj IN HZ_LOCATION_OBJ,

955: END save_location_bo;
956:
957: PROCEDURE save_location_bo(
958: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
959: p_location_obj IN HZ_LOCATION_OBJ,
960: p_created_by_module IN VARCHAR2,
961: p_obj_source IN VARCHAR2 := null,
962: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
963: x_return_status OUT NOCOPY VARCHAR2,

Line 965: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,

961: p_obj_source IN VARCHAR2 := null,
962: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
963: x_return_status OUT NOCOPY VARCHAR2,
964: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
965: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
966: x_location_id OUT NOCOPY NUMBER,
967: x_location_os OUT NOCOPY VARCHAR2,
968: x_location_osr OUT NOCOPY VARCHAR2
969: ) IS

Line 972: l_location_obj HZ_LOCATION_OBJ;

968: x_location_osr OUT NOCOPY VARCHAR2
969: ) IS
970: l_msg_count NUMBER;
971: l_msg_data VARCHAR2(2000);
972: l_location_obj HZ_LOCATION_OBJ;
973: BEGIN
974: l_location_obj := p_location_obj;
975: do_save_location_bo(
976: p_init_msg_list => fnd_api.g_true,

Line 1055: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,

1051: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1052: p_location_id IN NUMBER,
1053: p_location_os IN VARCHAR2,
1054: p_location_osr IN VARCHAR2,
1055: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,
1056: x_return_status OUT NOCOPY VARCHAR2,
1057: x_msg_count OUT NOCOPY NUMBER,
1058: x_msg_data OUT NOCOPY VARCHAR2
1059: ) IS

Line 1066: SELECT HZ_LOCATION_OBJ(

1062: l_location_os VARCHAR2(30);
1063: l_location_osr VARCHAR2(255);
1064:
1065: CURSOR c1(l_loc_id NUMBER) IS
1066: SELECT HZ_LOCATION_OBJ(
1067: NULL, --P_ACTION_TYPE,
1068: NULL, --COMMON_OBJ_ID
1069: LOC.LOCATION_ID,
1070: NULL, --ORIG_SYSTEM,

Line 1254: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,

1250: PROCEDURE get_location_bo (
1251: p_location_id IN NUMBER,
1252: p_location_os IN VARCHAR2,
1253: p_location_osr IN VARCHAR2,
1254: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,
1255: x_return_status OUT NOCOPY VARCHAR2,
1256: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1257: ) IS
1258: l_msg_count NUMBER;