APPS.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERRITORY_GET_PUB

Line 2062: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,

2058: *****************************************************************************/
2059:
2060: PROCEDURE compose_qualifier_values
2061: (
2062: p_value_rec IN JTF_TERRITORY_GET_PUB.Terr_Values_Rec_Type,
2063: p_bindvar_index IN NUMBER,
2064: p_bind_vars IN BIND_TBL_TYPE,
2065: x_cond_str OUT NOCOPY VARCHAR2,
2066: x_bind_vars OUT NOCOPY BIND_TBL_TYPE

Line 2139: * JTF_TERRITORY_GET_PUB.Get_Territory_Details() is not publicly supported. Change it when api is public

2135: * to get qualifier information of a territory
2136: *
2137: * NOTES
2138: * 1. currently JTF territory has no public api for getting territory detail information
2139: * JTF_TERRITORY_GET_PUB.Get_Territory_Details() is not publicly supported. Change it when api is public
2140: * 2. I'm concerned about the sql buffer size. As territory qualifier combination grows,
2141: * it may exceed the limit?
2142: *
2143: * HISTORY

Line 2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;

2161: l_tmp_str VARCHAR2(2000);
2162: J NUMBER;
2163: l_hzsql_table VARCHAR2_TBL_TYPE;
2164: l_terr_qual_id NUMBER;
2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

Line 2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;

2162: J NUMBER;
2163: l_hzsql_table VARCHAR2_TBL_TYPE;
2164: l_terr_qual_id NUMBER;
2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

Line 2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;

2163: l_hzsql_table VARCHAR2_TBL_TYPE;
2164: l_terr_qual_id NUMBER;
2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

Line 2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;

2164: l_terr_qual_id NUMBER;
2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

Line 2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;

2165: l_terr_rec JTF_TERRITORY_GET_PUB.Terr_Rec_Type;
2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
2173: -- This one is required ....

Line 2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;

2166: l_terr_type_rec JTF_TERRITORY_GET_PUB.Terr_Type_Rec_Type;
2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
2173: -- This one is required ....
2174: l_hzparty_sql VARCHAR2(32000) := null;

Line 2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;

2167: l_terr_child_table JTF_TERRITORY_GET_PUB.Terr_Tbl_Type;
2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
2173: -- This one is required ....
2174: l_hzparty_sql VARCHAR2(32000) := null;
2175: l_hzpartyacc_sql VARCHAR2(32000) := null;

Line 2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;

2168: l_terr_usgs_table JTF_TERRITORY_GET_PUB.Terr_Usgs_Tbl_Type;
2169: l_terr_qtype_usgs_table JTF_TERRITORY_GET_PUB.Terr_QType_Usgs_Tbl_Type;
2170: l_terr_qual_table JTF_TERRITORY_GET_PUB.Terr_Qual_Tbl_Type;
2171: l_terr_values_table JTF_TERRITORY_GET_PUB.Terr_Values_Tbl_Type;
2172: l_terr_rsc_table JTF_TERRITORY_GET_PUB.Terr_Rsc_Tbl_Type;
2173: -- This one is required ....
2174: l_hzparty_sql VARCHAR2(32000) := null;
2175: l_hzpartyacc_sql VARCHAR2(32000) := null;
2176: -- This is required ....

Line 2197: JTF_TERRITORY_GET_PUB.Get_Territory_Details(

2193: l_bind_vars BIND_TBL_TYPE;
2194: l_child_bind_vars BIND_TBL_TYPE;
2195: l_index NUMBER;
2196: BEGIN
2197: JTF_TERRITORY_GET_PUB.Get_Territory_Details(
2198: p_Api_Version => l_api_version,
2199: p_Init_Msg_List => FND_API.G_FALSE,
2200: x_return_status => l_return_status,
2201: x_msg_count => l_msg_count,