DBA Data[Home] [Help]

APPS.OKS_ARFETCH_PUB dependencies on OKS_ARFETCH_PUB

Line 1: Package Body OKS_ARFETCH_PUB AS

1: Package Body OKS_ARFETCH_PUB AS
2: /* $Header: OKSPARGB.pls 120.2.12010000.2 2008/10/22 12:50:11 ssreekum ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_ARFETCH_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_ARFETCH_PUB';

1: Package Body OKS_ARFETCH_PUB AS
2: /* $Header: OKSPARGB.pls 120.2.12010000.2 2008/10/22 12:50:11 ssreekum ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_ARFETCH_PUB';
6:
7: -- Global var holding the Current Error code for the error encountered
8: Current_Error_Code Varchar2(20) := NULL;
9:

Line 44: OKS_ARFETCH_PUB.GET_AR_RECORD(l_return_status);

40:
41: user_id := FND_GLOBAL.USER_ID;
42: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(user_id));
43:
44: OKS_ARFETCH_PUB.GET_AR_RECORD(l_return_status);
45: --OKS_ARFETCH_PUB.GET_AR_RECORD(l_retcode);
46:
47: --l_retcode := SUCCESS;
48:

Line 45: --OKS_ARFETCH_PUB.GET_AR_RECORD(l_retcode);

41: user_id := FND_GLOBAL.USER_ID;
42: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(user_id));
43:
44: OKS_ARFETCH_PUB.GET_AR_RECORD(l_return_status);
45: --OKS_ARFETCH_PUB.GET_AR_RECORD(l_retcode);
46:
47: --l_retcode := SUCCESS;
48:
49: IF (l_return_status = 'S') THEN

Line 441: END OKS_ARFETCH_PUB;

437: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
438: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error'||SQLCODE || '- '||SQLERRM);
439: END Get_AR_RECORD;
440:
441: END OKS_ARFETCH_PUB;