DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PVT dependencies on OKL_API

Line 12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

8: G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPFMACONSTRAINTS_PVT';

Line 13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPFMACONSTRAINTS_PVT';
17:

Line 15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPFMACONSTRAINTS_PVT';
17:
18: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
19:

Line 34: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

30: x_fodv_rec OUT NOCOPY fodv_rec_type);
31:
32: PROCEDURE insert_fmaconstraints(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_fmav_rec IN fmav_rec_type,

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

40: x_fodv_rec OUT NOCOPY fodv_rec_type);
41:
42: PROCEDURE update_fmaconstraints(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_fmav_rec IN fmav_rec_type,

Line 54: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

50: x_fodv_rec OUT NOCOPY fodv_rec_type);
51:
52: PROCEDURE delete_fmaconstraints(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_fodv_tbl IN fodv_tbl_type);

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

59:
60: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FMLA_OPRNDS - TBL : begin
61: PROCEDURE insert_fmaconstraints(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_fmav_rec IN fmav_rec_type,

Line 75: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

71:
72: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FMLA_OPRNDS - TBL : begin
73: PROCEDURE update_fmaconstraints(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_fmav_rec IN fmav_rec_type,