APPS.MSC_SCH_WB dependencies on FND_PROFILE

Line 5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

1: PACKAGE BODY msc_sch_wb AS
2: /* $Header: MSCOSCWB.pls 120.6.12010000.2 2009/03/26 07:41:13 sbnaik ship $ */
3:
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
6:
7: PROCEDURE GET_ATP_RESULT (
8: x_session_id IN number,
9: commit_flag IN NUMBER,

Line 879: x_assignment_set_id := fnd_profile.value('MRP_ATP_ASSIGN_SET');

875:
876:
877: IF x_inst = order_sch_wb.apps THEN
878:
879: x_assignment_set_id := fnd_profile.value('MRP_ATP_ASSIGN_SET');
880:
881: if x_assignment_set_id is null then
882:
883: get_profile('MSC_ATP_ASSIGN_SET', x_assignment_set_id);

Line 951: x_assignment_set_id := fnd_profile.value('MSC_ATP_ASSIGN_SET');

947:
948: ELSE
949: -- Server.
950:
951: x_assignment_set_id := fnd_profile.value('MSC_ATP_ASSIGN_SET');
952: IF PG_DEBUG in ('Y', 'C') THEN
953: atp_debug('get_assignment_set: ' || ' server x_assignment_set_id = '||x_assignment_set_id);
954: END IF;
955: IF x_assignment_set_id IS NULL THEN

Line 1660: order_sch_wb.mr_debug := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');

1656:
1657: PROCEDURE set_session_id(p_session_id IN NUMBER)
1658: IS
1659: BEGIN
1660: order_sch_wb.mr_debug := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');
1661: order_sch_wb.debug_session_id := p_session_id;
1662: MSC_ATP_PVT.G_SESSION_ID := p_session_id;
1663:
1664: END set_session_id;

Line 1722: sqlstmt VARCHAR2(255) := 'begin :profile_value := fnd_profile.value';

1718:
1719: PROCEDURE get_profile(profile_name VARCHAR2, profile_value OUT NoCopy NUMBER)
1720: IS
1721: l_atp_link VARCHAR2(255);
1722: sqlstmt VARCHAR2(255) := 'begin :profile_value := fnd_profile.value';
1723: -- atp_cursor integer;
1724: -- atp_rows_processed number;
1725: l_cursor integer;
1726: rows_processed number;

Line 1733: -- l_atp_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');

1729: l_return_status varchar2(60);
1730: l_instance_id number;
1731: BEGIN
1732:
1733: -- l_atp_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
1734: MSC_SATP_FUNC.get_dblink_profile(l_atp_link, l_instance_id, l_return_status);
1735: IF PG_DEBUG in ('Y', 'C') THEN
1736: msc_sch_wb.atp_debug(' get_profile '||l_atp_link);
1737: END IF;