eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.47.12020000.2 2013/02/11 01:06:29 vegajula 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.47.12020000.2 2013/02/11 01:06:29 vegajula 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 133: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',

129: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
130: end loop;*/
131:
132: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
133: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
134: 'Before create_negotiation');
135: END IF;
136:
137: -- Finally, make the call to create_negotiation

Line 156: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',

152: p_document_org_id => p_document_org_id,
153: p_fair_opp_notice_flag => p_fair_opp_notice_flag);
154:
155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
156: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk',
157: 'After create_negotiation');
158: END IF;
159:
160: -- End of API Body

Line 259: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',

255: l_req_lines_tbl(i).job_id := p_job_id_tbl(i);
256: end loop;*/
257:
258: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
259: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
260: 'Before create_negotiation');
261: END IF;
262:
263: -- Finally, make the call to create_negotiation

Line 281: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',

277: p_neg_outcome => p_neg_outcome,
278: p_document_org_id => p_document_org_id);
279:
280: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
281: fnd_log.string(fnd_log.level_statement,'po.plsql.po_negotiations_sv1.create_negotiation_bulk1',
282: 'After create_negotiation');
283: END IF;
284:
285: -- End of API Body

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

755: END IF;
756: --bug 6131913
757: -- logme('create_negotiation ' || x_progress);
758:
759: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
760:
761:
762:
763: --bug 5841426

Line 769: 'PO_NEGOTIATIONS_SV1',

765: IF(t_neg_lines IS NULL OR t_neg_line_num IS null) then
766: FORALL i IN 1..t_req_lines.Count
767: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
768: SELECT prl.requisition_line_id,
769: 'PO_NEGOTIATIONS_SV1',
770: prh.segment1,
771: prl.line_num,
772: prl.item_id,
773: prl.category_id,

Line 783: 'PO_NEGOTIATIONS_SV1',

779: else
780: FORALL i IN 1..t_req_lines.Count
781: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, num4, char2, date1)
782: SELECT prl.requisition_line_id,
783: 'PO_NEGOTIATIONS_SV1',
784: prh.segment1,
785: prl.line_num,
786: prl.item_id,
787: prl.category_id,

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

865: and rl.item_id = msi.inventory_item_id(+)
866: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =
867: nvl(rl.destination_organization_id,-1)
868: AND RL.job_id = PJ.job_id(+) --
869: AND psg.index_char1 = ''PO_NEGOTIATIONS_SV1''' ;
870:
871: if (x_grouping_method = 'REQUISITION') then
872: l_string := l_string || ' ORDER BY psg.char1, psg.num1';
873: ELSE

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

2693:
2694: END;
2695:
2696: x_progress := '003';
2697: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
2698:
2699:
2700: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
2701: SELECT prl.requisition_line_id,

Line 2702: 'PO_NEGOTIATIONS_SV1',

2698:
2699:
2700: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
2701: SELECT prl.requisition_line_id,
2702: 'PO_NEGOTIATIONS_SV1',
2703: prh.segment1,
2704: prl.line_num,
2705: prl.item_id,
2706: prl.category_id,

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

2756: and rl.item_id = msi.inventory_item_id(+)
2757: and coalesce(msi.organization_id, rl.destination_organization_id,-1) =
2758: nvl(rl.destination_organization_id,-1)
2759: AND RL.job_id = PJ.job_id(+) --
2760: AND psg.index_char1 = ''PO_NEGOTIATIONS_SV1''' ;
2761:
2762: -- logme('create_negotiation before cursor' || x_progress);
2763:
2764: OPEN l_cursor FOR l_string;

Line 3960: END po_negotiations_sv1;

3956: raise; --raise exception
3957: END update_sol_ref_amend;
3958:
3959:
3960: END po_negotiations_sv1;