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.JAI_PO_WF_UTIL_PUB dependencies on JAI_PO_WF_UTIL_PUB

Line 1: PACKAGE BODY JAI_PO_WF_UTIL_PUB AS

1: PACKAGE BODY JAI_PO_WF_UTIL_PUB AS
2: /* $Header: jainpowfut.plb 120.7 2010/12/28 18:17:36 erma noship $ */
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 553: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE

549: , 'Enter procedure'
550: );
551: END IF; --l_proc_level>=l_dbg_level
552:
553: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE
554: THEN
555: --calculate requsition tax
556: OPEN Get_Req_tax_Cur;
557: LOOP

Line 605: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE

601: --dbms_output.put_line ( 'ln_total_nr_tax_amount ='||ln_total_nr_tax_amount);
602: END LOOP;
603:
604: CLOSE Get_Req_tax_Cur;
605: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE
606: THEN
607: --calculate PO tax
608: OPEN Get_Po_tax_Cur;
609: LOOP

Line 649: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE

645: --dbms_output.put_line ( 'ln_total_nr_tax_amount ='||ln_total_nr_tax_amount);
646: END LOOP;
647:
648: CLOSE Get_Po_tax_Cur;
649: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE
650: THEN
651: --Get po header id
652: OPEN Get_Po_Header_Id_Cur;
653: FETCH Get_Po_Header_Id_Cur

Line 699: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)

695: --dbms_output.put_line ( 'ln_total_nr_tax_amount ='||ln_total_nr_tax_amount);
696: END LOOP;
697:
698: CLOSE Get_Rel_tax_Cur;
699: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)
700:
701: --set the values to output parameters
702: xn_excl_tax_amount := NVL(ln_total_tax_amount,0);
703: xn_excl_nr_tax_amount := NVL(ln_total_nr_tax_amount,0);

Line 921: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE

917: , 'Enter procedure'
918: );
919: END IF; --l_proc_level>=l_dbg_level
920:
921: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE
922: THEN
923: OPEN Get_New_Old_Quantity_Cur;
924: LOOP
925: FETCH Get_New_Old_Quantity_Cur

Line 1018: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)

1014: ln_new_total_nr_tax_amount := ln_new_nr_tax_amount + ln_new_total_nr_tax_amount;
1015: END LOOP;
1016:
1017: CLOSE Get_New_Old_Quantity_Cur;
1018: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)
1019:
1020: --set the values to output parameters
1021: xn_excl_tax_amount := NVL(ln_new_total_tax_amount,0);
1022: xn_excl_nr_tax_amount := NVL(ln_new_total_nr_tax_amount,0);

Line 1207: IF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)

1203: , 'Enter procedure'
1204: );
1205: END IF; --l_proc_level>=l_dbg_level
1206:
1207: IF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)
1208: THEN
1209: --Requistion
1210:
1211: --Modified by Eric on 2009-Aug-02 for bug 8744317,begin

Line 1220: ELSIF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE)

1216: ------------------------------------------------------------------------------
1217: --Modified by Eric on 2009-Aug-02 for bug 8744317,end
1218:
1219:
1220: ELSIF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE)
1221: THEN
1222: --PO,PA
1223:
1224: --Modified by Eric on 2009-Aug-02 for bug 8744317,begin

Line 1232: ELSIF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE)

1228: ' JAINPO_CALLING_FORM=POXSTNOT'; -- replace "POXSTNOT" with POXSTNOT
1229: ------------------------------------------------------------------------------
1230: --Modified by Eric on 2009-Aug-02 for bug 8744317,end
1231:
1232: ELSIF (pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE)
1233: THEN
1234: --Release
1235:
1236: --Modified by Eric on 2009-Aug-02 for bug 8744317,begin

Line 1375: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE

1371: END IF; --l_proc_level>=l_dbg_level
1372:
1373:
1374:
1375: IF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE
1376: THEN
1377: OPEN Get_Req_tax_Cur;
1378: LOOP
1379: FETCH Get_Req_tax_Cur

Line 1418: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE

1414:
1415: END LOOP;
1416:
1417: CLOSE Get_Req_tax_Cur;
1418: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE
1419: THEN
1420:
1421:
1422: OPEN Get_Po_tax_Cur;

Line 1458: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE

1454: --dbms_output.put_line ( 'ln_total_nr_tax_amount ='||ln_total_nr_tax_amount);
1455: END LOOP;
1456:
1457: CLOSE Get_Po_tax_Cur;
1458: ELSIF pv_document_type= JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE
1459: THEN
1460: OPEN Get_Rel_tax_Cur;
1461: LOOP
1462: FETCH Get_Rel_tax_Cur

Line 1493: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)

1489: -- Modified by Eric Ma for bug10426971 on 28-Dec-2010,End
1490:
1491: END LOOP;
1492: CLOSE Get_Rel_tax_Cur;
1493: END IF;--(p_document_type=JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)
1494:
1495: --logging for debug
1496: IF (ln_proc_level >= ln_dbg_level)
1497: THEN

Line 1552: IF ( p_document_type = JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE )

1548: d_progress VARCHAR2(30);
1549:
1550: BEGIN
1551:
1552: IF ( p_document_type = JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE )
1553: THEN
1554: INSERT
1555: INTO PO_SESSION_GT(
1556: key

Line 1567: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE

1563: , char1
1564: , char2
1565: )
1566: SELECT x_session_gt_key
1567: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_PO_DOC_TYPE
1568: , poh.po_header_id
1569: , NULL
1570: , pol.po_line_id
1571: , poll.line_location_id)

Line 1601: ELSIF (p_document_type = JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)

1597: ((poh.type_lookup_code = 'PLANNED') AND
1598: (poll.shipment_type = 'PLANNED')))
1599: AND pod.distribution_num=1;
1600:
1601: ELSIF (p_document_type = JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE)
1602: THEN
1603: d_progress := 30;
1604:
1605: INSERT

Line 1618: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE

1614: , char1
1615: , char2
1616: )
1617: SELECT x_session_gt_key
1618: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE
1619: , porl.requisition_header_id
1620: , NULL
1621: , porl.requisition_line_id
1622: , NULL )

Line 1638: ELSIF (p_document_type = JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE)

1634: AND NVL(porl.cancel_flag, 'N') = 'N'
1635: AND NVL(porl.modified_by_agent_flag, 'N') = 'N'
1636: AND pord.distribution_num=1;
1637:
1638: ELSIF (p_document_type = JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE)
1639: THEN
1640: d_progress := 40;
1641: INSERT
1642: INTO PO_SESSION_GT(

Line 1654: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE

1650: , char1
1651: , char2
1652: )
1653: SELECT x_session_gt_key
1654: , GET_POREQ_TAX( JAI_PO_WF_UTIL_PUB.G_REL_DOC_TYPE
1655: , pod.po_header_id
1656: , poa.release_num
1657: , pol.po_line_id
1658: , poll.line_location_id

Line 1681: END JAI_PO_WF_UTIL_PUB;

1677: END IF;
1678:
1679: END Populate_Session_GT;
1680:
1681: END JAI_PO_WF_UTIL_PUB;