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.GMLCOPPR dependencies on DUAL

Line 194: FROM DUAL;

190: v_prce_mst.attribute25 , v_prce_mst.attribute26,
191: v_prce_mst.attribute27 , v_prce_mst.attribute28,
192: v_prce_mst.attribute29 , v_prce_mst.attribute30,
193: v_prce_mst.attribute_category
194: FROM DUAL;
195:
196: /* Retrieve and Copy rows from op_prce_itm */
197: FOR v_prce_itm IN cur_prce_itm LOOP
198:

Line 285: FROM DUAL ;

281: v_prce_itm.attribute25 , v_prce_itm.attribute26 ,
282: v_prce_itm.attribute27 , v_prce_itm.attribute28 ,
283: v_prce_itm.attribute29 , v_prce_itm.attribute30 ,
284: v_prce_itm.attribute_category
285: FROM DUAL ;
286:
287: /* Now insert corresponding break rows into OP_PRCE_BRK */
288: FOR v_prce_brk IN cur_prce_brk(v_prce_itm.price_id) LOOP
289: X_breaktype_id := create_breaktype_id;

Line 322: FROM DUAL ;

318: P_user_id , NULL ,
319: v_prce_brk.delete_mark , 0 ,
320: X_breaktype_id , v_prce_brk.line_no ,
321: v_prce_brk.qty_breakpoint , v_prce_brk.value_breakpoint
322: FROM DUAL ;
323:
324: END LOOP; /* cur_price_brk */
325:
326: END LOOP; /* cur_prce_itm */

Line 539: FROM DUAL ;

535: v_cntr_hdr.attribute25 , v_cntr_hdr.attribute26 ,
536: v_cntr_hdr.attribute27 , v_cntr_hdr.attribute28 ,
537: v_cntr_hdr.attribute29 , v_cntr_hdr.attribute30 ,
538: v_cntr_hdr.attribute_category
539: FROM DUAL ;
540:
541: /* Retrieve and Copy rows from op_cntr_dtl */
542: FOR v_cntr_dtl IN cur_cntr_dtl LOOP
543:

Line 958: FROM DUAL ;

954: v_chrg_mst.attribute25 , v_chrg_mst.attribute26 ,
955: v_chrg_mst.attribute27 , v_chrg_mst.attribute28 ,
956: v_chrg_mst.attribute29 , v_chrg_mst.attribute30 ,
957: v_chrg_mst.attribute_category
958: FROM DUAL ;
959:
960: /* Now insert corresponding break rows into OP_CHRG_BRK */
961: FOR v_chrg_brk IN cur_chrg_brk(P_old_charge_id ) LOOP
962: X_chrgbreak_id := create_chargebreak_id;

Line 997: FROM DUAL ;

993: P_user_id , SYSDATE ,
994: sysdate , P_user_id ,
995: NULL , v_chrg_brk.delete_mark ,
996: 0 , v_chrg_brk.line_no
997: FROM DUAL ;
998:
999: END LOOP; /* cur_chrg_itm */
1000:
1001: /* Set err number to pricelist id if success */

Line 1228: FROM DUAL;

1224: DECODE (v_prce_eff.effectivity_type, 1, p_list_id,
1225: NULL ) ,
1226: DECODE (v_prce_eff.effectivity_type, 3, p_list_id,
1227: NULL )
1228: FROM DUAL;
1229:
1230: /* Set err number to pricelist id if success */
1231: P_err_num := X_priceff_id;
1232:

Line 1399: FROM DUAL ;

1395: v_chrg_itm.attribute25 , v_chrg_itm.attribute26 ,
1396: v_chrg_itm.attribute27 , v_chrg_itm.attribute28 ,
1397: v_chrg_itm.attribute29 , v_chrg_itm.attribute30 ,
1398: v_chrg_itm.attribute_category
1399: FROM DUAL ;
1400:
1401: /* Set err number to pricelist id if success */
1402: P_err_num := X_chargeitem_id;
1403:

Line 1455: FROM DUAL ;

1451: SELECT
1452: P_new_text_code , SYSDATE ,
1453: P_user_id , sysdate ,
1454: P_user_id , NULL
1455: FROM DUAL ;
1456:
1457: /* Retrieve and Copy rows from op_text_tbl */
1458: FOR v_text_tbl_tl IN cur_text_tbl_tl LOOP
1459:

Line 1489: FROM DUAL ;

1485: P_user_id ,
1486: SYSDATE ,
1487: SYSDATE ,
1488: NULL
1489: FROM DUAL ;
1490:
1491: END LOOP; /* cur_text_tbl_tl */
1492: END copy_text_record;
1493:

Line 1507: FROM SYS.DUAL;

1503: FUNCTION create_pricelist_id RETURN NUMBER IS
1504: /* Cursors */
1505: CURSOR Cur_new_pricelist_id IS
1506: SELECT GMO_PRICELIST_ID_S.NEXTVAL
1507: FROM SYS.DUAL;
1508:
1509: /* Scalars */
1510: X_ret NUMBER;
1511:

Line 1532: FROM SYS.DUAL;

1528: FUNCTION create_price_id RETURN NUMBER IS
1529: /* Cursors */
1530: CURSOR Cur_get_id IS
1531: SELECT gmo_price_id_s.NEXTVAL
1532: FROM SYS.DUAL;
1533:
1534: /* Scalars */
1535: X_ret NUMBER;
1536:

Line 1559: FROM SYS.DUAL;

1555: FUNCTION create_breaktype_id RETURN NUMBER IS
1556: /* Cursors */
1557: CURSOR Cur_get_id IS
1558: SELECT gmo_breaktype_id_s.NEXTVAL
1559: FROM SYS.DUAL;
1560:
1561: /* Scalars */
1562: X_ret NUMBER;
1563:

Line 1585: FROM SYS.DUAL;

1581: FUNCTION create_priceff_id RETURN NUMBER IS
1582: /* Cursors */
1583: CURSOR Cur_get_id IS
1584: SELECT gmo_priceff_id_s.NEXTVAL
1585: FROM SYS.DUAL;
1586:
1587: /* Scalars */
1588: X_ret NUMBER;
1589:

Line 1611: FROM SYS.DUAL;

1607: FUNCTION create_charge_id RETURN NUMBER IS
1608: /* Cursors */
1609: CURSOR Cur_new_charge_id IS
1610: SELECT GMO_CHARGE_ID_S.NEXTVAL
1611: FROM SYS.DUAL;
1612:
1613: /* Scalars */
1614: X_ret NUMBER;
1615:

Line 1636: FROM SYS.DUAL;

1632: FUNCTION create_chargeitem_id RETURN NUMBER IS
1633: /* Cursors */
1634: CURSOR Cur_get_id IS
1635: SELECT gem5_chargeitem_id_s.NEXTVAL
1636: FROM SYS.DUAL;
1637:
1638: /* Scalars */
1639: X_ret NUMBER;
1640:

Line 1663: FROM SYS.DUAL;

1659: FUNCTION create_chargebreak_id RETURN NUMBER IS
1660: /* Cursors */
1661: CURSOR Cur_get_id IS
1662: SELECT gmo_chrgbreak_id_s.NEXTVAL
1663: FROM SYS.DUAL;
1664:
1665: /* Scalars */
1666: X_ret NUMBER;
1667:

Line 1690: FROM SYS.DUAL;

1686: FUNCTION create_contract_id RETURN NUMBER IS
1687: /* Cursors */
1688: CURSOR Cur_new_contract_id IS
1689: SELECT GMO_CHARGE_ID_S.NEXTVAL
1690: FROM SYS.DUAL;
1691:
1692: /* Scalars */
1693: X_ret NUMBER;
1694:

Line 1716: FROM SYS.DUAL;

1712: FUNCTION create_text_code RETURN NUMBER IS
1713: /* Cursors */
1714: CURSOR Cur_text_code IS
1715: SELECT GEM5_TEXT_CODE_S.NEXTVAL
1716: FROM SYS.DUAL;
1717:
1718: /* Scalars */
1719: X_ret NUMBER;
1720: