DBA Data[Home] [Help]

APPS.HZ_EBI_CUST_LOAD dependencies on HZ_ORG_CUST_BO

Line 168: ,x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL

164:
165: END Raise_CUST_LOAD_Event;
166:
167: PROCEDURE Get_Org_Custs_BO( p_event_id IN NUMBER
168: ,x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL
169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
171: )
172: Is

Line 173: x_org_cust_obj HZ_ORG_CUST_BO;

169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
171: )
172: Is
173: x_org_cust_obj HZ_ORG_CUST_BO;
174: x_msg_data VARCHAR2(2000);
175: x_msg_count NUMBER;
176: party_id NUMBER;
177: l_count NUMBER ;

Line 183: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();

179: CURSOR cust_cur IS
180: SELECT party_id from HZ_EBI_CUST_LOAD_LOG where event_id = p_event_id;
181:
182: BEGIN
183: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();
184: x_messages := HZ_MESSAGE_OBJ_TBL();
185: l_count :=0;
186: OPEN cust_cur;
187: LOOP

Line 193: HZ_ORG_CUST_BO_PUB.get_org_cust_bo( p_organization_id => party_id

189: EXIT WHEN cust_cur%NOTFOUND;
190: x_org_cust_objs.extend(1);
191: x_messages.extend(1) ;
192: l_count := l_count+1;
193: HZ_ORG_CUST_BO_PUB.get_org_cust_bo( p_organization_id => party_id
194: ,p_organization_os =>NULL
195: ,p_organization_osr =>NULL
196: ,x_org_cust_obj => x_org_cust_obj
197: ,x_return_status => x_return_status