APPS.OE_PARTY_TOTALS dependencies on HZ_PARTIES

Line 6: PROCEDURE Update_HZ_Parties(p_party_id IN NUMBER

2: /* $Header: OEXBTOTB.pls 120.1 2005/06/02 23:23:23 appldev $ */
3:
4: -- Forward declaration of procedure
5:
6: PROCEDURE Update_HZ_Parties(p_party_id IN NUMBER
7: , p_party_type IN VARCHAR2
8: , p_last_update_date IN DATE
9: , p_party_total IN NUMBER
10: , p_order_count IN NUMBER

Line 41: hz_parties a

37: SELECT DISTINCT a.party_id,
38: a.party_type,
39: a.last_update_date
40: FROM hz_cust_accounts b,
41: hz_parties a
42: WHERE b.party_id = a.party_id;
43:
44: CURSOR C_ORDER_HEADER(p_party_id NUMBER) IS
45: SELECT a.header_id,

Line 254: Update_HZ_Parties(p_party_id => C1.party_id

250: l_order_count := NULL;
251: END IF;
252:
253: oe_debug_pub.ADD('The Party Total was '||to_char(l_party_total), 2);
254: Update_HZ_Parties(p_party_id => C1.party_id
255: , p_party_type => C1.party_type
256: , p_last_update_date => C1.last_update_date
257: , p_party_total => l_party_total
258: , p_order_count => l_order_count

Line 296: PROCEDURE Update_HZ_Parties(p_party_id IN NUMBER

292: oe_debug_pub.ADD('Error in processing Parties '|| ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
293: retcode := 2;
294: END Update_Party_Totals;
295:
296: PROCEDURE Update_HZ_Parties(p_party_id IN NUMBER
297: , p_party_type IN VARCHAR2
298: , p_last_update_date IN DATE
299: , p_party_total IN NUMBER
300: , p_order_count IN NUMBER

Line 323: UPDATE hz_parties

319: p_party_type = 'GROUP' OR
320: p_party_type = 'PARTY_RELATIONSHIP' OR
321: p_party_type = 'ORGANIZATION' THEN
322:
323: UPDATE hz_parties
324: SET total_num_of_orders = p_order_count,
325: total_ordered_amount = p_party_total,
326: last_ordered_date = p_last_order_date
327: WHERE party_id = p_party_id;

Line 356: END Update_HZ_Parties;

352: v_errmsg := SQLERRM;
353: oe_debug_pub.ADD('Error in updating the Party '||to_char(p_party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
354: x_return_status := FND_API.G_RET_STS_ERROR;
355:
356: END Update_HZ_Parties;
357:
358: END OE_Party_TOTALS;