1190: ----------------------------*/
1191:
1192: PROCEDURE populate_parent_ato(
1193: P_Source in varchar2,
1194: P_tab_of_rec in out NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1195: x_return_status OUT NOCOPY VARCHAR2,
1196: x_msg_count OUT NOCOPY NUMBER,
1197: x_msg_data OUT NOCOPY VARCHAR2
1198:
1206:
1207: ----------------------------*/
1208:
1209: PROCEDURE xfer_tab_to_rec(
1210: p_match_rec_of_tab IN CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
1211: x_tab_of_rec OUT NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1212: x_return_status OUT NOCOPY VARCHAR2,
1213: x_msg_count OUT NOCOPY NUMBER,
1214: x_msg_data OUT NOCOPY VARCHAR2
1207: ----------------------------*/
1208:
1209: PROCEDURE xfer_tab_to_rec(
1210: p_match_rec_of_tab IN CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
1211: x_tab_of_rec OUT NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1212: x_return_status OUT NOCOPY VARCHAR2,
1213: x_msg_count OUT NOCOPY NUMBER,
1214: x_msg_data OUT NOCOPY VARCHAR2
1215:
1325:
1326: END xfer_tab_to_rec;
1327:
1328: PROCEDURE xfer_rec_to_tab(
1329: p_tab_of_rec IN CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1330: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
1331: x_return_status OUT NOCOPY VARCHAR2,
1332: x_msg_count OUT NOCOPY NUMBER,
1333: x_msg_data OUT NOCOPY VARCHAR2
1326: END xfer_tab_to_rec;
1327:
1328: PROCEDURE xfer_rec_to_tab(
1329: p_tab_of_rec IN CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1330: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
1331: x_return_status OUT NOCOPY VARCHAR2,
1332: x_msg_count OUT NOCOPY NUMBER,
1333: x_msg_data OUT NOCOPY VARCHAR2
1334:
1453:
1454:
1455: PROCEDURE populate_parent_ato(
1456: P_Source in Varchar2,
1457: P_tab_of_rec in out NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1458: x_return_status OUT NOCOPY VARCHAR2,
1459: x_msg_count OUT NOCOPY NUMBER,
1460: x_msg_data OUT NOCOPY VARCHAR2
1461: )
1750:
1751:
1752:
1753: PROCEDURE populate_plan_level
1754: ( P_tab_of_rec in out NOCOPY CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE,
1755: x_return_status OUT NOCOPY VARCHAR2,
1756: x_msg_count OUT NOCOPY NUMBER,
1757: x_msg_data OUT NOCOPY VARCHAR2)
1758: is
2842:
2843:
2844: PROCEDURE prepare_bcol_temp_data(
2845: p_source IN VARCHAR2,
2846: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
2847: x_return_status OUT NOCOPY VARCHAR2,
2848: x_msg_count OUT NOCOPY NUMBER,
2849: x_msg_data OUT NOCOPY VARCHAR2
2850: )
2852: l_last_index number;
2853:
2854: l_row_count number;
2855:
2856: l_tab_of_rec CTO_Configured_Item_GRP.TEMP_TAB_OF_REC_TYPE;
2857: --l_return_status VARCHAR2(1);
2858: -- l_msg_count number;
2859: -- l_msg_data varchar2(;
2860: lStmtNum NUMBER;
3041: in the data
3042:
3043: ------------------------*/
3044: PROCEDURE Insert_into_bcol_gt(
3045: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
3046: x_return_status OUT NOCOPY VARCHAR2,
3047: x_msg_count OUT NOCOPY NUMBER,
3048: x_msg_data OUT NOCOPY VARCHAR2
3049: )