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.OKE_CONTRACT_PUB dependencies on OKE_DELIVERABLE_PVT

Line 2225: p_del_rec IN oke_deliverable_pvt.del_rec_type,

2221: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2222: x_return_status OUT NOCOPY VARCHAR2,
2223: x_msg_count OUT NOCOPY NUMBER,
2224: x_msg_data OUT NOCOPY VARCHAR2,
2225: p_del_rec IN oke_deliverable_pvt.del_rec_type,
2226:
2227: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS
2228:
2229: l_del_rec oke_deliverable_pvt.del_rec_type;

Line 2227: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS

2223: x_msg_count OUT NOCOPY NUMBER,
2224: x_msg_data OUT NOCOPY VARCHAR2,
2225: p_del_rec IN oke_deliverable_pvt.del_rec_type,
2226:
2227: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS
2228:
2229: l_del_rec oke_deliverable_pvt.del_rec_type;
2230:
2231: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DELIVERABLE';

Line 2229: l_del_rec oke_deliverable_pvt.del_rec_type;

2225: p_del_rec IN oke_deliverable_pvt.del_rec_type,
2226:
2227: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS
2228:
2229: l_del_rec oke_deliverable_pvt.del_rec_type;
2230:
2231: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DELIVERABLE';
2232: l_api_version CONSTANT NUMBER := 1.0;
2233: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2312: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,

2308: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2309: x_return_status OUT NOCOPY VARCHAR2,
2310: x_msg_count OUT NOCOPY NUMBER,
2311: x_msg_data OUT NOCOPY VARCHAR2,
2312: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,
2313: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
2314:
2315: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DELIVERABLE';
2316: l_api_version CONSTANT NUMBER := 1.0;

Line 2313: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

2309: x_return_status OUT NOCOPY VARCHAR2,
2310: x_msg_count OUT NOCOPY NUMBER,
2311: x_msg_data OUT NOCOPY VARCHAR2,
2312: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,
2313: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
2314:
2315: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DELIVERABLE';
2316: l_api_version CONSTANT NUMBER := 1.0;
2317: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2320: l_del_tbl oke_deliverable_pvt.del_tbl_type;

2316: l_api_version CONSTANT NUMBER := 1.0;
2317: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2318: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2319: i NUMBER;
2320: l_del_tbl oke_deliverable_pvt.del_tbl_type;
2321: BEGIN
2322: -- call START_ACTIVITY to create savepoint, check compatibility
2323: -- and initialize message list
2324: l_return_status := OKE_API.START_ACTIVITY(

Line 2414: p_del_rec IN oke_deliverable_pvt.del_rec_type,

2410: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2411: x_return_status OUT NOCOPY VARCHAR2,
2412: x_msg_count OUT NOCOPY NUMBER,
2413: x_msg_data OUT NOCOPY VARCHAR2,
2414: p_del_rec IN oke_deliverable_pvt.del_rec_type,
2415: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS
2416:
2417: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DELIVERABLE';
2418: l_api_version CONSTANT NUMBER := 1.0;

Line 2415: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS

2411: x_return_status OUT NOCOPY VARCHAR2,
2412: x_msg_count OUT NOCOPY NUMBER,
2413: x_msg_data OUT NOCOPY VARCHAR2,
2414: p_del_rec IN oke_deliverable_pvt.del_rec_type,
2415: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS
2416:
2417: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DELIVERABLE';
2418: l_api_version CONSTANT NUMBER := 1.0;
2419: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2495: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,

2491: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2492: x_return_status OUT NOCOPY VARCHAR2,
2493: x_msg_count OUT NOCOPY NUMBER,
2494: x_msg_data OUT NOCOPY VARCHAR2,
2495: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,
2496: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
2497:
2498: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
2499: l_api_version CONSTANT NUMBER := 1.0;

Line 2496: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

2492: x_return_status OUT NOCOPY VARCHAR2,
2493: x_msg_count OUT NOCOPY NUMBER,
2494: x_msg_data OUT NOCOPY VARCHAR2,
2495: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,
2496: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
2497:
2498: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
2499: l_api_version CONSTANT NUMBER := 1.0;
2500: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2597: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

2593: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2594: x_return_status OUT NOCOPY VARCHAR2,
2595: x_msg_count OUT NOCOPY NUMBER,
2596: x_msg_data OUT NOCOPY VARCHAR2,
2597: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2598:
2599: l_del_rec oke_deliverable_pvt.del_rec_type;
2600: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_DELIVERABLE';
2601: l_api_version CONSTANT NUMBER := 1.0;

Line 2599: l_del_rec oke_deliverable_pvt.del_rec_type;

2595: x_msg_count OUT NOCOPY NUMBER,
2596: x_msg_data OUT NOCOPY VARCHAR2,
2597: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2598:
2599: l_del_rec oke_deliverable_pvt.del_rec_type;
2600: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_DELIVERABLE';
2601: l_api_version CONSTANT NUMBER := 1.0;
2602: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2603: BEGIN

Line 2678: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

2674: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2675: x_return_status OUT NOCOPY VARCHAR2,
2676: x_msg_count OUT NOCOPY NUMBER,
2677: x_msg_data OUT NOCOPY VARCHAR2,
2678: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS
2679:
2680: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
2681: l_api_version CONSTANT NUMBER := 1.0;
2682: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2810: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

2806: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2807: x_return_status OUT NOCOPY VARCHAR2,
2808: x_msg_count OUT NOCOPY NUMBER,
2809: x_msg_data OUT NOCOPY VARCHAR2,
2810: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2811:
2812: l_del_rec oke_deliverable_pvt.del_rec_type;
2813:
2814: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DELIVERABLE';

Line 2812: l_del_rec oke_deliverable_pvt.del_rec_type;

2808: x_msg_count OUT NOCOPY NUMBER,
2809: x_msg_data OUT NOCOPY VARCHAR2,
2810: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2811:
2812: l_del_rec oke_deliverable_pvt.del_rec_type;
2813:
2814: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DELIVERABLE';
2815: l_api_version CONSTANT NUMBER := 1.0;
2816: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2893: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

2889: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2890: x_return_status OUT NOCOPY VARCHAR2,
2891: x_msg_count OUT NOCOPY NUMBER,
2892: x_msg_data OUT NOCOPY VARCHAR2,
2893: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS
2894:
2895: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DELIVERABLE';
2896:
2897: l_api_version CONSTANT NUMBER := 1.0;

Line 2901: l_del_tbl oke_deliverable_pvt.del_tbl_type := p_del_tbl;

2897: l_api_version CONSTANT NUMBER := 1.0;
2898: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2899: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2900: i NUMBER;
2901: l_del_tbl oke_deliverable_pvt.del_tbl_type := p_del_tbl;
2902: BEGIN
2903: -- call START_ACTIVITY to create savepoint, check compatibility
2904: -- and initialize message list
2905: l_return_status := OKE_API.START_ACTIVITY(

Line 2993: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

2989: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2990: x_return_status OUT NOCOPY VARCHAR2,
2991: x_msg_count OUT NOCOPY NUMBER,
2992: x_msg_data OUT NOCOPY VARCHAR2,
2993: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2994:
2995: l_del_rec oke_deliverable_pvt.del_rec_type;
2996: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_DELIVERABLE';
2997: l_api_version CONSTANT NUMBER := 1.0;

Line 2995: l_del_rec oke_deliverable_pvt.del_rec_type;

2991: x_msg_count OUT NOCOPY NUMBER,
2992: x_msg_data OUT NOCOPY VARCHAR2,
2993: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS
2994:
2995: l_del_rec oke_deliverable_pvt.del_rec_type;
2996: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_DELIVERABLE';
2997: l_api_version CONSTANT NUMBER := 1.0;
2998: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2999: BEGIN

Line 3076: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

3072: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
3073: x_return_status OUT NOCOPY VARCHAR2,
3074: x_msg_count OUT NOCOPY NUMBER,
3075: x_msg_data OUT NOCOPY VARCHAR2,
3076: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS
3077:
3078: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_DELIVERABLE';
3079: l_api_version CONSTANT NUMBER := 1.0;
3080: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 3174: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

3170: x_msg_count OUT NOCOPY NUMBER,
3171: x_msg_data OUT NOCOPY VARCHAR2,
3172: p_header_id IN NUMBER,
3173: p_first_default_flag IN VARCHAR2,
3174: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
3175:
3176: l_api_version CONSTANT NUMBER := 1;
3177: l_del_tbl oke_deliverable_pvt.del_tbl_type;
3178: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DELIVERABLE';

Line 3177: l_del_tbl oke_deliverable_pvt.del_tbl_type;

3173: p_first_default_flag IN VARCHAR2,
3174: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS
3175:
3176: l_api_version CONSTANT NUMBER := 1;
3177: l_del_tbl oke_deliverable_pvt.del_tbl_type;
3178: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DELIVERABLE';
3179:
3180: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
3181: l_buy_or_sell VARCHAR2(1);

Line 4137: l_deliverable_tbl OKE_DELIVERABLE_PVT.del_tbl_type;

4133: l_article_rec okc_k_article_pub.catv_rec_type;
4134:
4135: l_contact_tbl okc_contract_party_pub.ctcv_tbl_type;
4136: l_party_tbl okc_contract_party_pub.cplv_tbl_type;
4137: l_deliverable_tbl OKE_DELIVERABLE_PVT.del_tbl_type;
4138:
4139:
4140: l_item_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
4141: l_item_out_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;

Line 4482: OKE_DELIVERABLE_PVT.delete_row(

4478: l_deliverable_tbl(i).deliverable_id := c.deliverable_id;
4479: i:= i+1;
4480: end loop;
4481:
4482: OKE_DELIVERABLE_PVT.delete_row(
4483: p_api_version => l_api_version,
4484: p_init_msg_list => OKE_API.G_FALSE,
4485: x_return_status => l_status,
4486: x_msg_count => x_msg_count,