DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PUB dependencies on OKE_DELIVERABLE_PVT

Line 2224: p_del_rec IN oke_deliverable_pvt.del_rec_type,

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

Line 2226: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS

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

Line 2228: l_del_rec oke_deliverable_pvt.del_rec_type;

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

Line 2310: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,

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

Line 2311: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

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

Line 2318: l_del_tbl oke_deliverable_pvt.del_tbl_type;

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

Line 2412: p_del_rec IN oke_deliverable_pvt.del_rec_type,

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

Line 2413: x_del_rec OUT NOCOPY oke_deliverable_pvt.del_rec_type) IS

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

Line 2493: p_del_tbl IN oke_deliverable_pvt.del_tbl_type,

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

Line 2494: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

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

Line 2595: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

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

Line 2597: l_del_rec oke_deliverable_pvt.del_rec_type;

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

Line 2676: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

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

Line 2808: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

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

Line 2810: l_del_rec oke_deliverable_pvt.del_rec_type;

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

Line 2891: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

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

Line 2899: l_del_tbl oke_deliverable_pvt.del_tbl_type := p_del_tbl;

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

Line 2991: p_del_rec IN oke_deliverable_pvt.del_rec_type) IS

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

Line 2993: l_del_rec oke_deliverable_pvt.del_rec_type;

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

Line 3074: p_del_tbl IN oke_deliverable_pvt.del_tbl_type) IS

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

Line 3172: x_del_tbl OUT NOCOPY oke_deliverable_pvt.del_tbl_type) IS

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

Line 3175: l_del_tbl oke_deliverable_pvt.del_tbl_type;

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

Line 4135: l_deliverable_tbl OKE_DELIVERABLE_PVT.del_tbl_type;

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

Line 4480: OKE_DELIVERABLE_PVT.delete_row(

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