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.OKS_EXTWARPRGM_OSO_PVT dependencies on OKC_RULE_PUB

Line 262: p_rgpv_tbl IN okc_rule_pub.rgpv_tbl_type

258:
259:
260: Procedure Create_Rule_Group
261: (
262: p_rgpv_tbl IN okc_rule_pub.rgpv_tbl_type
263: ,x_rgpv_tbl OUT NOCOPY okc_rule_pub.rgpv_tbl_type
264: ,x_return_status OUT NOCOPY Varchar2
265: ,x_msg_count OUT NOCOPY Number
266: ,x_msg_data OUT NOCOPY Varchar2

Line 263: ,x_rgpv_tbl OUT NOCOPY okc_rule_pub.rgpv_tbl_type

259:
260: Procedure Create_Rule_Group
261: (
262: p_rgpv_tbl IN okc_rule_pub.rgpv_tbl_type
263: ,x_rgpv_tbl OUT NOCOPY okc_rule_pub.rgpv_tbl_type
264: ,x_return_status OUT NOCOPY Varchar2
265: ,x_msg_count OUT NOCOPY Number
266: ,x_msg_data OUT NOCOPY Varchar2
267: )

Line 269: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;

265: ,x_msg_count OUT NOCOPY Number
266: ,x_msg_data OUT NOCOPY Varchar2
267: )
268: Is
269: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
270: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
271:
272: l_api_version CONSTANT NUMBER := 1.0;
273: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';

Line 270: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;

266: ,x_msg_data OUT NOCOPY Varchar2
267: )
268: Is
269: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
270: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
271:
272: l_api_version CONSTANT NUMBER := 1.0;
273: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';
274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 283: okc_rule_pub.create_rule_group

279: x_return_status := l_return_status;
280:
281: l_rgpv_tbl_in := p_rgpv_tbl;
282:
283: okc_rule_pub.create_rule_group
284: (
285: p_api_version => l_api_version,
286: p_init_msg_list => l_init_msg_list,
287: x_return_status => l_return_status,

Line 341: p_rulv_tbl IN okc_rule_pub.rulv_tbl_type

337:
338:
339: Procedure create_rules
340: (
341: p_rulv_tbl IN okc_rule_pub.rulv_tbl_type
342: ,x_rulv_tbl OUT NOCOPY okc_rule_pub.rulv_tbl_type
343: ,x_return_status OUT NOCOPY Varchar2
344: ,x_msg_count OUT NOCOPY Number
345: ,x_msg_data OUT NOCOPY Varchar2

Line 342: ,x_rulv_tbl OUT NOCOPY okc_rule_pub.rulv_tbl_type

338:
339: Procedure create_rules
340: (
341: p_rulv_tbl IN okc_rule_pub.rulv_tbl_type
342: ,x_rulv_tbl OUT NOCOPY okc_rule_pub.rulv_tbl_type
343: ,x_return_status OUT NOCOPY Varchar2
344: ,x_msg_count OUT NOCOPY Number
345: ,x_msg_data OUT NOCOPY Varchar2
346: )

Line 348: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

344: ,x_msg_count OUT NOCOPY Number
345: ,x_msg_data OUT NOCOPY Varchar2
346: )
347: Is
348: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
349: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
350:
351: l_api_version CONSTANT NUMBER := 1.0;
352: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';

Line 349: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

345: ,x_msg_data OUT NOCOPY Varchar2
346: )
347: Is
348: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
349: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
350:
351: l_api_version CONSTANT NUMBER := 1.0;
352: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';
353: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 364: okc_rule_pub.create_rule

360: x_return_status := l_return_status;
361:
362: l_rulv_tbl_in := p_rulv_tbl;
363:
364: okc_rule_pub.create_rule
365: (
366: p_api_version => l_api_version,
367: p_init_msg_list => l_init_msg_list,
368: x_return_status => l_return_status,

Line 462: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

458: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
459: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
460:
461: --Rule Related
462: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
463: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
464:
465:
466: l_cleid NUMBER;

Line 463: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

459: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
460:
461: --Rule Related
462: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
463: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
464:
465:
466: l_cleid NUMBER;
467: l_rgp_id NUMBER;

Line 520: okc_rule_pub.update_rule

516: l_rulv_tbl_in(1).id := l_rule_id;
517: l_rulv_tbl_in(1).rule_information4 := to_char(p_new_sdt,'YYYY/MM/DD HH24:MI:SS');
518: l_rulv_tbl_in(1).rule_information3 := to_char(p_new_edt,'YYYY/MM/DD HH24:MI:SS');
519:
520: okc_rule_pub.update_rule
521: (
522: p_api_version => l_api_version,
523: p_init_msg_list => l_init_msg_list,
524: x_return_status => l_return_status,

Line 721: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

717: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
718: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
719:
720: --Rule Related
721: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
722: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
723:
724:
725: --Time Value Related

Line 722: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

718: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
719:
720: --Rule Related
721: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
722: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
723:
724:
725: --Time Value Related
726: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;

Line 782: okc_rule_pub.update_rule

778: l_rulv_tbl_in(1).id := l_rule_id;
779: l_rulv_tbl_in(1).rule_information4 := to_char(p_new_sdt,'YYYY/MM/DD HH24:MI:SS');
780: l_rulv_tbl_in(1).rule_information3 := to_char(p_new_edt,'YYYY/MM/DD HH24:MI:SS');
781:
782: okc_rule_pub.update_rule
783: (
784: p_api_version => l_api_version,
785: p_init_msg_list => l_init_msg_list,
786: x_return_status => l_return_status,

Line 814: Procedure Clear_Rule_Table (X_rulv_tbl OUT NOCOPY okc_rule_pub.rulv_tbl_type)

810: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
811: End;
812:
813:
814: Procedure Clear_Rule_Table (X_rulv_tbl OUT NOCOPY okc_rule_pub.rulv_tbl_type)
815: Is
816: Begin
817:
818: x_rulv_tbl(1).id := OKC_API.G_MISS_NUM;

Line 1172: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;

1168: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;
1169:
1170: --Rule Related
1171:
1172: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
1173: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
1174:
1175: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1176: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

Line 1173: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;

1169:
1170: --Rule Related
1171:
1172: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
1173: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
1174:
1175: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1176: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1177:

Line 1175: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

1171:
1172: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
1173: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
1174:
1175: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1176: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1177:
1178: --Time Value Related
1179: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;

Line 1176: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

1172: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
1173: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
1174:
1175: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1176: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1177:
1178: --Time Value Related
1179: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
1180: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;

Line 2217: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;

2213: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;
2214:
2215: --Rule Related
2216:
2217: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2218: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
2219:
2220: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2221: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

Line 2218: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;

2214:
2215: --Rule Related
2216:
2217: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2218: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
2219:
2220: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2221: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
2222:

Line 2220: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

2216:
2217: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2218: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
2219:
2220: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2221: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
2222:
2223: --Time Value Related
2224: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;

Line 2221: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

2217: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2218: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
2219:
2220: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2221: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
2222:
2223: --Time Value Related
2224: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2225: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;

Line 3139: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;

3135:
3136:
3137: --Rule Related
3138:
3139: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3140: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
3141:
3142: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3143: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

Line 3140: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;

3136:
3137: --Rule Related
3138:
3139: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3140: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
3141:
3142: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3143: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
3144:

Line 3142: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

3138:
3139: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3140: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
3141:
3142: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3143: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
3144:
3145: --Return IDs
3146: l_line_id NUMBER;

Line 3143: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

3139: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
3140: l_rgpv_tbl_out okc_rule_pub.rgpv_tbl_type;
3141:
3142: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
3143: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
3144:
3145: --Return IDs
3146: l_line_id NUMBER;
3147: l_rule_group_id NUMBER;