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.GML_PO_GLDIST dependencies on GL_PLCY_MST

Line 422: FROM sy_orgn_mst orgn, gl_plcy_mst plcy

418: X_co_code VARCHAR2(5);
419:
420: CURSOR Cur_base_curr IS
421: SELECT plcy.base_currency_code
422: FROM sy_orgn_mst orgn, gl_plcy_mst plcy
423: WHERE orgn.orgn_code = V_orgn_code and orgn.co_code = plcy.co_code;
424:
425: CURSOR Cur_orgn_mst IS
426: SELECT co_code

Line 1603: CURSOR Cur_gl_plcy_mstc1 IS

1599: X_syarg27 NUMBER(15) DEFAULT 0; /* ERROR_STATUS */
1600: X_rvar NUMBER(10) DEFAULT 0;
1601:
1602:
1603: CURSOR Cur_gl_plcy_mstc1 IS
1604: SELECT set_of_books_name
1605: FROM gl_plcy_mst
1606: WHERE co_code = V_co_code;
1607: BEGIN

Line 1605: FROM gl_plcy_mst

1601:
1602:
1603: CURSOR Cur_gl_plcy_mstc1 IS
1604: SELECT set_of_books_name
1605: FROM gl_plcy_mst
1606: WHERE co_code = V_co_code;
1607: BEGIN
1608: /* Select set of books name from fiscal policy.*/
1609: /*This function will be called from short_name procedure.*/

Line 1612: OPEN Cur_gl_plcy_mstc1;

1608: /* Select set of books name from fiscal policy.*/
1609: /*This function will be called from short_name procedure.*/
1610:
1611: IF V_co_code IS NOT NULL THEN
1612: OPEN Cur_gl_plcy_mstc1;
1613: FETCH Cur_gl_plcy_mstc1 INTO P_sobname;
1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN
1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);

Line 1613: FETCH Cur_gl_plcy_mstc1 INTO P_sobname;

1609: /*This function will be called from short_name procedure.*/
1610:
1611: IF V_co_code IS NOT NULL THEN
1612: OPEN Cur_gl_plcy_mstc1;
1613: FETCH Cur_gl_plcy_mstc1 INTO P_sobname;
1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN
1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);
1617: END IF;

Line 1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN

1610:
1611: IF V_co_code IS NOT NULL THEN
1612: OPEN Cur_gl_plcy_mstc1;
1613: FETCH Cur_gl_plcy_mstc1 INTO P_sobname;
1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN
1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);
1617: END IF;
1618: IF Cur_gl_plcy_mstc1%ISOPEN THEN

Line 1615: CLOSE Cur_gl_plcy_mstc1;

1611: IF V_co_code IS NOT NULL THEN
1612: OPEN Cur_gl_plcy_mstc1;
1613: FETCH Cur_gl_plcy_mstc1 INTO P_sobname;
1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN
1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);
1617: END IF;
1618: IF Cur_gl_plcy_mstc1%ISOPEN THEN
1619: CLOSE Cur_gl_plcy_mstc1;

Line 1618: IF Cur_gl_plcy_mstc1%ISOPEN THEN

1614: IF Cur_gl_plcy_mstc1%NOTFOUND THEN
1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);
1617: END IF;
1618: IF Cur_gl_plcy_mstc1%ISOPEN THEN
1619: CLOSE Cur_gl_plcy_mstc1;
1620: END IF;
1621: IF P_sobname IS NULL THEN
1622: RETURN (-2);

Line 1619: CLOSE Cur_gl_plcy_mstc1;

1615: CLOSE Cur_gl_plcy_mstc1;
1616: RETURN (-1);
1617: END IF;
1618: IF Cur_gl_plcy_mstc1%ISOPEN THEN
1619: CLOSE Cur_gl_plcy_mstc1;
1620: END IF;
1621: IF P_sobname IS NULL THEN
1622: RETURN (-2);
1623: END IF;

Line 1815: v_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;

1811: v_validation_date DATE;
1812: v_segment_count NUMBER;
1813: v_of_seg fnd_flex_ext.SegmentArray;
1814: x BOOLEAN;
1815: v_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
1816:
1817:
1818: Cursor get_chart_id is
1819: select chart_of_accounts_id

Line 1820: from gl_plcy_mst,gl_sets_of_books

1816:
1817:
1818: Cursor get_chart_id is
1819: select chart_of_accounts_id
1820: from gl_plcy_mst,gl_sets_of_books
1821: where co_code = P_CO_CODE
1822: and name like set_of_books_name
1823: and set_of_books_id = sob_id;
1824:

Line 1838: FROM gl_plcy_mst

1834:
1835: /* SR dt 25-Jan-2001 B1530509 added select to get segment delimiter */
1836:
1837: SELECT segment_delimiter INTO v_segment_delimiter
1838: FROM gl_plcy_mst
1839: WHERE co_code = p_co_code
1840: AND delete_mark = 0;
1841:
1842: parse_account( p_co_code ,

Line 1923: gl_plcy_mst pm,

1919: --nvl(substrb(f.application_column_name,8),0) segment_ref, (Commented and added following for B#2376340)
1920: f.segment_num segment_ref,
1921: pm.segment_delimiter
1922: FROM gl_plcy_seg p,
1923: gl_plcy_mst pm,
1924: fnd_id_flex_segments f,
1925: gl_sets_of_books s
1926: WHERE p.co_code = v_co_code
1927: AND p.delete_mark = 0

Line 2033: gl_plcy_mst gpm,

2029: gl_accu_mst acu,
2030: gl_acct_mst act,
2031: po_dist_dtl pdd,
2032: po_distributions_all pod,
2033: gl_plcy_mst gpm,
2034: gl_sets_of_books gsob
2035: WHERE map.po_id = v_po_id
2036: AND map.line_id = v_line_id
2037: AND pod.po_header_id = map.po_header_id