15: WHERE DELIVERY_DETAIL_ID = p_detail_id;
16:
17: --public api changes
18: PROCEDURE user_non_updatable_columns
19: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
20: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
21: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
22: x_return_status OUT NOCOPY VARCHAR2);
23:
16:
17: --public api changes
18: PROCEDURE user_non_updatable_columns
19: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
20: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
21: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
22: x_return_status OUT NOCOPY VARCHAR2);
23:
24:
17: --public api changes
18: PROCEDURE user_non_updatable_columns
19: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
20: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
21: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
22: x_return_status OUT NOCOPY VARCHAR2);
23:
24:
25:
4292:
4293:
4294:
4295: PROCEDURE eliminate_displayonly_fields (
4296: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4297: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4298: , x_delivery_detail_rec IN OUT NOCOPY
4299: wsh_glbl_var_strct_grp.delivery_details_rec_type
4300: )
4293:
4294:
4295: PROCEDURE eliminate_displayonly_fields (
4296: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4297: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4298: , x_delivery_detail_rec IN OUT NOCOPY
4299: wsh_glbl_var_strct_grp.delivery_details_rec_type
4300: )
4301: IS
4295: PROCEDURE eliminate_displayonly_fields (
4296: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4297: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4298: , x_delivery_detail_rec IN OUT NOCOPY
4299: wsh_glbl_var_strct_grp.delivery_details_rec_type
4300: )
4301: IS
4302:
4303: -- Bug 5728048
4693: -----------------------------------------------------------*/
4694:
4695: PROCEDURE disable_from_list(
4696: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4697: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4698: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4699: , x_return_status OUT NOCOPY VARCHAR2
4700: , x_field_name OUT NOCOPY VARCHAR2
4701:
4694:
4695: PROCEDURE disable_from_list(
4696: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4697: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4698: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4699: , x_return_status OUT NOCOPY VARCHAR2
4700: , x_field_name OUT NOCOPY VARCHAR2
4701:
4702: ) IS
4856: -----------------------------------------------------------*/
4857:
4858: PROCEDURE enable_from_list(
4859: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4860: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4861: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4862: , x_return_status OUT NOCOPY VARCHAR2
4863: , x_field_name OUT NOCOPY VARCHAR2
4864:
4857:
4858: PROCEDURE enable_from_list(
4859: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4860: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4861: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4862: , x_return_status OUT NOCOPY VARCHAR2
4863: , x_field_name OUT NOCOPY VARCHAR2
4864:
4865: ) IS
5370: --
5371: -- Overloaded procedure
5372: --
5373: PROCEDURE Get_Disabled_List (
5374: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
5375: , p_delivery_id IN NUMBER
5376: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5377: , x_return_status OUT NOCOPY VARCHAR2
5378: , x_msg_count OUT NOCOPY NUMBER
5372: --
5373: PROCEDURE Get_Disabled_List (
5374: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
5375: , p_delivery_id IN NUMBER
5376: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5377: , x_return_status OUT NOCOPY VARCHAR2
5378: , x_msg_count OUT NOCOPY NUMBER
5379: , x_msg_data OUT NOCOPY VARCHAR2
5380: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5376: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5377: , x_return_status OUT NOCOPY VARCHAR2
5378: , x_msg_count OUT NOCOPY NUMBER
5379: , x_msg_data OUT NOCOPY VARCHAR2
5380: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5381: )
5382: IS
5383: l_disabled_list WSH_UTIL_CORE.column_tab_type;
5384: l_db_col_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
5380: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5381: )
5382: IS
5383: l_disabled_list WSH_UTIL_CORE.column_tab_type;
5384: l_db_col_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
5385: l_return_status VARCHAR2(30);
5386: l_field_name VARCHAR2(100);
5387: j NUMBER := 0;
5388: l_status_code VARCHAR2(3);
7671: END validate_secondary_quantity;
7672:
7673: --public api change
7674: PROCEDURE user_non_updatable_columns
7675: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7676: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7677: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7678: x_return_status OUT NOCOPY VARCHAR2)
7679:
7672:
7673: --public api change
7674: PROCEDURE user_non_updatable_columns
7675: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7676: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7677: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7678: x_return_status OUT NOCOPY VARCHAR2)
7679:
7680: IS
7673: --public api change
7674: PROCEDURE user_non_updatable_columns
7675: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7676: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7677: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7678: x_return_status OUT NOCOPY VARCHAR2)
7679:
7680: IS
7681: l_attributes VARCHAR2(2500) ;