DBA Data[Home] [Help]

APPS.OKL_SUPP_INVOICE_DTLS_PUB dependencies on OKC_API

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

5: subtype sidv_tbl_type is okl_supp_invoice_dtls_pvt.sidv_tbl_type;
6:
7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

6:
7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

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

7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

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

8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16:

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

15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16:
17: -- Global variables for user hooks
18: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUPP_INVOICE_DTLS_PUB';
19: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20: g_sidv_rec sidv_rec_type;
21: g_sidv_tbl sidv_tbl_type;
22:
23:

Line 26: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

22:
23:
24: PROCEDURE create_sup_inv_dtls(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_sidv_rec IN sidv_rec_type,

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

31: x_sidv_rec OUT NOCOPY sidv_rec_type);
32:
33: PROCEDURE create_sup_inv_dtls(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2,
39: p_sidv_tbl IN sidv_tbl_type,

Line 45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

41:
42:
43: PROCEDURE update_sup_inv_dtls(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_sidv_rec IN sidv_rec_type,

Line 54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

50: x_sidv_rec OUT NOCOPY sidv_rec_type);
51:
52: PROCEDURE update_sup_inv_dtls(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_sidv_tbl IN sidv_tbl_type,

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

59: x_sidv_tbl OUT NOCOPY sidv_tbl_type);
60:
61: PROCEDURE delete_sup_inv_dtls(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_sidv_rec IN sidv_rec_type);

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

67: p_sidv_rec IN sidv_rec_type);
68:
69: PROCEDURE delete_sup_inv_dtls(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_sidv_tbl IN sidv_tbl_type);

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

75: p_sidv_tbl IN sidv_tbl_type);
76:
77: PROCEDURE lock_sup_inv_dtls(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_sidv_rec IN sidv_rec_type);

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: p_sidv_rec IN sidv_rec_type);
84:
85: procedure lock_sup_inv_dtls(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_sidv_tbl IN sidv_tbl_type);

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: p_sidv_tbl IN sidv_tbl_type);
92:
93: PROCEDURE validate_sup_inv_dtls(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_sidv_rec IN sidv_rec_type);

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: p_sidv_rec IN sidv_rec_type);
100:
101: procedure validate_sup_inv_dtls(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_sidv_tbl IN sidv_tbl_type);