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_TPL_PVT dependencies on OKC_API

Line 1122: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1118: x_return_status OUT NOCOPY VARCHAR2)
1119:
1120: IS
1121:
1122: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1123:
1124: CURSOR tld_csr (p_tld_id NUMBER)
1125: IS
1126: SELECT ID

Line 1134: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1130: l_tld_id NUMBER := NULL;
1131:
1132: BEGIN
1133:
1134: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1135:
1136: IF (p_tplv_rec.tld_id IS NOT NULL) THEN
1137:
1138: OPEN tld_csr(p_tplv_rec.tld_id);

Line 1144: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

1140: CLOSE tld_csr;
1141:
1142: IF (l_tld_id IS NULL) THEN
1143:
1144: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1145: ,p_msg_name => g_invalid_value
1146: ,p_token1 => g_col_name_token
1147: ,p_token1_value => 'tld_id');
1148: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1148: x_return_status := Okc_Api.G_RET_STS_ERROR;

1144: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1145: ,p_msg_name => g_invalid_value
1146: ,p_token1 => g_col_name_token
1147: ,p_token1_value => 'tld_id');
1148: x_return_status := Okc_Api.G_RET_STS_ERROR;
1149: RAISE G_EXCEPTION_HALT_VALIDATION;
1150: END IF;
1151:
1152: END IF;

Line 1162: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1158: NULL;
1159:
1160: WHEN OTHERS THEN
1161: -- store SQL error message on message stack for caller
1162: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1163: p_msg_name => g_unexpected_error,
1164: p_token1 => g_sqlcode_token,
1165: p_token1_value => SQLCODE,
1166: p_token2 => g_sqlerrm_token,

Line 1169: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1165: p_token1_value => SQLCODE,
1166: p_token2 => g_sqlerrm_token,
1167: p_token2_value => SQLERRM);
1168:
1169: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1170:
1171: END validate_fk_tld_id;
1172: --end:| 14-May-07 cklee -- added TLD_ID column |
1173:

Line 1182: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1178: x_return_status OUT NOCOPY VARCHAR2)
1179:
1180: IS
1181:
1182: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1183:
1184: CURSOR sel_csr (p_sel_id NUMBER)
1185: IS
1186: SELECT ID

Line 1194: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1190: l_sel_id NUMBER := NULL;
1191:
1192: BEGIN
1193:
1194: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1195:
1196: IF (p_tplv_rec.sel_id IS NOT NULL) THEN
1197:
1198: OPEN sel_csr(p_tplv_rec.sel_id);

Line 1204: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

1200: CLOSE sel_csr;
1201:
1202: IF (l_sel_id IS NULL) THEN
1203:
1204: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1205: ,p_msg_name => g_invalid_value
1206: ,p_token1 => g_col_name_token
1207: ,p_token1_value => 'sel_id');
1208: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1208: x_return_status := Okc_Api.G_RET_STS_ERROR;

1204: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1205: ,p_msg_name => g_invalid_value
1206: ,p_token1 => g_col_name_token
1207: ,p_token1_value => 'sel_id');
1208: x_return_status := Okc_Api.G_RET_STS_ERROR;
1209: RAISE G_EXCEPTION_HALT_VALIDATION;
1210: END IF;
1211:
1212: END IF;

Line 1222: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1218: NULL;
1219:
1220: WHEN OTHERS THEN
1221: -- store SQL error message on message stack for caller
1222: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1223: p_msg_name => g_unexpected_error,
1224: p_token1 => g_sqlcode_token,
1225: p_token1_value => SQLCODE,
1226: p_token2 => g_sqlerrm_token,

Line 1229: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1225: p_token1_value => SQLCODE,
1226: p_token2 => g_sqlerrm_token,
1227: p_token2_value => SQLERRM);
1228:
1229: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1230:
1231: END validate_fk_sel_id;
1232:
1233: ---------------------------------------------------------------------------

Line 2253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2249: -- validate_row for:OKL_TXL_AP_INV_LNS_V --
2250: -------------------------------------------
2251: PROCEDURE validate_row(
2252: p_api_version IN NUMBER,
2253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_tplv_rec IN tplv_rec_type) IS

Line 2330: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2326: -- PL/SQL TBL validate_row for:TPLV_TBL --
2327: ------------------------------------------
2328: PROCEDURE validate_row(
2329: p_api_version IN NUMBER,
2330: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2331: x_return_status OUT NOCOPY VARCHAR2,
2332: x_msg_count OUT NOCOPY NUMBER,
2333: x_msg_data OUT NOCOPY VARCHAR2,
2334: p_tplv_tbl IN tplv_tbl_type) IS

Line 2349: p_init_msg_list => OKC_API.G_FALSE,

2345: i := p_tplv_tbl.FIRST;
2346: LOOP
2347: validate_row (
2348: p_api_version => p_api_version,
2349: p_init_msg_list => OKC_API.G_FALSE,
2350: x_return_status => x_return_status,
2351: x_msg_count => x_msg_count,
2352: x_msg_data => x_msg_data,
2353: p_tplv_rec => p_tplv_tbl(i));

Line 2409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2405: -----------------------------------------
2406: -- insert_row for:OKL_TXL_AP_INV_LNS_B --
2407: -----------------------------------------
2408: PROCEDURE insert_row(
2409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2410: x_return_status OUT NOCOPY VARCHAR2,
2411: x_msg_count OUT NOCOPY NUMBER,
2412: x_msg_data OUT NOCOPY VARCHAR2,
2413: p_tpl_rec IN tpl_rec_type,

Line 2600: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2596: ------------------------------------------
2597: -- insert_row for:OKL_TXL_AP_INV_LNS_TL --
2598: ------------------------------------------
2599: PROCEDURE insert_row(
2600: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2601: x_return_status OUT NOCOPY VARCHAR2,
2602: x_msg_count OUT NOCOPY NUMBER,
2603: x_msg_data OUT NOCOPY VARCHAR2,
2604: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

Line 2715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2711: -- insert_row for:OKL_TXL_AP_INV_LNS_V --
2712: -----------------------------------------
2713: PROCEDURE insert_row(
2714: p_api_version IN NUMBER,
2715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2716: x_return_status OUT NOCOPY VARCHAR2,
2717: x_msg_count OUT NOCOPY NUMBER,
2718: x_msg_data OUT NOCOPY VARCHAR2,
2719: p_tplv_rec IN tplv_rec_type,

Line 2892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2888: -- PL/SQL TBL insert_row for:TPLV_TBL --
2889: ----------------------------------------
2890: PROCEDURE insert_row(
2891: p_api_version IN NUMBER,
2892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2893: x_return_status OUT NOCOPY VARCHAR2,
2894: x_msg_count OUT NOCOPY NUMBER,
2895: x_msg_data OUT NOCOPY VARCHAR2,
2896: p_tplv_tbl IN tplv_tbl_type,

Line 2912: p_init_msg_list => OKC_API.G_FALSE,

2908: i := p_tplv_tbl.FIRST;
2909: LOOP
2910: insert_row (
2911: p_api_version => p_api_version,
2912: p_init_msg_list => OKC_API.G_FALSE,
2913: x_return_status => x_return_status,
2914: x_msg_count => x_msg_count,
2915: x_msg_data => x_msg_data,
2916: p_tplv_rec => p_tplv_tbl(i),

Line 2973: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2969: ---------------------------------------
2970: -- lock_row for:OKL_TXL_AP_INV_LNS_B --
2971: ---------------------------------------
2972: PROCEDURE lock_row(
2973: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2974: x_return_status OUT NOCOPY VARCHAR2,
2975: x_msg_count OUT NOCOPY NUMBER,
2976: x_msg_data OUT NOCOPY VARCHAR2,
2977: p_tpl_rec IN tpl_rec_type) IS

Line 3079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3075: ----------------------------------------
3076: -- lock_row for:OKL_TXL_AP_INV_LNS_TL --
3077: ----------------------------------------
3078: PROCEDURE lock_row(
3079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3080: x_return_status OUT NOCOPY VARCHAR2,
3081: x_msg_count OUT NOCOPY NUMBER,
3082: x_msg_data OUT NOCOPY VARCHAR2,
3083: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

Line 3165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3161: -- lock_row for:OKL_TXL_AP_INV_LNS_V --
3162: ---------------------------------------
3163: PROCEDURE lock_row(
3164: p_api_version IN NUMBER,
3165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3166: x_return_status OUT NOCOPY VARCHAR2,
3167: x_msg_count OUT NOCOPY NUMBER,
3168: x_msg_data OUT NOCOPY VARCHAR2,
3169: p_tplv_rec IN tplv_rec_type) IS

Line 3259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3255: -- PL/SQL TBL lock_row for:TPLV_TBL --
3256: --------------------------------------
3257: PROCEDURE lock_row(
3258: p_api_version IN NUMBER,
3259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3260: x_return_status OUT NOCOPY VARCHAR2,
3261: x_msg_count OUT NOCOPY NUMBER,
3262: x_msg_data OUT NOCOPY VARCHAR2,
3263: p_tplv_tbl IN tplv_tbl_type) IS

Line 3278: p_init_msg_list => OKC_API.G_FALSE,

3274: i := p_tplv_tbl.FIRST;
3275: LOOP
3276: lock_row (
3277: p_api_version => p_api_version,
3278: p_init_msg_list => OKC_API.G_FALSE,
3279: x_return_status => x_return_status,
3280: x_msg_count => x_msg_count,
3281: x_msg_data => x_msg_data,
3282: p_tplv_rec => p_tplv_tbl(i));

Line 3338: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3334: -----------------------------------------
3335: -- update_row for:OKL_TXL_AP_INV_LNS_B --
3336: -----------------------------------------
3337: PROCEDURE update_row(
3338: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3339: x_return_status OUT NOCOPY VARCHAR2,
3340: x_msg_count OUT NOCOPY NUMBER,
3341: x_msg_data OUT NOCOPY VARCHAR2,
3342: p_tpl_rec IN tpl_rec_type,

Line 3710: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3706: ------------------------------------------
3707: -- update_row for:OKL_TXL_AP_INV_LNS_TL --
3708: ------------------------------------------
3709: PROCEDURE update_row(
3710: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3711: x_return_status OUT NOCOPY VARCHAR2,
3712: x_msg_count OUT NOCOPY NUMBER,
3713: x_msg_data OUT NOCOPY VARCHAR2,
3714: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type,

Line 3877: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3873: -- update_row for:OKL_TXL_AP_INV_LNS_V --
3874: -----------------------------------------
3875: PROCEDURE update_row(
3876: p_api_version IN NUMBER,
3877: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3878: x_return_status OUT NOCOPY VARCHAR2,
3879: x_msg_count OUT NOCOPY NUMBER,
3880: x_msg_data OUT NOCOPY VARCHAR2,
3881: p_tplv_rec IN tplv_rec_type,

Line 4293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4289: -- PL/SQL TBL update_row for:TPLV_TBL --
4290: ----------------------------------------
4291: PROCEDURE update_row(
4292: p_api_version IN NUMBER,
4293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4294: x_return_status OUT NOCOPY VARCHAR2,
4295: x_msg_count OUT NOCOPY NUMBER,
4296: x_msg_data OUT NOCOPY VARCHAR2,
4297: p_tplv_tbl IN tplv_tbl_type,

Line 4313: p_init_msg_list => OKC_API.G_FALSE,

4309: i := p_tplv_tbl.FIRST;
4310: LOOP
4311: update_row (
4312: p_api_version => p_api_version,
4313: p_init_msg_list => OKC_API.G_FALSE,
4314: x_return_status => x_return_status,
4315: x_msg_count => x_msg_count,
4316: x_msg_data => x_msg_data,
4317: p_tplv_rec => p_tplv_tbl(i),

Line 4374: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4370: -----------------------------------------
4371: -- delete_row for:OKL_TXL_AP_INV_LNS_B --
4372: -----------------------------------------
4373: PROCEDURE delete_row(
4374: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4375: x_return_status OUT NOCOPY VARCHAR2,
4376: x_msg_count OUT NOCOPY NUMBER,
4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: p_tpl_rec IN tpl_rec_type) IS

Line 4435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4431: ------------------------------------------
4432: -- delete_row for:OKL_TXL_AP_INV_LNS_TL --
4433: ------------------------------------------
4434: PROCEDURE delete_row(
4435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4436: x_return_status OUT NOCOPY VARCHAR2,
4437: x_msg_count OUT NOCOPY NUMBER,
4438: x_msg_data OUT NOCOPY VARCHAR2,
4439: p_okl_txl_ap_inv_lns_tl_rec IN okl_txl_ap_inv_lns_tl_rec_type) IS

Line 4520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4516: -- delete_row for:OKL_TXL_AP_INV_LNS_V --
4517: -----------------------------------------
4518: PROCEDURE delete_row(
4519: p_api_version IN NUMBER,
4520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4521: x_return_status OUT NOCOPY VARCHAR2,
4522: x_msg_count OUT NOCOPY NUMBER,
4523: x_msg_data OUT NOCOPY VARCHAR2,
4524: p_tplv_rec IN tplv_rec_type) IS

Line 4615: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4611: -- PL/SQL TBL delete_row for:TPLV_TBL --
4612: ----------------------------------------
4613: PROCEDURE delete_row(
4614: p_api_version IN NUMBER,
4615: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4616: x_return_status OUT NOCOPY VARCHAR2,
4617: x_msg_count OUT NOCOPY NUMBER,
4618: x_msg_data OUT NOCOPY VARCHAR2,
4619: p_tplv_tbl IN tplv_tbl_type) IS

Line 4634: p_init_msg_list => OKC_API.G_FALSE,

4630: i := p_tplv_tbl.FIRST;
4631: LOOP
4632: delete_row (
4633: p_api_version => p_api_version,
4634: p_init_msg_list => OKC_API.G_FALSE,
4635: x_return_status => x_return_status,
4636: x_msg_count => x_msg_count,
4637: x_msg_data => x_msg_data,
4638: p_tplv_rec => p_tplv_tbl(i));