DBA Data[Home] [Help]

APPS.JTF_PREFAB_POLICY_PUB dependencies on JTF_PREFAB_WSH_POES_B

Line 875: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,

871: p_api_version IN NUMBER,
872: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
873: p_commit IN VARCHAR2 := FND_API.G_FALSE,
874:
875: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,

Line 876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,

872: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
873: p_commit IN VARCHAR2 := FND_API.G_FALSE,
874:
875: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,

Line 878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,

874:
875: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

Line 879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,

875: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
883:

Line 880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,

876: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
883:
884: p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,

Line 881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,

877: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
883:
884: p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
885:

Line 882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

878: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
879: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
883:
884: p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
885:
886: x_return_status OUT NOCOPY VARCHAR2,

Line 884: p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,

880: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
881: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
882: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
883:
884: p_object_version_number OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
885:
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2

Line 896: SELECT jtf_prefab_wsh_poes_b_s.NEXTVAL from dual;

892: l_api_version NUMBER := p_api_version;
893: l_row_id VARCHAR2(255) := NULL;
894:
895: CURSOR sequence_cursor IS
896: SELECT jtf_prefab_wsh_poes_b_s.NEXTVAL from dual;
897: BEGIN
898: -- Standard Start of API savepoint
899: SAVEPOINT INSERT_WSH_POLICY;
900:

Line 1029: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,

1025: p_api_version IN NUMBER,
1026: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1027: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1028:
1029: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,

Line 1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,

1026: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1027: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1028:
1029: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,

Line 1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,

1028:
1029: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

Line 1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,

1029: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
1037:

Line 1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,

1030: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
1037:
1038: p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,

Line 1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,

1031: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
1037:
1038: p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
1039:

Line 1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

1032: p_weight IN jtf_prefab_wsh_poes_b.weight%TYPE,
1033: p_load_pick_up_flag IN jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
1037:
1038: p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
1039:
1040: x_return_status OUT NOCOPY VARCHAR2,

Line 1038: p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,

1034: p_cache_size IN jtf_prefab_wsh_poes_b.cache_size%TYPE,
1035: p_wsh_type IN jtf_prefab_wsh_poes_b.wsh_type%TYPE,
1036: p_prefab_enabled_flag IN jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,
1037:
1038: p_object_version_number IN OUT NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,
1039:
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2

Line 1151: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,

1147: p_api_version IN NUMBER,
1148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1150:
1151: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1152:
1153: p_object_version_number IN jtf_prefab_wsh_poes_b.object_version_number%TYPE,
1154:
1155: x_return_status OUT NOCOPY VARCHAR2,

Line 1153: p_object_version_number IN jtf_prefab_wsh_poes_b.object_version_number%TYPE,

1149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1150:
1151: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
1152:
1153: p_object_version_number IN jtf_prefab_wsh_poes_b.object_version_number%TYPE,
1154:
1155: x_return_status OUT NOCOPY VARCHAR2,
1156: x_msg_count OUT NOCOPY NUMBER,
1157: x_msg_data OUT NOCOPY VARCHAR2