APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERRITORY_GET_PUB

Line 53: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,

49: * 05/07/2003 yzhao SQL bind variable project
50: *****************************************************************************/
51: PROCEDURE compose_qualifier_values
52: (
53: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,
54: p_bindvar_index IN NUMBER,
55: p_bind_vars IN BIND_TBL_TYPE,
56: x_cond_str OUT NOCOPY VARCHAR2,
57: x_bind_vars OUT NOCOPY BIND_TBL_TYPE

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

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

Line 150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;

146: l_tmp_str CLOB;
147: J NUMBER;
148: l_hzsql_table VARCHAR2_TBL_TYPE;
149: l_terr_qual_id NUMBER;
150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

Line 151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;

147: J NUMBER;
148: l_hzsql_table VARCHAR2_TBL_TYPE;
149: l_terr_qual_id NUMBER;
150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

Line 152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;

148: l_hzsql_table VARCHAR2_TBL_TYPE;
149: l_terr_qual_id NUMBER;
150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

Line 153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;

149: l_terr_qual_id NUMBER;
150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

Line 154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

150: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
158: -- This one is required ....

Line 155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

151: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
158: -- This one is required ....
159: l_hzparty_sql CLOB := null;

Line 156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

152: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
158: -- This one is required ....
159: l_hzparty_sql CLOB := null;
160: l_hzpartyacc_sql CLOB := null;

Line 157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

153: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
154: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
155: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
156: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
157: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
158: -- This one is required ....
159: l_hzparty_sql CLOB := null;
160: l_hzpartyacc_sql CLOB := null;
161: -- This is required ....

Line 184: JTF_TERRITORY_GET_PUB.Get_Territory_Details(

180: l_child_bind_vars BIND_TBL_TYPE;
181: l_index NUMBER;
182: BEGIN
183: --
184: JTF_TERRITORY_GET_PUB.Get_Territory_Details(
185: p_Api_Version => l_api_version,
186: p_Init_Msg_List => FND_API.G_FALSE,
187: x_return_status => l_return_status,
188: x_msg_count => l_msg_count,