DBA Data[Home] [Help]

APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on BIS_CORRECTIVE_ACTION_PVT

Line 1: PACKAGE BODY BIS_CORRECTIVE_ACTION_PVT AS

1: PACKAGE BODY BIS_CORRECTIVE_ACTION_PVT AS
2: /* $Header: BISVCACB.pls 120.0 2005/06/01 14:57:15 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |

Line 77: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_CORRECTIVE_ACTION_PVT';

73: REM | 27-Oct-2004 ankgoel Modified for bug#3651600 |
74: REM +=======================================================================+
75: */
76:
77: G_PKG_NAME CONSTANT VARCHAR2(30):= 'BIS_CORRECTIVE_ACTION_PVT';
78: G_BREAK CONSTANT VARCHAR2(200) := '
';
79: G_RPT_ERROR CONSTANT VARCHAR2(200) := 'DEFAULT URL';
80: G_NOTIFICATION_JSP_PAGE CONSTANT VARCHAR2(200) := 'bisalrbk.jsp';
81:

Line 1225: || 'bis_corrective_action_pvt.unsub_launch_jsp'

1221: , x_return_status => l_return_status
1222: );
1223:
1224: l_unscubscribe_url := FND_WEB_CONFIG.PLSQL_AGENT
1225: || 'bis_corrective_action_pvt.unsub_launch_jsp'
1226: || '?'
1227: || 'pMeasureId=' || l_param_set_rec.PERFORMANCE_MEASURE_ID
1228: || '&' || 'pTargetLevelId=' || l_param_set_rec.TARGET_LEVEL_ID
1229: || '&' || 'pTargetId=' || l_target_rec.target_id

Line 1285: , avalue => 'PLSQLCLOB:BIS_CORRECTIVE_ACTION_PVT.GenerateAlerts/'||l_item_type || ':' || l_wf_item_key);

1281: wf_engine.SetItemAttrText
1282: ( itemtype => l_item_type
1283: , itemkey => l_wf_item_key
1284: , aname => 'BIS_ALERT_DOC'
1285: , avalue => 'PLSQLCLOB:BIS_CORRECTIVE_ACTION_PVT.GenerateAlerts/'||l_item_type || ':' || l_wf_item_key);
1286:
1287: wf_engine.StartProcess
1288: ( itemtype => l_item_type
1289: , itemkey => l_wf_item_key

Line 1309: ( 'BIS_CORRECTIVE_ACTION_PVT'

1305: EXCEPTION
1306: when FND_API.G_EXC_ERROR then
1307: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Send_Alert: '||sqlerrm);
1308: wf_core.context
1309: ( 'BIS_CORRECTIVE_ACTION_PVT'
1310: , 'Send_Alert'
1311: , l_item_type
1312: , l_wf_item_key
1313: );

Line 1318: ( 'BIS_CORRECTIVE_ACTION_PVT'

1314: RETURN;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Send_Alert: '||sqlerrm);
1317: wf_core.context
1318: ( 'BIS_CORRECTIVE_ACTION_PVT'
1319: , 'Send_Alert'
1320: , l_item_type
1321: , l_wf_item_key
1322: );

Line 1327: ( 'BIS_CORRECTIVE_ACTION_PVT'

1323: RETURN;
1324: when others then
1325: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Send_Alert: '||sqlerrm);
1326: wf_core.context
1327: ( 'BIS_CORRECTIVE_ACTION_PVT'
1328: , 'Send_Alert'
1329: , l_item_type
1330: , l_wf_item_key
1331: );

Line 3111: END BIS_CORRECTIVE_ACTION_PVT;

3107: RETURN l_client_date;
3108:
3109: END Adjust_Datetime;
3110:
3111: END BIS_CORRECTIVE_ACTION_PVT;