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_COMM_FPDSNG_PVT dependencies on PO_COMM_FPDSNG_PVT

Line 1: PACKAGE BODY PO_COMM_FPDSNG_PVT AS

1: PACKAGE BODY PO_COMM_FPDSNG_PVT AS
2: /* $Header: POXFPDSNGB.pls 120.4 2008/03/06 07:26:30 lgoyal noship $ */
3:
4: --Use proper debug logging
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 7: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.PO_COMM_FPDSNG_PVT.';

3:
4: --Use proper debug logging
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.PO_COMM_FPDSNG_PVT.';
8:
9: g_document_id NUMBER;
10: g_revision_num NUMBER;
11: g_release_id NUMBER;

Line 104: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST';

100:
101: BEGIN
102:
103: l_progress := '000';
104: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST';
105: IF (g_po_wf_debug = 'Y') THEN
106: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
107: END IF;
108:

Line 150: x_progress := 'In PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST.';

146: IF (g_po_wf_debug = 'Y') THEN
147: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,'L_FPDSNG_FLAG::' || l_fpdsng_flag);
148: END IF;
149:
150: x_progress := 'In PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST.';
151: IF (g_po_wf_debug = 'Y') THEN
152: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
153: END IF;
154:

Line 176: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST :launching the java concurrent program ';

172: END IF;
173:
174: END IF;
175:
176: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST :launching the java concurrent program ';
177: IF (g_po_wf_debug = 'Y') THEN
178: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
179: END IF;
180:

Line 207: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST : Request id is '|| l_request_id;

203: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
204: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
205: NULL, NULL);
206:
207: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST : Request id is '|| l_request_id;
208: IF (g_po_wf_debug = 'Y') THEN
209: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
210: END IF;
211:

Line 217: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST : In Exception handler';

213:
214: EXCEPTION
215:
216: WHEN OTHERS THEN
217: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST : In Exception handler';
218: IF (g_po_wf_debug = 'Y') THEN
219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
220: END IF;
221: wf_core.context('PO_COMM_FPDSNG_PVT','SUBMIT_REQUEST',x_progress);

Line 221: wf_core.context('PO_COMM_FPDSNG_PVT','SUBMIT_REQUEST',x_progress);

217: x_progress := 'PO_COMM_FPDSNG_PVT.SUBMIT_REQUEST : In Exception handler';
218: IF (g_po_wf_debug = 'Y') THEN
219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
220: END IF;
221: wf_core.context('PO_COMM_FPDSNG_PVT','SUBMIT_REQUEST',x_progress);
222: RAISE;
223:
224: END submit_request;
225:

Line 281: PO_COMM_FPDSNG_PVT.g_document_id := p_document_id;

277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );
278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );
279: END IF;
280:
281: PO_COMM_FPDSNG_PVT.g_document_id := p_document_id;
282:
283: l_progress:='001';
284: SELECT TYPE_LOOKUP_CODE into l_doc_type
285: FROM po_headers_all ph

Line 291: SELECT revision_num INTO PO_COMM_FPDSNG_PVT.g_revision_num

287:
288: IF p_revision_num < 0 THEN
289: l_progress:='002';
290:
291: SELECT revision_num INTO PO_COMM_FPDSNG_PVT.g_revision_num
292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;
293:
294: ELSE
295: l_progress:='003';

Line 292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;

288: IF p_revision_num < 0 THEN
289: l_progress:='002';
290:
291: SELECT revision_num INTO PO_COMM_FPDSNG_PVT.g_revision_num
292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;
293:
294: ELSE
295: l_progress:='003';
296: PO_COMM_FPDSNG_PVT.g_revision_num := p_revision_num;

Line 296: PO_COMM_FPDSNG_PVT.g_revision_num := p_revision_num;

292: FROM po_headers_all WHERE po_header_id = PO_COMM_FPDSNG_PVT.g_document_id;
293:
294: ELSE
295: l_progress:='003';
296: PO_COMM_FPDSNG_PVT.g_revision_num := p_revision_num;
297: END IF;
298:
299: l_progress:='004';
300: PO_COMM_FPDSNG_PVT.g_release_id := null;

Line 300: PO_COMM_FPDSNG_PVT.g_release_id := null;

296: PO_COMM_FPDSNG_PVT.g_revision_num := p_revision_num;
297: END IF;
298:
299: l_progress:='004';
300: PO_COMM_FPDSNG_PVT.g_release_id := null;
301:
302: IF l_doc_type <> 'STANDARD' THEN
303:
304: /* If Release Num is not Specified for a Blanket Purchase Agreement */

Line 312: SELECT po_release_id INTO PO_COMM_FPDSNG_PVT.g_release_id

308: END IF;
309:
310: BEGIN
311: l_progress:='005';
312: SELECT po_release_id INTO PO_COMM_FPDSNG_PVT.g_release_id
313: FROM po_releases_all
314: WHERE po_header_id=p_document_id AND
315: release_num= p_release_num;
316: EXCEPTION

Line 323: PO_COMM_FPDSNG_PVT.g_release_id := NULL;

319: raise_application_error (-20001,'Invalid Release Number.');
320: END;
321:
322: ELSE
323: PO_COMM_FPDSNG_PVT.g_release_id := NULL;
324: END IF;
325:
326: l_progress:='006';
327: IF g_debug_stmt THEN

Line 328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );

324: END IF;
325:
326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:

Line 329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );

325:
326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:
333: l_progress:='007';

Line 330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );

326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:
333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,

Line 334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,

330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:
333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,
335: PO_COMM_FPDSNG_PVT.getDocumentId(),PO_COMM_FPDSNG_PVT.getReleaseId()) PIID,
336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
337: FROM dual';
338:

Line 335: PO_COMM_FPDSNG_PVT.getDocumentId(),PO_COMM_FPDSNG_PVT.getReleaseId()) PIID,

331: END IF;
332:
333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,
335: PO_COMM_FPDSNG_PVT.getDocumentId(),PO_COMM_FPDSNG_PVT.getReleaseId()) PIID,
336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
337: FROM dual';
338:
339: l_progress:='008';

Line 336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber

332:
333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,
335: PO_COMM_FPDSNG_PVT.getDocumentId(),PO_COMM_FPDSNG_PVT.getReleaseId()) PIID,
336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
337: FROM dual';
338:
339: l_progress:='008';
340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,

Line 340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,

336: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
337: FROM dual';
338:
339: l_progress:='008';
340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,
341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
342: from dual';
343:
344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

Line 341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber

337: FROM dual';
338:
339: l_progress:='008';
340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,
341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
342: from dual';
343:
344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
345: l_progress:='009';

Line 344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

340: l_refidvidQuery := 'SELECT PO_COMM_FPDSNG_PVT.getDocumentId() PIID,
341: PO_COMM_FPDSNG_PVT.getRevisionNum modNumber
342: from dual';
343:
344: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
345: l_progress:='009';
346: l_ContractDatesQuery :=' SELECT poh.start_date effectiveDate,
347: poh.end_date lastDateToOrder
348: FROM po_headers_all poh

Line 350: poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';

346: l_ContractDatesQuery :=' SELECT poh.start_date effectiveDate,
347: poh.end_date lastDateToOrder
348: FROM po_headers_all poh
349: WHERE
350: poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
351: END IF;
352:
353: --releases
354:

Line 355: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

351: END IF;
352:
353: --releases
354:
355: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
356:
357: l_progress:='010';
358: l_dollarValueQuery:='SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
359: po_core_s.get_total(''R'', PO_COMM_FPDSNG_PVT.getReleaseId()) baseAndExcercisedOptionsValue

Line 359: po_core_s.get_total(''R'', PO_COMM_FPDSNG_PVT.getReleaseId()) baseAndExcercisedOptionsValue

355: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
356:
357: l_progress:='010';
358: l_dollarValueQuery:='SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
359: po_core_s.get_total(''R'', PO_COMM_FPDSNG_PVT.getReleaseId()) baseAndExcercisedOptionsValue
360: from po_distributions_all pod,
361: po_releases_all por where por.po_release_id=pod.po_release_id
362: and por.po_release_id =PO_COMM_FPDSNG_PVT.getReleaseId()';
363:

Line 362: and por.po_release_id =PO_COMM_FPDSNG_PVT.getReleaseId()';

358: l_dollarValueQuery:='SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
359: po_core_s.get_total(''R'', PO_COMM_FPDSNG_PVT.getReleaseId()) baseAndExcercisedOptionsValue
360: from po_distributions_all pod,
361: po_releases_all por where por.po_release_id=pod.po_release_id
362: and por.po_release_id =PO_COMM_FPDSNG_PVT.getReleaseId()';
363:
364: ELSE
365: l_progress:='011';
366: l_dollarValueQuery := ' SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,

Line 367: po_core_s.get_total(''H'', PO_COMM_FPDSNG_PVT.getDocumentId()) baseAndExcercisedOptionsValue

363:
364: ELSE
365: l_progress:='011';
366: l_dollarValueQuery := ' SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
367: po_core_s.get_total(''H'', PO_COMM_FPDSNG_PVT.getDocumentId()) baseAndExcercisedOptionsValue
368: from po_distributions_all pod,
369: po_headers_all poh where poh.po_header_id=pod.po_header_id
370: and poh.po_header_id =PO_COMM_FPDSNG_PVT.getDocumentId()';
371:

Line 370: and poh.po_header_id =PO_COMM_FPDSNG_PVT.getDocumentId()';

366: l_dollarValueQuery := ' SELECT sum(NVL(encumbered_amount,0)) obligatedAmount,
367: po_core_s.get_total(''H'', PO_COMM_FPDSNG_PVT.getDocumentId()) baseAndExcercisedOptionsValue
368: from po_distributions_all pod,
369: po_headers_all poh where poh.po_header_id=pod.po_header_id
370: and poh.po_header_id =PO_COMM_FPDSNG_PVT.getDocumentId()';
371:
372: END IF;
373:
374: l_progress:='012';

Line 378: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';

374: l_progress:='012';
375: l_contractMarketingQuery := 'SELECT pov.email_address emailAddress
376: FROM po_vendor_sites_all pov, po_headers_all poh
377: WHERE pov.vendor_site_id= poh.vendor_site_id
378: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
379:
380: l_progress:='013';
381: l_contractDataQuery := 'SELECT
382: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),null,PO_COMM_FPDSNG_PVT.getDocumentId(),

Line 382: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),null,PO_COMM_FPDSNG_PVT.getDocumentId(),

378: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
379:
380: l_progress:='013';
381: l_contractDataQuery := 'SELECT
382: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),null,PO_COMM_FPDSNG_PVT.getDocumentId(),
383: PO_COMM_FPDSNG_PVT.getReleaseId()) solicitationID,
384: poh.comments descOfContractRequirement,
385: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,
386: Decode(

Line 383: PO_COMM_FPDSNG_PVT.getReleaseId()) solicitationID,

379:
380: l_progress:='013';
381: l_contractDataQuery := 'SELECT
382: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),null,PO_COMM_FPDSNG_PVT.getDocumentId(),
383: PO_COMM_FPDSNG_PVT.getReleaseId()) solicitationID,
384: poh.comments descOfContractRequirement,
385: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,
386: Decode(
387: Greatest((sysdate - poh.creation_date), 366),

Line 385: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,

381: l_contractDataQuery := 'SELECT
382: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),null,PO_COMM_FPDSNG_PVT.getDocumentId(),
383: PO_COMM_FPDSNG_PVT.getReleaseId()) solicitationID,
384: poh.comments descOfContractRequirement,
385: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,
386: Decode(
387: Greatest((sysdate - poh.creation_date), 366),
388: 366,''false'',''true''),
389: Decode(

Line 393: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,poh.pcard_id,por.pcard_id) purchaseCardAsPaymentMethod

389: Decode(
390: Greatest((poh.end_date - poh.start_date), 366),
391: 366,''false'',''true'')
392: ) multiYearContract,
393: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,poh.pcard_id,por.pcard_id) purchaseCardAsPaymentMethod
394: FROM po_headers_all poh, po_releases_all por
395: WHERE poh.po_header_id = por.po_header_id (+)
396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()
397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;

Line 396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()

392: ) multiYearContract,
393: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,poh.pcard_id,por.pcard_id) purchaseCardAsPaymentMethod
394: FROM po_headers_all poh, po_releases_all por
395: WHERE poh.po_header_id = por.po_header_id (+)
396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()
397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;
398:
399: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) is not null then
400: --for releases

Line 397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;

393: decode(PO_COMM_FPDSNG_PVT.getReleaseId(),NULL,poh.pcard_id,por.pcard_id) purchaseCardAsPaymentMethod
394: FROM po_headers_all poh, po_releases_all por
395: WHERE poh.po_header_id = por.po_header_id (+)
396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()
397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;
398:
399: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) is not null then
400: --for releases
401: /* Bug 6864044. Added Outer join condition so that query return

Line 399: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) is not null then

395: WHERE poh.po_header_id = por.po_header_id (+)
396: AND poh.po_header_id = PO_COMM_FPDSNG_PVT.getDocumentId()
397: AND por.po_release_id (+)= PO_COMM_FPDSNG_PVT.getReleaseId()' ;
398:
399: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) is not null then
400: --for releases
401: /* Bug 6864044. Added Outer join condition so that query return
402: the Category Detail even if duns_number does not match. */
403: l_progress:='014';

Line 414: and por.po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId()

410: poh.vendor_site_id = pvs.vendor_site_id
411: and pvs.duns_number = fcv.duns (+)
412: and mck.category_id = pol.category_id
413: and poh.po_header_id = pol.po_header_id
414: and por.po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId()
415: and poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
416:
417: ELSE
418: --for standard PO

Line 415: and poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';

411: and pvs.duns_number = fcv.duns (+)
412: and mck.category_id = pol.category_id
413: and poh.po_header_id = pol.po_header_id
414: and por.po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId()
415: and poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
416:
417: ELSE
418: --for standard PO
419: /* Bug 6864044. Added Outer join condition so that query return

Line 430: and poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';

426: WHERE poh.vendor_site_id = pvs.vendor_site_id
427: and pvs.duns_number = fcv.duns (+)
428: and mck.category_id = pol.category_id
429: and poh.po_header_id = pol.po_header_id
430: and poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
431:
432: END IF;
433:
434: l_progress:='016';

Line 438: AND poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';

434: l_progress:='016';
435: l_vendorHeaderQuery := 'SELECT vendor_name vendorName
436: FROM po_vendors pov, po_headers_all poh
437: WHERE pov.vendor_id= poh.vendor_id
438: AND poh.po_header_id= PO_COMM_FPDSNG_PVT.getDocumentId()';
439:
440: l_progress:='017';
441: l_vendorLocQuery := 'SELECT vendor_site_code VendorSiteCode ,
442: address_line1 streetAddress, address_line2 streetAddress2,

Line 448: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';

444: country countryCode, duns_number DUNSNumber,
445: (area_code) || phone phoneNo, (fax_area_code) || pov.fax faxNo
446: FROM po_vendor_sites_all pov, po_headers_all poh
447: WHERE pov.vendor_site_id = poh.vendor_site_id
448: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
449:
450:
451: IF g_debug_stmt THEN
452: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Queries Created after', l_progress);

Line 474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);
472:
473:
474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
475: /*relevantContractDates */
476: l_progress:='020';
477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');

Line 564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

560: l_progress:='032';
561: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');
562:
563:
564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
565: l_progress:='033';
566: IF dbms_lob.getlength(l_ContractDates) >0 THEN
567: l_variablePosition := DBMS_LOB.INSTR(l_ContractDates,'>');
568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);

Line 642: PO_COMM_FPDSNG_PVT.g_revision_num, --Revision Num

638: l_progress:='044';
639: l_file_name := getFPDSNGFileName(l_doc_type, --p_document_type
640: l_org_id, --Org Id
641: p_document_id, --Header_id
642: PO_COMM_FPDSNG_PVT.g_revision_num, --Revision Num
643: p_release_num, --Release Num
644: l_language); --Language Code
645:
646: IF g_debug_stmt THEN

Line 657: PO_COMM_FPDSNG_PVT.g_revision_num,

653:
654: --Store it as BLOB attachment in DB
655: l_progress:='046';
656: Store_Blob( p_document_id,
657: PO_COMM_FPDSNG_PVT.g_revision_num,
658: l_doc_type, --p_document_type
659: l_file_name,
660: blob_result, --blob
661: l_media_id);

Line 733: WHERE po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId();

729: IF p_release_num < 0 THEN
730: l_progress := '004';
731: SELECT release_num INTO l_release_num
732: FROM po_releases_all
733: WHERE po_release_id = PO_COMM_FPDSNG_PVT.getReleaseId();
734: ELSE
735: l_progress := '005';
736: l_release_num := p_release_num;
737: END IF;

Line 1187: END PO_COMM_FPDSNG_PVT;

1183: END IF;
1184: RAISE;
1185: END Communicate;
1186:
1187: END PO_COMM_FPDSNG_PVT;