9: --
10:
11: --public api changes
12: PROCEDURE user_non_updatable_columns
13: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
14: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
15: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
16: x_return_status OUT NOCOPY VARCHAR2);
17:
10:
11: --public api changes
12: PROCEDURE user_non_updatable_columns
13: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
14: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
15: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
16: x_return_status OUT NOCOPY VARCHAR2);
17:
18:
11: --public api changes
12: PROCEDURE user_non_updatable_columns
13: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
14: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
15: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
16: x_return_status OUT NOCOPY VARCHAR2);
17:
18:
19:
4117:
4118:
4119:
4120: PROCEDURE eliminate_displayonly_fields (
4121: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4122: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4123: , x_delivery_detail_rec IN OUT NOCOPY
4124: wsh_glbl_var_strct_grp.delivery_details_rec_type
4125: )
4118:
4119:
4120: PROCEDURE eliminate_displayonly_fields (
4121: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4122: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4123: , x_delivery_detail_rec IN OUT NOCOPY
4124: wsh_glbl_var_strct_grp.delivery_details_rec_type
4125: )
4126: IS
4120: PROCEDURE eliminate_displayonly_fields (
4121: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4122: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
4123: , x_delivery_detail_rec IN OUT NOCOPY
4124: wsh_glbl_var_strct_grp.delivery_details_rec_type
4125: )
4126: IS
4127:
4128: -- Bug 5728048
4518: -----------------------------------------------------------*/
4519:
4520: PROCEDURE disable_from_list(
4521: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4522: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4523: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4524: , x_return_status OUT NOCOPY VARCHAR2
4525: , x_field_name OUT NOCOPY VARCHAR2
4526:
4519:
4520: PROCEDURE disable_from_list(
4521: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4522: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4523: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4524: , x_return_status OUT NOCOPY VARCHAR2
4525: , x_field_name OUT NOCOPY VARCHAR2
4526:
4527: ) IS
4681: -----------------------------------------------------------*/
4682:
4683: PROCEDURE enable_from_list(
4684: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4685: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4686: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4687: , x_return_status OUT NOCOPY VARCHAR2
4688: , x_field_name OUT NOCOPY VARCHAR2
4689:
4682:
4683: PROCEDURE enable_from_list(
4684: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
4685: , p_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
4686: , x_out_rec IN OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
4687: , x_return_status OUT NOCOPY VARCHAR2
4688: , x_field_name OUT NOCOPY VARCHAR2
4689:
4690: ) IS
5183: --
5184: -- Overloaded procedure
5185: --
5186: PROCEDURE Get_Disabled_List (
5187: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
5188: , p_delivery_id IN NUMBER
5189: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5190: , x_return_status OUT NOCOPY VARCHAR2
5191: , x_msg_count OUT NOCOPY NUMBER
5185: --
5186: PROCEDURE Get_Disabled_List (
5187: p_delivery_detail_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type
5188: , p_delivery_id IN NUMBER
5189: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5190: , x_return_status OUT NOCOPY VARCHAR2
5191: , x_msg_count OUT NOCOPY NUMBER
5192: , x_msg_data OUT NOCOPY VARCHAR2
5193: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5189: , p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType
5190: , x_return_status OUT NOCOPY VARCHAR2
5191: , x_msg_count OUT NOCOPY NUMBER
5192: , x_msg_data OUT NOCOPY VARCHAR2
5193: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5194: )
5195: IS
5196: l_disabled_list WSH_UTIL_CORE.column_tab_type;
5197: l_db_col_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
5193: , x_delivery_detail_rec OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
5194: )
5195: IS
5196: l_disabled_list WSH_UTIL_CORE.column_tab_type;
5197: l_db_col_rec wsh_glbl_var_strct_grp.delivery_details_rec_type;
5198: l_return_status VARCHAR2(30);
5199: l_field_name VARCHAR2(100);
5200: j NUMBER := 0;
5201: l_status_code VARCHAR2(3);
7381: END validate_secondary_quantity;
7382:
7383: --public api change
7384: PROCEDURE user_non_updatable_columns
7385: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7386: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7387: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7388: x_return_status OUT NOCOPY VARCHAR2)
7389:
7382:
7383: --public api change
7384: PROCEDURE user_non_updatable_columns
7385: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7386: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7387: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7388: x_return_status OUT NOCOPY VARCHAR2)
7389:
7390: IS
7383: --public api change
7384: PROCEDURE user_non_updatable_columns
7385: (p_user_in_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7386: p_out_rec IN wsh_glbl_var_strct_grp.delivery_details_rec_type,
7387: p_in_rec IN wsh_glbl_var_strct_grp.detailInRecType,
7388: x_return_status OUT NOCOPY VARCHAR2)
7389:
7390: IS
7391: l_attributes VARCHAR2(2500) ;