APPS.AMS_LIST_MAINT_PVT dependencies on AMS_LIST_ENTRIES

Line 497: ||' ale.ENABLED_FLAG,ale.CELL_CODE,ale.CAMPAIGN_ID,ale.MEDIA_ID,ale.CHANNEL_ID,ale.CHANNEL_SCHEDULE_ID,ale.EVENT_OFFER_ID,ale.LAST_UPDATE_DATE,ale.LAST_UPDATED_BY,ale.CREATION_DATE,ale.CREATED_BY FROM ams_list_entries ale '

493: l_sql_str := l_sql_str
494: ||' ale.LIST_ENTRY_ID,ale.LIST_HEADER_ID,ale.OBJECT_VERSION_NUMBER,ale.LIST_SELECT_ACTION_ID,ale.ARC_LIST_SELECT_ACTION_FROM,ale.LIST_SELECT_ACTION_FROM_NAME,'
495: ||' ale.SOURCE_CODE,ale.ARC_LIST_USED_BY_SOURCE,ale.PIN_CODE,ale.LIST_ENTRY_SOURCE_SYSTEM_ID,ale.LIST_ENTRY_SOURCE_SYSTEM_TYPE,'
496: ||'ale.VIEW_APPLICATION_ID,ale.MANUALLY_ENTERED_FLAG,ale.MARKED_AS_DUPLICATE_FLAG,ale.MARKED_AS_RANDOM_FLAG,ale.PART_OF_CONTROL_GROUP_FLAG,'
497: ||' ale.ENABLED_FLAG,ale.CELL_CODE,ale.CAMPAIGN_ID,ale.MEDIA_ID,ale.CHANNEL_ID,ale.CHANNEL_SCHEDULE_ID,ale.EVENT_OFFER_ID,ale.LAST_UPDATE_DATE,ale.LAST_UPDATED_BY,ale.CREATION_DATE,ale.CREATED_BY FROM ams_list_entries ale '
498: ||' WHERE ale.LIST_ENTRY_SOURCE_SYSTEM_TYPE ='||''''||P_SOURCE_TYPE_CODE||'''';
499:
500: elsif(p_list_source_type = 'IMPORT')then
501:

Line 1194: -- x_listentry_rec: the record representing AMS_LIST_ENTRIES.

1190: -- PURPOSE
1191: -- Gets customer record for a given pincode.
1192: --
1193: -- PARAMETERS
1194: -- x_listentry_rec: the record representing AMS_LIST_ENTRIES.
1195: -- p_pincode: the pincode.
1196: --
1197: -- NOTES
1198: -- 1. since pincode is unique only one record will be returned.

Line 1233: From ams_list_entries

1229: FIRST_NAME,LAST_NAME,
1230: CUSTOMER_NAME,TITLE,
1231: ADDRESS_LINE1,ADDRESS_LINE2,
1232: CITY,STATE,ZIPCODE,COUNTRY,FAX,PHONE,EMAIL_ADDRESS
1233: From ams_list_entries
1234: Where ams_list_entries.pin_code = p_pincode;
1235:
1236: BEGIN
1237: --------------------- initialize -----------------------

Line 1234: Where ams_list_entries.pin_code = p_pincode;

1230: CUSTOMER_NAME,TITLE,
1231: ADDRESS_LINE1,ADDRESS_LINE2,
1232: CITY,STATE,ZIPCODE,COUNTRY,FAX,PHONE,EMAIL_ADDRESS
1233: From ams_list_entries
1234: Where ams_list_entries.pin_code = p_pincode;
1235:
1236: BEGIN
1237: --------------------- initialize -----------------------
1238: SAVEPOINT Get_PinCodeData_Rec;