27: **********************************************************************/
28:
29:
30: PROCEDURE get_flex_eam_sub_res
31: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
32: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
33: )
34: IS
35: BEGIN
28:
29:
30: PROCEDURE get_flex_eam_sub_res
31: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
32: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
33: )
34: IS
35: BEGIN
36:
114: * attribute with appropriate values.
115: **********************************************************************/
116:
117: PROCEDURE Attribute_Defaulting
118: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
119: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
120: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
121: , x_return_status OUT NOCOPY VARCHAR2
122: )
115: **********************************************************************/
116:
117: PROCEDURE Attribute_Defaulting
118: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
119: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
120: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
121: , x_return_status OUT NOCOPY VARCHAR2
122: )
123: IS
120: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
121: , x_return_status OUT NOCOPY VARCHAR2
122: )
123: IS
124: l_eam_sub_res_rec EAM_PROCESS_WO_PUB.eam_sub_res_rec_type;
125: BEGIN
126:
127: x_eam_sub_res_rec := p_eam_sub_res_rec;
128: -- x_eam_sub_res_rec := p_eam_sub_res_rec;
150: * value from the old record.
151: * This procedure is not called for CREATE
152: ********************************************************************/
153: PROCEDURE Populate_Null_Columns
154: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
155: , p_old_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
156: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
157: )
158: IS
151: * This procedure is not called for CREATE
152: ********************************************************************/
153: PROCEDURE Populate_Null_Columns
154: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
155: , p_old_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
156: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
157: )
158: IS
159: BEGIN
152: ********************************************************************/
153: PROCEDURE Populate_Null_Columns
154: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
155: , p_old_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
156: , x_eam_sub_res_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
157: )
158: IS
159: BEGIN
160: x_eam_sub_res_rec := p_eam_sub_res_rec;