PACKAGE BODY: APPS.FLM_EKB_CUSTOM_HEALTH

Source

1 package body flm_ekb_custom_health as
2 /* $Header: FLMKBCHB.pls 120.1.12020000.1 2012/07/13 11:50:05 sisankar noship $ * */
3 
4 
5   G_PKG_NAME                          CONSTANT VARCHAR2(30) := 'FLM_EKB_CUSTOM_HEALTH';
6   G_REQUEST_ID                        NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7   G_PROGAM_APPLICATION_ID             NUMBER := FND_GLOBAL.PROG_APPL_ID;
8   G_PROGAM_ID                         NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9   G_USER_NAME                         FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10   G_USER_ID                           NUMBER := FND_GLOBAL.USER_ID;
11   G_LOGIN_ID                          NUMBER := FND_GLOBAL.LOGIN_ID;
12   G_CURRENT_USER_ID                   NUMBER;
13   G_CURRENT_LOGIN_ID                  NUMBER;
14   G_ADD_ERRORS_TO_FND_STACK           VARCHAR2(1);
15   G_APPLICATION_CONTEXT               VARCHAR2(30);
16   G_DATE_FORMAT                       CONSTANT VARCHAR2(30) := 'SYYYY-MM-DD HH24:MI:SS';
17 
18 
19 procedure health_for_ps(
20 p_pull_sequence_id 		IN 		NUMBER
21 ,x_return_status 		OUT NOCOPY	VARCHAR2
22 ,x_error_code 			OUT NOCOPY	VARCHAR2
23 ,x_good_health 			OUT NOCOPY	NUMBER
24 ,x_bad_health 			OUT NOCOPY	NUMBER
25 ) is
26 
27 
28 Begin
29 
30 
31  -- dbms_output.put_line('Pull Sequence id :  '||p_pull_sequence_id);
32  -- dbms_output.put_line('Good Health is :  '||x_good_health);
33  -- dbms_output.put_line('Bad Health is :  '||x_bad_health);
34 null;
35 
36 end;
37 
38 
39 End flm_ekb_custom_health;