DBA Data[Home] [Help]

APPS.OKL_AM_CONTRACT_PRTFL_PVT dependencies on OKC_API

Line 6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

2: /* $Header: OKLRPTFS.pls 115.3 2002/12/31 01:18:59 sechawla noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: ---------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

3: ---------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: ---------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

4: -- GLOBAL MESSAGE CONSTANTS
5: ---------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';

Line 9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

5: ---------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';

Line 10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

6: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

7: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 21: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

17: ---------------------------------------------------------------------------
18: -- GLOBAL VARIABLES
19: ---------------------------------------------------------------------------
20: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_PRTFL_PVT';
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22:
23: ---------------------------------------------------------------------------
24: -- GLOBAL EXCEPTIONS
25: ---------------------------------------------------------------------------

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

33:
34:
35: PROCEDURE create_cntrct_prtfl(
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_contract_id IN NUMBER);

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

45: -- wrapper for executing update_cntrct_prtfl procedure as a concurrent program
46: PROCEDURE batch_upd_cntrct_prtfl( ERRBUF OUT NOCOPY VARCHAR2,
47: RETCODE OUT NOCOPY VARCHAR2 ,
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50: p_contract_id IN NUMBER DEFAULT NULL
51: ) ;
52:
53: PROCEDURE update_cntrct_prtfl(

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

51: ) ;
52:
53: PROCEDURE update_cntrct_prtfl(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_contract_id IN NUMBER DEFAULT NULL,

Line 68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

64: -- wrapper for executing execute_cntrct_prtfl procedure as a concurrent program
65: PROCEDURE batch_exe_cntrct_prtfl( ERRBUF OUT NOCOPY VARCHAR2,
66: RETCODE OUT NOCOPY VARCHAR2 ,
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
69: ) ;
70:
71: PROCEDURE execute_cntrct_prtfl(
72: p_api_version IN NUMBER,

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69: ) ;
70:
71: PROCEDURE execute_cntrct_prtfl(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: x_total_count OUT NOCOPY NUMBER,