DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_IB_PVT dependencies on HZ_PARTIES

Line 13: G_PARTY_SRC_TABLE Varchar2(30) := 'HZ_PARTIES';

9: G_TRX_HDR_TYPE_REBOOK Varchar2(30) := 'CRB';
10: G_TSU_CODE_ENTERED Varchar2(30) := 'ENTERED';
11: G_ITM_INST_PARTY Varchar2(30) := 'LESSEE';
12: G_CONTRACT_INTENT Varchar2(1) := 'S';
13: G_PARTY_SRC_TABLE Varchar2(30) := 'HZ_PARTIES';
14: G_PARTY_RELATIONSHIP Varchar2(30) := 'OWNER';
15: G_IB_LINE_LTY_CODE Varchar2(30) := 'INST_ITEM';
16: G_IB_LINE_LTY_ID NUMBER := 45;
17: G_MODEL_LINE_LTY_CODE Varchar2(30) := 'ITEM';

Line 430: FROM HZ_PARTIES P, OKC_K_PARTY_ROLES_B OKPRV

426: */
427: Begin
428: SELECT P.PARTY_ID
429: INTO l_party_id
430: FROM HZ_PARTIES P, OKC_K_PARTY_ROLES_B OKPRV
431: WHERE OKPRV.chr_id = p_chrv_id
432: AND OKPRV.rle_code = 'LESSEE'
433: AND OKPRV.jtot_object1_code = 'OKX_PARTY'
434: AND p.PARTY_ID = OKPRV.object1_id1

Line 2630: If nvl(l_csi_rec.owner_party_source_table,OKL_API.G_MISS_CHAR) = 'HZ_PARTIES' then

2626: End If;
2627: CLose l_csi_csr;
2628:
2629: --check for party and account changes
2630: If nvl(l_csi_rec.owner_party_source_table,OKL_API.G_MISS_CHAR) = 'HZ_PARTIES' then
2631: If to_number(l_hdr_rec.object1_id1) <> l_csi_rec.owner_party_id then
2632: l_update_required := 'Y';
2633: l_count := l_party_tbl.COUNT;
2634: Open l_csi_owner_csr(p_instance_id => l_instance_header_rec.instance_id);