DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on OKC_CONTRACT_PARTY_PUB

Line 23: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;

19: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: l_index VARCHAR2(240);
21:
22: --Party Role
23: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
24: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
25:
26: Cursor l_party_csr Is Select Id From OKC_K_PARTY_ROLES_V
27: Where dnz_chr_id = p_chrid

Line 24: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;

20: l_index VARCHAR2(240);
21:
22: --Party Role
23: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
24: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
25:
26: Cursor l_party_csr Is Select Id From OKC_K_PARTY_ROLES_V
27: Where dnz_chr_id = p_chrid
28: And cle_id Is Null

Line 78: okc_contract_party_pub.create_k_party_role

74: l_cplv_tbl_in(1).Object1_id2 := '#';
75: l_cplv_tbl_in(1).jtot_object1_code := p_object_code;
76: l_cplv_tbl_in(1).dnz_chr_id := p_chrid;
77:
78: okc_contract_party_pub.create_k_party_role
79: (
80: p_api_version => l_api_version,
81: p_init_msg_list => l_init_msg_list,
82: x_return_status => l_return_status,

Line 1162: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

1158: l_cgcv_tbl_in okc_contract_group_pub.cgcv_tbl_type;
1159: l_cgcv_tbl_out okc_contract_group_pub.cgcv_tbl_type;
1160:
1161: --Contacts
1162: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1163: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1164:
1165: --Agreements/Governance
1166:

Line 1163: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

1159: l_cgcv_tbl_out okc_contract_group_pub.cgcv_tbl_type;
1160:
1161: --Contacts
1162: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1163: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1164:
1165: --Agreements/Governance
1166:
1167: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

Line 1433: okc_contract_party_pub.create_contact

1429: l_ctcv_tbl_in(1).object1_id1 := l_hdr_contactid;
1430: l_ctcv_tbl_in(1).object1_id2 := '#';
1431: l_ctcv_tbl_in(1).jtot_object1_code:= p_Contact_tbl (i).contact_object_code;
1432:
1433: okc_contract_party_pub.create_contact
1434: (
1435: p_api_version => l_api_version,
1436: p_init_msg_list => l_init_msg_list,
1437: x_return_status => l_return_status,

Line 2160: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

2156: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
2157: l_return_status VARCHAR2(1) := 'S';
2158: l_index VARCHAR2(2000);
2159:
2160: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2161: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2162:
2163:
2164:

Line 2161: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

2157: l_return_status VARCHAR2(1) := 'S';
2158: l_index VARCHAR2(2000);
2159:
2160: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2161: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2162:
2163:
2164:
2165: Cursor l_mtl_csr(p_inventory_id Number, p_organization_id Number) Is

Line 2631: okc_contract_party_pub.create_contact

2627: l_ctcv_tbl_in(1).object1_id1 := p_contact_tbl(i).contact_id;
2628: l_ctcv_tbl_in(1).object1_id2 := '#';
2629: l_ctcv_tbl_in(1).jtot_object1_code:= l_obj;
2630:
2631: okc_contract_party_pub.create_contact
2632: (
2633: p_api_version => l_api_version,
2634: p_init_msg_list => l_init_msg_list,
2635: x_return_status => l_return_status,