APPS.MSC_ASK_ORACLE dependencies on MSC_ASK_ORACLE

Line 1: PACKAGE BODY msc_ask_oracle AS

1: PACKAGE BODY msc_ask_oracle AS
2: /*$Header: MSCASKOB.pls 120.1 2005/06/17 13:13:39 appldev $ */
3:
4: -- This procedure is called from the concurrent program to register the
5: -- questions for Ask Oracle via SRS

Line 213: errbuf := 'MSC_ASK_ORACLE.register_question:' || to_char(sqlcode) || ':'

209: return;
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: errbuf := 'MSC_ASK_ORACLE.register_question:' || to_char(sqlcode) || ':'
214: || substr(sqlerrm,1,60);
215: retcode := 2;
216: END register_question;
217:

Line 257: SELECT NVL(package_name,'MSC_ASK_ORACLE'), question_code

253: v_key2 := x_key2;
254:
255: -- Call the appropriate procedure to process this questions
256: x_stmt_num := 30;
257: SELECT NVL(package_name,'MSC_ASK_ORACLE'), question_code
258: INTO x_pkg_name, x_question_code
259: FROM msc_questions_b
260: WHERE question_id = x_question_id;
261:

Line 282: x_err_msg := 'MSC_ASK_ORACLE.ASK:' || to_char(x_stmt_num) || ':' ||

278: END IF;
279:
280: EXCEPTION
281: WHEN OTHERS THEN
282: x_err_msg := 'MSC_ASK_ORACLE.ASK:' || to_char(x_stmt_num) || ':' ||
283: to_char(sqlcode) || ':' || substr(sqlerrm,1,60);
284: return(FALSE);
285: END ask;
286:

Line 595: MSC_ASK_ORACLE.LATE_SUPPLY(

591: END IF ;
592: -- Now that we have the late supply, find out why that is late
593: -- Set the package variable key appropriately
594: v_key1 := l_supply_id;
595: MSC_ASK_ORACLE.LATE_SUPPLY(
596: x_answer_id => l_ansid,
597: x_err_msg => l_err_msg,
598: x_msg_count => l_msg_count);
599: x_answer_id := l_ansid;

Line 610: END msc_ask_oracle;

606: WHEN OTHERS THEN
607: raise;
608: END late_demand;
609:
610: END msc_ask_oracle;