APPS.AMS_CHANNEL_PVT dependencies on AMS_CHANNELS_VL

Line 70: FROM ams_channels_vl

66: FROM DUAL;
67:
68: CURSOR c_chan_count(chan_id IN NUMBER) IS
69: SELECT COUNT(*)
70: FROM ams_channels_vl
71: WHERE channel_id = chan_id;
72:
73: BEGIN
74:

Line 1136: FROM ams_channels_vl

1132:
1133: -- Modified by rrajesh 12/07/00
1134: /*CURSOR c_name_unique_cr (p_channel_name IN VARCHAR2) IS
1135: SELECT COUNT(1)
1136: FROM ams_channels_vl
1137: WHERE UPPER(channel_name) = UPPER(p_channel_name) ;*/
1138: CURSOR c_name_unique_cr (p_channel_name IN VARCHAR2, p_country_id IN NUMBER) IS
1139: SELECT COUNT(1)
1140: FROM ams_channels_vl

Line 1140: FROM ams_channels_vl

1136: FROM ams_channels_vl
1137: WHERE UPPER(channel_name) = UPPER(p_channel_name) ;*/
1138: CURSOR c_name_unique_cr (p_channel_name IN VARCHAR2, p_country_id IN NUMBER) IS
1139: SELECT COUNT(1)
1140: FROM ams_channels_vl
1141: WHERE UPPER(channel_name) = UPPER(p_channel_name)
1142: AND country_id = p_country_id;
1143:
1144: /*CURSOR c_name_unique_up (p_channel_name IN VARCHAR2, p_channel_id IN NUMBER) IS

Line 1146: FROM ams_channels_vl

1142: AND country_id = p_country_id;
1143:
1144: /*CURSOR c_name_unique_up (p_channel_name IN VARCHAR2, p_channel_id IN NUMBER) IS
1145: SELECT COUNT(1)
1146: FROM ams_channels_vl
1147: WHERE UPPER(channel_name) = UPPER(p_channel_name)
1148: AND channel_id <> p_channel_id ;*/
1149: CURSOR c_name_unique_up (p_channel_name IN VARCHAR2, p_channel_id IN NUMBER, p_country_id IN NUMBER) IS
1150: SELECT COUNT(1)

Line 1151: FROM ams_channels_vl

1147: WHERE UPPER(channel_name) = UPPER(p_channel_name)
1148: AND channel_id <> p_channel_id ;*/
1149: CURSOR c_name_unique_up (p_channel_name IN VARCHAR2, p_channel_id IN NUMBER, p_country_id IN NUMBER) IS
1150: SELECT COUNT(1)
1151: FROM ams_channels_vl
1152: WHERE UPPER(channel_name) = UPPER(p_channel_name)
1153: AND country_id = p_country_id
1154: AND channel_id <> p_channel_id ;
1155: --end 12/07/00

Line 1167: 'ams_channels_vl',

1163: IF p_validation_mode = JTF_PLSQL_API.g_create
1164: AND p_chan_rec.channel_id IS NOT NULL
1165: THEN
1166: IF AMS_Utility_PVT.check_uniqueness(
1167: 'ams_channels_vl',
1168: 'channel_id = ' || p_chan_rec.channel_id
1169: ) = FND_API.g_false
1170: THEN
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1196: -- 'ams_channels_vl',

1192: FETCH c_name_unique_cr INTO l_count ;
1193: CLOSE c_name_unique_cr ;
1194:
1195: --l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1196: -- 'ams_channels_vl',
1197: -- 'channel_name = ''' || p_chan_rec.channel_name ||''''
1198: --);
1199: ELSE
1200: --l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1201: -- 'ams_channels_vl',

1197: -- 'channel_name = ''' || p_chan_rec.channel_name ||''''
1198: --);
1199: ELSE
1200: --l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1201: -- 'ams_channels_vl',
1202: -- 'channel_name = ''' || p_chan_rec.channel_name ||
1203: -- ''' AND channel_id <> ' || p_chan_rec.channel_id
1204: --);
1205: -- modified by rrajesh on 12/07/00

Line 1659: FROM ams_channels_vl

1655: IS
1656:
1657: CURSOR c_chan IS
1658: SELECT *
1659: FROM ams_channels_vl
1660: WHERE channel_id = p_chan_rec.channel_id;
1661:
1662: l_chan_rec c_chan%ROWTYPE;
1663:

Line 1818: -- FROM AMS_CHANNELS_VL

1814: -- get_party_name
1815: -- USAGE
1816: -- Example:
1817: -- SELECT AMS_CHANNEL_PVT.get_party_name (party_id)
1818: -- FROM AMS_CHANNELS_VL
1819: -- HISTORY
1820: -- 25-MAY-2000 gjoby Created.
1821: ---------------------------------------------------------------------
1822: FUNCTION get_party_name (

Line 1853: -- FROM AMS_CHANNELS_VL

1849: -- get_party_number
1850: -- USAGE
1851: -- Example:
1852: -- SELECT AMS_CHANNEL_PVT.get_party_number(party_id)
1853: -- FROM AMS_CHANNELS_VL
1854: -- HISTORY
1855: -- 25-MAY-2000 gjoby Created.
1856: ---------------------------------------------------------------------
1857: FUNCTION get_party_number (

Line 1887: -- FROM AMS_CHANNELS_VL

1883: -- get_party_type
1884: -- USAGE
1885: -- Example:
1886: -- SELECT AMS_CHANNEL_PVT.get_party_type(party_id)
1887: -- FROM AMS_CHANNELS_VL
1888: -- HISTORY
1889: -- 25-MAY-2000 gjoby Created.
1890: ---------------------------------------------------------------------
1891: FUNCTION get_party_type (

Line 1920: -- FROM AMS_CHANNELS_VL

1916: -- get_vendor_name
1917: -- USAGE
1918: -- Example:
1919: -- SELECT AMS_CHANNEL_PVT.get_vendor_name (PREFERRED_vendor_id)
1920: -- FROM AMS_CHANNELS_VL
1921: -- HISTORY
1922: -- 25-MAY-2000 gjoby Created.
1923: ---------------------------------------------------------------------
1924: FUNCTION get_vendor_name (