73: return integer;
74:
75:
76: PROCEDURE xfer_tab_to_rec(
77: p_match_rec_of_tab IN CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
78: x_tab_of_rec OUT NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2
74:
75:
76: PROCEDURE xfer_tab_to_rec(
77: p_match_rec_of_tab IN CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
78: x_tab_of_rec OUT NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2
82:
83: );
84:
85:
86: PROCEDURE xfer_rec_to_tab(
87: p_tab_of_rec IN CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
88: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2
84:
85:
86: PROCEDURE xfer_rec_to_tab(
87: p_tab_of_rec IN CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
88: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2
92:
94:
95:
96: PROCEDURE prepare_bcol_temp_data(
97: p_source IN varchar2,
98: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2
102: );
101: x_msg_data OUT NOCOPY VARCHAR2
102: );
103:
104: PROCEDURE Insert_into_bcol_gt(
105: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2
109: );