APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERRITORY_GET_PUB

Line 48: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,

44: * 05/07/2003 yzhao SQL bind variable project
45: *****************************************************************************/
46: PROCEDURE compose_qualifier_values
47: (
48: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,
49: p_bindvar_index IN NUMBER,
50: p_bind_vars IN BIND_TBL_TYPE,
51: x_cond_str OUT NOCOPY VARCHAR2,
52: x_bind_vars OUT NOCOPY BIND_TBL_TYPE

Line 119: * JTF_TERRITORY_GET_PUB.Get_Territory_Details() is not publicly supported.

115: * to get qualifier information of a territory
116: *
117: * NOTES
118: * 1. currently JTF territory has no public api for getting territory detail information
119: * JTF_TERRITORY_GET_PUB.Get_Territory_Details() is not publicly supported.
120: * Change it when api is public
121: * 2. I'm concerned about the sql buffer size. As territory qualifier combination grows,
122: * it may exceed the limit?
123: *

Line 145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;

141: l_tmp_str CLOB;
142: J NUMBER;
143: l_hzsql_table VARCHAR2_TBL_TYPE;
144: l_terr_qual_id NUMBER;
145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

Line 146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;

142: J NUMBER;
143: l_hzsql_table VARCHAR2_TBL_TYPE;
144: l_terr_qual_id NUMBER;
145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

Line 147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;

143: l_hzsql_table VARCHAR2_TBL_TYPE;
144: l_terr_qual_id NUMBER;
145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

Line 148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;

144: l_terr_qual_id NUMBER;
145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

Line 149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

145: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
153: -- This one is required ....

Line 150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

146: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
153: -- This one is required ....
154: l_hzparty_sql CLOB := null;

Line 151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

147: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
153: -- This one is required ....
154: l_hzparty_sql CLOB := null;
155: l_hzpartyacc_sql CLOB := null;

Line 152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

148: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
149: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
150: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
151: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
152: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
153: -- This one is required ....
154: l_hzparty_sql CLOB := null;
155: l_hzpartyacc_sql CLOB := null;
156: -- This is required ....

Line 179: JTF_TERRITORY_GET_PUB.Get_Territory_Details(

175: l_child_bind_vars BIND_TBL_TYPE;
176: l_index NUMBER;
177: BEGIN
178: --
179: JTF_TERRITORY_GET_PUB.Get_Territory_Details(
180: p_Api_Version => l_api_version,
181: p_Init_Msg_List => FND_API.G_FALSE,
182: x_return_status => l_return_status,
183: x_msg_count => l_msg_count,