APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_NEGOTIATIONS_SV1

Line 1: PACKAGE BODY po_negotiations_sv1 AS

1: PACKAGE BODY po_negotiations_sv1 AS
2: /* $Header: POXNEG1B.pls 120.22 2007/12/19 14:15:45 vdurbhak ship $*/
3:
4: --
5: G_PKG_NAME CONSTANT varchar2(30) := 'po_negotiations_sv1';

Line 5: G_PKG_NAME CONSTANT varchar2(30) := 'po_negotiations_sv1';

1: PACKAGE BODY po_negotiations_sv1 AS
2: /* $Header: POXNEG1B.pls 120.22 2007/12/19 14:15:45 vdurbhak ship $*/
3:
4: --
5: G_PKG_NAME CONSTANT varchar2(30) := 'po_negotiations_sv1';
6: -- Bug 3780359
7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'||G_PKG_NAME||'.';
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

Line 497: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';

493: x_num_records := t_req_lines.COUNT;
494:
495: --bug 6131913
496:
497: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
498:
499:
500:
501: --bug 5841426

Line 505: 'PO_NEGOTIATIONS_SV1',

501: --bug 5841426
502: FORALL i IN 1..t_req_lines.Count
503: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
504: SELECT prl.requisition_line_id,
505: 'PO_NEGOTIATIONS_SV1',
506: prh.segment1,
507: prl.line_num,
508: prl.item_id,
509: prl.category_id,

Line 570: AND psg.index_char1 = ''PO_NEGOTIATIONS_SV1''' ;

566: and rl.item_id = msi.inventory_item_id(+)
567: and nvl(msi.organization_id, rl.destination_organization_id) =
568: rl.destination_organization_id
569: AND RL.job_id = PJ.job_id(+) --
570: AND psg.index_char1 = ''PO_NEGOTIATIONS_SV1''' ;
571:
572: if (x_grouping_method = 'REQUISITION') then
573: l_string := l_string || ' ORDER BY psg.char1, psg.num1';
574: ELSE

Line 1837: END po_negotiations_sv1;

1833:
1834: END get_auction_display_line_num;
1835: -- Bug 3780359 End
1836:
1837: END po_negotiations_sv1;