APPS.AMS_FULFILL_PVT dependencies on AMS_LIST_ENTRIES

Line 17: -- in ams_list_entries table

13: -- 05/08/2000 ptendulk Modified , Get the cover letter from Schedules
14: -- table instead of campaign table
15: -- 05/22/2000 ptendulk Modified AMS_FULFILL procedure, Get the partyid
16: -- from party id column instead of customer id column
17: -- in ams_list_entries table
18: -- 11-Dec-2000 ptendulk Added additional parameter in GetMasterInfo
19: -- Ref Bug # 1529231
20: -- 01-Feb-2001 ptendulk Added additional where clause in ams_fulfill
21: -- Refer Bug # 1618348

Line 136: FROM ams_list_entries

132: CURSOR c_list_ent_det IS
133: SELECT list_entry_source_system_id party_id,
134: fax,
135: email_address
136: FROM ams_list_entries
137: WHERE list_header_id = p_list_header_id ;
138: l_list_rec c_list_ent_det%ROWTYPE ;
139:
140: BEGIN

Line 372: -- in ams_list_entries table

368: -- 05/09/2000 ptendulk Modified 1.Get the subject from the schedules table
369: -- 2. get the user id from FND_GLOBALS
370: -- 05/22/2000 ptendulk Modified AMS_FULFILL procedure, Get the partyid
371: -- from party id column instead of customer id column
372: -- in ams_list_entries table
373: -- 11-Dec-2000 ptendulk Added the extra paramter in spec of get content XML
374: -- Ref Bug # 1529231
375: -- 13-Jun-2001 ptendulk Added schedule source code,objectid to the api to
376: -- write to interaction.

Line 1877: -- in ams_list_entries table

1873: -- 05/09/2000 ptendulk Modified 1.Get the subject from the schedules table
1874: -- 2. get the user id from FND_GLOBALS
1875: -- 05/22/2000 ptendulk Modified AMS_FULFILL procedure, Get the partyid
1876: -- from party id column instead of customer id column
1877: -- in ams_list_entries table
1878: -- 11-Dec-2000 ptendulk Added the extra paramter in spec of get content XML
1879: -- Ref Bug # 1529231
1880: -- 13-Jun-2001 ptendulk Added schedule source code,objectid to the api to
1881: -- write to interaction.

Line 1922: -- party id column instead of customer id column in ams_list_entries

1918: -- resolves their bug for having party name mandatory
1919:
1920: -- ===============================================================================
1921: -- Following code is modified by ptendulk on May22-00 to get the party id from
1922: -- party id column instead of customer id column in ams_list_entries
1923: -- ===============================================================================
1924: CURSOR c_list_ent_det IS
1925: SELECT party_id,
1926: fax,

Line 1929: FROM ams_list_entries

1925: SELECT party_id,
1926: fax,
1927: email_address,
1928: first_name
1929: FROM ams_list_entries
1930: WHERE list_header_id = p_list_header_id
1931: -- Following code is added by ptendulk on 01-Feb-2001
1932: -- Refer Bug # 1618348
1933: AND enabled_flag = 'Y' ;

Line 2329: -- Following cursor will select dummy entry from ams_list_entries to

2325: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2326: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2327: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2328:
2329: -- Following cursor will select dummy entry from ams_list_entries to
2330: -- send the test mail.
2331: CURSOR c_list_entry IS
2332: SELECT party_id, list_header_id,first_name
2333: FROM ams_list_entries

Line 2333: FROM ams_list_entries

2329: -- Following cursor will select dummy entry from ams_list_entries to
2330: -- send the test mail.
2331: CURSOR c_list_entry IS
2332: SELECT party_id, list_header_id,first_name
2333: FROM ams_list_entries
2334: WHERE party_id IS NOT NULL
2335: AND rownum < 2 ;
2336:
2337: l_list_header_id NUMBER ;