DBA Data[Home] [Help]

APPS.OKS_CONTRACTS_PUB dependencies on OKC_CONTRACT_PARTY_PUB

Line 107: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;

103:
104: l_index VARCHAR2(240);
105:
106: --Party Role
107: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
108: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
109:
110: Cursor l_party_csr Is
111: Select Id From OKC_K_PARTY_ROLES_B

Line 108: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;

104: l_index VARCHAR2(240);
105:
106: --Party Role
107: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
108: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
109:
110: Cursor l_party_csr Is
111: Select Id From OKC_K_PARTY_ROLES_B
112: Where dnz_chr_id = p_chrid

Line 167: Okc_contract_party_pub.create_k_party_role

163: l_cplv_tbl_in(1).Object1_id2 := '#';
164: l_cplv_tbl_in(1).jtot_object1_code := p_object_code;
165: l_cplv_tbl_in(1).dnz_chr_id := p_chrid;
166:
167: Okc_contract_party_pub.create_k_party_role
168: (
169: p_api_version => l_api_version,
170: p_init_msg_list => l_init_msg_list,
171: x_return_status => l_return_status,

Line 1113: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;

1109: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1110: AND hzr.DIRECTIONAL_FLAG = 'F';
1111: --END NPALEPU
1112:
1113: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
1114: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
1115: --Contacts
1116: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1117: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

Line 1114: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;

1110: AND hzr.DIRECTIONAL_FLAG = 'F';
1111: --END NPALEPU
1112:
1113: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
1114: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
1115: --Contacts
1116: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1117: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1118:

Line 1116: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

1112:
1113: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
1114: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
1115: --Contacts
1116: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1117: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1118:
1119: l_partyid_v NUMBER;
1120: l_partyid_t NUMBER;

Line 1117: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;

1113: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
1114: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
1115: --Contacts
1116: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1117: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
1118:
1119: l_partyid_v NUMBER;
1120: l_partyid_t NUMBER;
1121: l_rah_party_id NUMBER;

Line 1325: okc_contract_party_pub.create_contact

1321: l_ctcv_tbl_in(1).object1_id1 := p_contact_info_tbl (i).contact_id; --l_hdr_contactid;
1322: l_ctcv_tbl_in(1).object1_id2 := '#';
1323: l_ctcv_tbl_in(1).jtot_object1_code := p_contact_info_tbl (i).contact_object_code;
1324:
1325: okc_contract_party_pub.create_contact
1326: (
1327: p_api_version => l_api_version,
1328: p_init_msg_list => l_init_msg_list,
1329: x_return_status => l_return_status,

Line 3431: l_ctcv_tbl_in Okc_contract_party_pub.ctcv_tbl_type;

3427: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
3428: l_return_status VARCHAR2(1) := 'S';
3429: l_index VARCHAR2(2000);
3430:
3431: l_ctcv_tbl_in Okc_contract_party_pub.ctcv_tbl_type;
3432: l_ctcv_tbl_out Okc_contract_party_pub.ctcv_tbl_type;
3433: l_bill_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
3434: l_msg_index Number;
3435: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;

Line 3432: l_ctcv_tbl_out Okc_contract_party_pub.ctcv_tbl_type;

3428: l_return_status VARCHAR2(1) := 'S';
3429: l_index VARCHAR2(2000);
3430:
3431: l_ctcv_tbl_in Okc_contract_party_pub.ctcv_tbl_type;
3432: l_ctcv_tbl_out Okc_contract_party_pub.ctcv_tbl_type;
3433: l_bill_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
3434: l_msg_index Number;
3435: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3436: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;

Line 4011: okc_contract_party_pub.create_contact

4007: l_ctcv_tbl_in(1).object1_id1 := p_contact_tbl(i).contact_id;
4008: l_ctcv_tbl_in(1).object1_id2 := '#';
4009: l_ctcv_tbl_in(1).jtot_object1_code := l_obj;
4010:
4011: okc_contract_party_pub.create_contact
4012: (
4013: p_api_version => l_api_version,
4014: p_init_msg_list => l_init_msg_list,
4015: x_return_status => l_return_status,