APPS.QPR_SR_UTIL dependencies on QPR_SR_UTIL

Line 1: PACKAGE BODY QPR_SR_UTIL AS

1: PACKAGE BODY QPR_SR_UTIL AS
2: /* $Header: QPRUTILB.pls 120.6 2008/03/12 12:57:35 amjha ship $ */
3:
4: g_ref_uom VARCHAR2(10);
5: g_ref_item_id NUMBER;

Line 399: qpr_sr_util.get_null_pk),

395: 'attribute13',cust.attribute13,
396: 'attribute14', cust.attribute14,
397: 'attribute15', cust.attribute15, '2')
398: , '1', nvl(cust.cust_account_id,
399: qpr_sr_util.get_null_pk),
400: qpr_sr_util.get_null_pk)
401: from
402: hz_cust_accounts cust
403: where cust.party_id = p_party_id

Line 400: qpr_sr_util.get_null_pk)

396: 'attribute14', cust.attribute14,
397: 'attribute15', cust.attribute15, '2')
398: , '1', nvl(cust.cust_account_id,
399: qpr_sr_util.get_null_pk),
400: qpr_sr_util.get_null_pk)
401: from
402: hz_cust_accounts cust
403: where cust.party_id = p_party_id
404: order by cust.cust_account_id ASC;

Line 1081: END QPR_SR_UTIL;

1077: delete from QPR_PRICE_PLANS_TL where price_plan_id = p_price_plan_id;
1078: delete from QPR_PRICE_PLANS_B where price_plan_id = p_price_plan_id;
1079: end;
1080:
1081: END QPR_SR_UTIL;