DBA Data[Home] [Help]

APPS.CTO_GOP_INTERFACE_PK dependencies on CTO_CONFIGURED_ITEM_GRP

Line 52: PROCEDURE init_rec(p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE)

48: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_GOP_INTERFACE_PK';
49: --remove teh level 5
50: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
51:
52: PROCEDURE init_rec(p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE)
53: AS
54: BEGIN
55: p_match_rec_of_tab.CONFIG_ITEM_ID.delete;
56: p_match_rec_of_tab.LINE_ID.delete;

Line 80: p_match_rec_of_tab.Attribute_6 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);

76: p_match_rec_of_tab.Attribute_2.delete;
77: p_match_rec_of_tab.Attribute_3.delete;
78: p_match_rec_of_tab.Attribute_4.delete;
79: p_match_rec_of_tab.Attribute_5.delete;
80: p_match_rec_of_tab.Attribute_6 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
81: p_match_rec_of_tab.Attribute_6.delete;
82: p_match_rec_of_tab.Attribute_7 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
83: p_match_rec_of_tab.Attribute_7.delete;
84: p_match_rec_of_tab.Attribute_8 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);

Line 82: p_match_rec_of_tab.Attribute_7 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);

78: p_match_rec_of_tab.Attribute_4.delete;
79: p_match_rec_of_tab.Attribute_5.delete;
80: p_match_rec_of_tab.Attribute_6 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
81: p_match_rec_of_tab.Attribute_6.delete;
82: p_match_rec_of_tab.Attribute_7 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
83: p_match_rec_of_tab.Attribute_7.delete;
84: p_match_rec_of_tab.Attribute_8 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
85: p_match_rec_of_tab.Attribute_8.delete;
86: p_match_rec_of_tab.Attribute_9.delete;

Line 84: p_match_rec_of_tab.Attribute_8 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);

80: p_match_rec_of_tab.Attribute_6 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
81: p_match_rec_of_tab.Attribute_6.delete;
82: p_match_rec_of_tab.Attribute_7 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
83: p_match_rec_of_tab.Attribute_7.delete;
84: p_match_rec_of_tab.Attribute_8 := CTO_Configured_Item_GRP.date_arr_tbl_type(NULL);
85: p_match_rec_of_tab.Attribute_8.delete;
86: p_match_rec_of_tab.Attribute_9.delete;
87: END init_rec;
88:

Line 102: p_cto_match_rec IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE) AS

98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_Action IN VARCHAR2,
101: p_Source IN VARCHAR2 ,
102: p_cto_match_rec IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE) AS
103:
104: --
105: -- Bug 16352937
106: -- Removed the Pragma and the Commit. this is because the match API would

Line 124: CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM (

120:
121: --
122: -- bug 16352937
123: --
124: CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM (
125: p_api_version => p_api_version,
126: x_return_status => x_return_status,
127: x_msg_count => X_msg_count,
128: x_msg_data => X_msg_data,

Line 153: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,

149:
150: PROCEDURE CTO_GOP_WRAPPER_API (
151: p_Action IN VARCHAR2,
152: p_Source IN VARCHAR2,
153: p_match_rec_of_tab IN OUT NOCOPY CTO_Configured_Item_GRP.CTO_MATCH_REC_TYPE,
154: X_oss_orgs_list OUT NOCOPY CTO_OSS_SOURCE_PK.Oss_orgs_list_rec_type,
155: x_return_status OUT NOCOPY VARCHAR2,
156: X_msg_count OUT NOCOPY number,
157: X_msg_data OUT NOCOPY Varchar2

Line 432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);

428: p_cto_match_rec => p_match_rec_of_tab);
429:
430: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
431: IF PG_DEBUG <> 0 THEN
432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN