1: Package OKC_RENEWAL_OUTCOME_PUB AUTHID CURRENT_USER AS
2: /* $Header: OKCPORWS.pls 120.0 2005/05/25 23:12:23 appldev noship $*/
3:
4: PROCEDURE Renewal_Outcome( p_api_version IN NUMBER DEFAULT 1.0
5: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
6: ,x_return_status OUT NOCOPY VARCHAR2
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: -- ,x_contract_id OUT NOCOPY NUMBER
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: -- ,x_contract_id OUT NOCOPY NUMBER
10: ,p_contract_id IN NUMBER
11: ,p_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: -- ,x_contract_id OUT NOCOPY NUMBER
10: ,p_contract_id IN NUMBER
11: ,p_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
9: -- ,x_contract_id OUT NOCOPY NUMBER
10: ,p_contract_id IN NUMBER
11: ,p_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
10: ,p_contract_id IN NUMBER
11: ,p_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
11: ,p_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
12: ,p_contract_version IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
13: ,p_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
14: ,p_object_version_number IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
15: ,p_new_contract_number IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
16: ,p_new_contract_modifier IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
17: ,p_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
25: ,p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
18: ,p_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
25: ,p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
26:
19: ,p_orig_start_date IN DATE DEFAULT OKC_API.G_MISS_DATE
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
25: ,p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
26:
27: END OKC_RENEWAL_OUTCOME_PUB;
20: ,p_orig_end_date IN DATE DEFAULT OKC_API.G_MISS_DATE
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
25: ,p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
26:
27: END OKC_RENEWAL_OUTCOME_PUB;
21: ,p_uom_code IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
22: ,p_duration IN NUMBER DEFAULT OKC_API.G_MISS_NUM
23: ,p_context IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
24: ,p_perpetual_flag IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
25: ,p_do_commit IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
26:
27: END OKC_RENEWAL_OUTCOME_PUB;