APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_LOOKUPS

Line 298: fnd_file.put_line(fnd_file.log,'Calling CS_TP_LOOKUPS_PKG.UPDATE_ROW API, SR Type: '

294: x_msg_data => x_msg_data,
295: x_return_status => x_return_status
296: );
297:
298: fnd_file.put_line(fnd_file.log,'Calling CS_TP_LOOKUPS_PKG.UPDATE_ROW API, SR Type: '
299: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
300:
301: CS_TP_LOOKUPS_PKG.UPDATE_ROW
302: (

Line 301: CS_TP_LOOKUPS_PKG.UPDATE_ROW

297:
298: fnd_file.put_line(fnd_file.log,'Calling CS_TP_LOOKUPS_PKG.UPDATE_ROW API, SR Type: '
299: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
300:
301: CS_TP_LOOKUPS_PKG.UPDATE_ROW
302: (
303: X_ROWID => l_rowid,
304: X_LOOKUP_ID => l_template_question_list.mlookupid,
305: X_LOOKUP_TYPE => l_template_question_list.manswertype,

Line 342: , cs_tp_lookups l

338:
339: /* get the template question lookupid */
340: select l.lookup_id into l_tmpl_quest_lookup_id
341: from cs_tp_questions_vl q
342: , cs_tp_lookups l
343: , cs_tp_template_questions tq
344: where q.lookup_id = l.lookup_id
345: and tq.question_id = q.question_id
346: and tq.template_id = l_tmpl_id

Line 584: , cs_tp_lookups ch

580: , qvl.text text
581: , qvl.lookup_id lookup_id
582: , ch.lookup_type choice_id
583: from cs_tp_questions_vl qvl
584: , cs_tp_lookups ch
585: , cs_tp_template_questions tmpl_qa
586: , cs_tp_templates_vl tmpl
587: where qvl.lookup_id = ch.lookup_id
588: and ch.lookup_type = 'CHOICE'