APPS.PV_PARTNER_GEO_MATCH_PVT dependencies on JTF_NUMBER_TABLE

Line 73: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE

69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2
71:
72: ,p_partner_party_id IN NUMBER
73: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
74: ,x_geo_hierarchy_id OUT NOCOPY NUMBER
75: )
76:
77: IS

Line 103: SELECT * FROM TABLE (CAST(p_geo_hierarchy_id AS JTF_NUMBER_TABLE))

99: 'AREA2', 7,
100: 'AREA1', 8) LOC_TYPE
101: from JTF_LOC_HIERARCHIES_VL LH
102: where LH.location_hierarchy_id in (
103: SELECT * FROM TABLE (CAST(p_geo_hierarchy_id AS JTF_NUMBER_TABLE))
104: )
105: and lh.location_type_code in ('AREA1', 'AREA2', 'COUNTRY', 'CREGION', 'STATE', 'SREGION', 'CITY', 'POSTAL_CODE')
106: order by loc_type;
107:

Line 495: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE

491: *
492: ******/
493: PROCEDURE Get_Matched_Geo_Id_By_Country (
494: p_country IN VARCHAR2
495: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
496: ,x_geo_hierarchy_id OUT NOCOPY NUMBER
497: )
498: IS
499: CURSOR c_get_ordered_loc IS

Line 512: SELECT * FROM TABLE (CAST(p_geo_hierarchy_id AS JTF_NUMBER_TABLE))

508: 'AREA2', 7,
509: 'AREA1', 8) LOC_TYPE
510: from JTF_LOC_HIERARCHIES_VL LH
511: where LH.location_hierarchy_id in (
512: SELECT * FROM TABLE (CAST(p_geo_hierarchy_id AS JTF_NUMBER_TABLE))
513: )
514: and LH.LOCATION_TYPE_CODE in ('AREA1', 'AREA2', 'COUNTRY')
515: order by loc_type;
516:

Line 601: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE

597: ,x_msg_count OUT NOCOPY NUMBER
598: ,x_msg_data OUT NOCOPY VARCHAR2
599:
600: ,p_partner_id IN NUMBER
601: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
602: ,x_geo_hierarchy_id OUT NOCOPY NUMBER
603: )
604:
605: IS

Line 695: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE

691: ,x_msg_count OUT NOCOPY NUMBER
692: ,x_msg_data OUT NOCOPY VARCHAR2
693:
694: ,p_party_id IN NUMBER
695: ,p_geo_hierarchy_id IN JTF_NUMBER_TABLE
696: ,x_geo_hierarchy_id OUT NOCOPY NUMBER
697: )
698:
699: IS