13: *******************************************************************************/
14:
15: PROCEDURE Get_PO_Required (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_contract_id IN NUMBER,
20: p_cp_service_id IN NUMBER,
21: x_PO_required_for_service OUT VARCHAR2,
14:
15: PROCEDURE Get_PO_Required (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_contract_id IN NUMBER,
20: p_cp_service_id IN NUMBER,
21: x_PO_required_for_service OUT VARCHAR2,
22: x_return_status OUT VARCHAR2,
24: x_msg_data OUT VARCHAR2 );
25:
26: PROCEDURE Get_Pre_Payment_Required (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_contract_id IN NUMBER,
31: p_cp_service_id IN NUMBER,
32: x_pre_payment_required OUT VARCHAR2,
25:
26: PROCEDURE Get_Pre_Payment_Required (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_contract_id IN NUMBER,
31: p_cp_service_id IN NUMBER,
32: x_pre_payment_required OUT VARCHAR2,
33: x_return_status OUT VARCHAR2,
35: x_msg_data OUT VARCHAR2 );
36:
37: PROCEDURE Get_Address (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_cp_service_id IN NUMBER,
42: x_bill_address_id OUT NUMBER,
43: x_bill_address1 OUT VARCHAR2,
36:
37: PROCEDURE Get_Address (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_cp_service_id IN NUMBER,
42: x_bill_address_id OUT NUMBER,
43: x_bill_address1 OUT VARCHAR2,
44: x_bill_address2 OUT VARCHAR2,
52: x_msg_data OUT VARCHAR2 );
53:
54: PROCEDURE Get_Salesperson (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_contract_id IN NUMBER,
59: p_cp_service_id IN NUMBER,
60: x_salesperson_id OUT NUMBER,
53:
54: PROCEDURE Get_Salesperson (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_contract_id IN NUMBER,
59: p_cp_service_id IN NUMBER,
60: x_salesperson_id OUT NUMBER,
61: x_salesperson OUT VARCHAR2,
64: x_msg_data OUT VARCHAR2 );
65:
66: PROCEDURE Get_Auto_Renewal_Flag (
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_contract_id IN NUMBER,
71: p_cp_service_id IN NUMBER,
72: x_auto_renewal_flag OUT VARCHAR2,
65:
66: PROCEDURE Get_Auto_Renewal_Flag (
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_contract_id IN NUMBER,
71: p_cp_service_id IN NUMBER,
72: x_auto_renewal_flag OUT VARCHAR2,
73: x_return_status OUT VARCHAR2,