[Home] [Help]
475: PROCEDURE Getcampaigncode IS
476:
477: CURSOR c_campaignId(x_inbound_phone VARCHAR2) IS
478: SELECT SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE
479: FROM aMS_SOURCE_CODES SOC, AMS_ACT_CONTACT_POINTS AACP
480: WHERE SOC.SOURCE_CODE_FOR_ID = AACP.ACT_CONTACT_USED_BY_ID AND
481: SOC.ARC_SOURCE_CODE_FOR = AACP.ARC_CONTACT_USED_BY AND
482: SOC.ACTIVE_FLAG = 'Y' AND AACP.CONTACT_POINT_TYPE = 'PHONE'
483: AND AACP.CONTACT_POINT_VALUE = x_inbound_phone;
483: AND AACP.CONTACT_POINT_VALUE = x_inbound_phone;
484:
485: CURSOR c_campaigncode(x_campaigncode VARCHAR2) IS
486: SELECT source_code_id
487: FROM ams_source_codes
488: WHERE source_code = x_campaignCode
489: AND active_flag = 'Y';
490: lx_CampaignCode varchar2(100);
491: lx_sourcecodeID number;
601: PROCEDURE getDtlsFromMPin IS
602:
603: CURSOR C_getDtlsFromMPin(x_MPin number ) IS
604: SELECT s.source_code, s.source_code_id, nvl(l.party_id,0)
605: FROM ams_list_entries l, ams_source_codes s
606: where l.pin_code = x_MPin
607: and l.source_code = s.source_code;
608: BEGIN
609:
1326: p_msg_param OUT NOCOPY varchar2,
1327: p_dialog_style OUT NOCOPY NUMBER,
1328: p_msg_appl_short_name OUT NOCOPY varchar2) is
1329: cursor c_source_code_id(p_schedule_id number, p_source_code varchar2) is
1330: select source_code_id from ams_source_codes where
1331: --source_code_for_id = p_schedule_id and /* Commented for bug#4453994 */
1332: --arc_source_code_for = 'CSCH' and /* Commented for bug#4453994 */
1333: source_code = p_source_code;
1334:
1332: --arc_source_code_for = 'CSCH' and /* Commented for bug#4453994 */
1333: source_code = p_source_code;
1334:
1335: cursor c2_source_code_id(p_source_code varchar2) is
1336: select source_code_id from ams_source_codes where
1337: source_code = p_source_code;
1338: BEGIN
1339:
1340: logmessage('Responsibility Application id ' || fnd_profile.value('RESP_APPL_ID')) ;