APPS.MSC_ATP_UTILITY dependencies on MSC_ATP_UTILITY

Line 1: PACKAGE BODY MSC_ATP_UTILITY AS

1: PACKAGE BODY MSC_ATP_UTILITY AS
2: /* $Header: MSCASDUB.pls 120.1 2007/12/12 10:19:22 sbnaik ship $ */
3:
4: PROCEDURE Close_DbLink(p_DbLink varchar2) IS
5: lv_sql_stmt VARCHAR2(2000);

Line 61: 'BEGIN MSC_ATP_UTILITY.Derive_Profile_Values_Frm_Dest'||p_DbLink||' (:p_sqlerrm, :l_Profile_Values, :l_Profile_Names, :l_Delimiter); END;';

57: BEGIN
58: p_SqlErrM := NULL;
59:
60: l_SqlStmt :=
61: 'BEGIN MSC_ATP_UTILITY.Derive_Profile_Values_Frm_Dest'||p_DbLink||' (:p_sqlerrm, :l_Profile_Values, :l_Profile_Names, :l_Delimiter); END;';
62:
63: EXECUTE IMMEDIATE l_SqlStmt
64: USING out p_SqlErrM, out p_Profile_Values, p_Profile_Names, p_Delimiter;
65:

Line 73: END MSC_ATP_UTILITY;

69: p_SqlErrM := sqlerrm||' (Problem at source)';
70: Close_DbLink(p_DbLink);
71: END Derive_Profile_Values_Frm_Sour;
72:
73: END MSC_ATP_UTILITY;