eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ITEM_RESIDUALS_PVT dependencies on OKL_API

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

20:
21:
22: -- Global Constants
23: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ITEM_RESIDUALS_PVT';
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
26: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
27: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
28: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';

Line 29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

25: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
26: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
27: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
28: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
30:
31: G_CAT_ITEM CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_ITEM;
32: G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_ITEM_CAT;
33: G_CAT_RES_CAT CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_RES_CAT;

Line 44: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

40: G_STS_SUBMITTED CONSTANT VARCHAR2(30) := 'SUBMITTED';
41:
42: PROCEDURE get_effective_date(
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_item_resdl_ver_id IN NUMBER

Line 53: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

49: , x_calc_date OUT NOCOPY DATE
50: );
51: PROCEDURE create_irs (
52: p_api_version IN NUMBER
53: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
54: , x_return_status OUT NOCOPY VARCHAR2
55: , x_msg_count OUT NOCOPY NUMBER
56: , x_msg_data OUT NOCOPY VARCHAR2
57: , p_irhv_rec IN okl_irhv_rec

Line 66: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

62: );
63:
64: PROCEDURE update_version_irs (
65: p_api_version IN NUMBER
66: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
67: , x_return_status OUT NOCOPY VARCHAR2
68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , p_irhv_rec IN okl_irhv_rec

Line 78: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

74: , x_icpv_rec OUT NOCOPY okl_icpv_rec
75: );
76: procedure create_version_irs (
77: p_api_version IN NUMBER
78: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
79: , x_return_status OUT NOCOPY VARCHAR2
80: , x_msg_count OUT NOCOPY NUMBER
81: , x_msg_data OUT NOCOPY VARCHAR2
82: , p_irhv_rec IN okl_irhv_rec

Line 91: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

87: );
88:
89: PROCEDURE change_LRS_sts (
90: p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
92: , x_return_status OUT NOCOPY VARCHAR2
93: , x_msg_count OUT NOCOPY NUMBER
94: , x_msg_data OUT NOCOPY VARCHAR2
95: , p_confirm_yn IN VARCHAR2

Line 102: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

98: , x_change_sts OUT NOCOPY VARCHAR2
99: );
100: PROCEDURE activate_item_residual(
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
103: , x_return_status OUT NOCOPY VARCHAR2
104: , x_msg_count OUT NOCOPY NUMBER
105: , x_msg_data OUT NOCOPY VARCHAR2
106: , p_item_resdl_version_id IN NUMBER

Line 111: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

107: );
108:
109: PROCEDURE remove_terms(
110: p_api_version IN NUMBER
111: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
112: , x_return_status OUT NOCOPY VARCHAR2
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p_irv_tbl IN okl_irv_tbl);

Line 118: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p_irv_tbl IN okl_irv_tbl);
116: PROCEDURE create_irs_submit (
117: p_api_version IN NUMBER
118: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
119: , x_return_status OUT NOCOPY VARCHAR2
120: , x_msg_count OUT NOCOPY NUMBER
121: , x_msg_data OUT NOCOPY VARCHAR2
122: , p_irhv_rec IN okl_irhv_rec

Line 130: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

126: , x_icpv_rec OUT NOCOPY okl_icpv_rec
127: );
128: PROCEDURE update_version_irs_submit (
129: p_api_version IN NUMBER
130: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
131: , x_return_status OUT NOCOPY VARCHAR2
132: , x_msg_count OUT NOCOPY NUMBER
133: , x_msg_data OUT NOCOPY VARCHAR2
134: , p_irhv_rec IN okl_irhv_rec

Line 142: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

138: , x_icpv_rec OUT NOCOPY okl_icpv_rec
139: );
140: PROCEDURE create_version_irs_submit (
141: p_api_version IN NUMBER
142: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
143: , x_return_status OUT NOCOPY VARCHAR2
144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p_irhv_rec IN okl_irhv_rec

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

150: , x_icpv_rec OUT NOCOPY okl_icpv_rec
151: );
152: PROCEDURE submit_item_residual(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_itm_rsdl_version_id IN OKL_ITM_CAT_RV_PRCS_V.ID%TYPE