APPS.PO_BUYER_WORKLOAD_SV dependencies on PO_BUYER_WORKLOAD_SV

Line 1: PACKAGE BODY PO_BUYER_WORKLOAD_SV AS

1: PACKAGE BODY PO_BUYER_WORKLOAD_SV AS
2: /* $Header: POXBWMWB.pls 120.0.12000000.3 2007/04/27 08:28:07 vdurbhak ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'po_buyer_workload_sv';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'po_buyer_workload_sv';

1: PACKAGE BODY PO_BUYER_WORKLOAD_SV AS
2: /* $Header: POXBWMWB.pls 120.0.12000000.3 2007/04/27 08:28:07 vdurbhak ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'po_buyer_workload_sv';
5:
6: /*===========================================================================
7:
8: PROCEDURE NAME: get_num_unassigned

Line 168: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV.GET_NUM_UNASSIGNED', x_progress, sqlcode);

164:
165: EXCEPTION
166: WHEN OTHERS THEN
167: -- dbms_output.put_line('In Exception');
168: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV.GET_NUM_UNASSIGNED', x_progress, sqlcode);
169: RAISE;
170: END;
171:
172: /*===========================================================================

Line 330: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV.GET_NUM_ASSIGNED', x_progress, sqlcode);

326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: -- dbms_output.put_line('In Exception');
330: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV.GET_NUM_ASSIGNED', x_progress, sqlcode);
331: RAISE;
332: END;
333:
334: /*===========================================================================

Line 367: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV2.UPDATE_BUYER_BY_ROWID',

363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: -- dbms_output.put_line('Exception in update_buyer_by_rowid');
367: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV2.UPDATE_BUYER_BY_ROWID',
368: x_progress, sqlcode);
369: RAISE;
370: END;
371:

Line 521: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV2.UPDATE_BUYERS',

517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: -- dbms_output.put_line('Exception in update_buyers');
521: PO_MESSAGE_S.SQL_ERROR('PO_BUYER_WORKLOAD_SV2.UPDATE_BUYERS',
522: x_progress, sqlcode);
523: RAISE;
524: END;
525: