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.GMF_GET_MAPPINGS dependencies on GL_ACCT_MST

Line 121: X_acct_id gl_acct_mst.acct_id%TYPE;

117: X_sqlwhere6 VARCHAR2(2000);
118: X_sqlcolumns VARCHAR2(2000);
119: X_sqlcolumns1 VARCHAR2(2000);
120: X_sqlcolumns2 VARCHAR2(2000);
121: X_acct_id gl_acct_mst.acct_id%TYPE;
122: X_sqlordby VARCHAR2(1000);
123: X_tmp1 NUMBER(10);
124: X_cursor_handle INTEGER;
125: i INTEGER DEFAULT 0;

Line 601: v_acct_no gl_acct_mst.acct_no%TYPE := NULL;

597:
598: PROCEDURE get_of_seg(p_co_code IN VARCHAR2, p_acct_id NUMBER, p_acctg_unit_id IN NUMBER, p_of_seg IN OUT NOCOPY A_segment, rc IN OUT NOCOPY NUMBER)
599: IS
600: v_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;
601: v_acct_no gl_acct_mst.acct_no%TYPE := NULL;
602: v_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
603: BEGIN
604: rc := 0;
605: SELECT acctg_unit_no INTO v_acctg_unit_no

Line 609: FROM gl_acct_mst

605: SELECT acctg_unit_no INTO v_acctg_unit_no
606: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;
607:
608: SELECT acct_no INTO v_acct_no
609: FROM gl_acct_mst
610: WHERE acct_id = p_acct_id;
611:
612: SELECT segment_delimiter INTO v_segment_delimiter
613: FROM gl_plcy_mst

Line 695: X_acct_id gl_acct_mst.acct_id%TYPE;

691: X_sqlwhere7 VARCHAR2(2000);
692: X_sqlcolumns VARCHAR2(2000);
693: X_sqlcolumns1 VARCHAR2(2000);
694: X_sqlcolumns2 VARCHAR2(2000);
695: X_acct_id gl_acct_mst.acct_id%TYPE;
696: X_sqlordby VARCHAR2(1000);
697: X_tmp1 NUMBER(10);
698: X_cursor_handle INTEGER;
699: i INTEGER DEFAULT 0;

Line 1105: l_account_value gl_acct_mst.acct_no%TYPE;

1101: FROM gl_plcy_seg
1102: WHERE co_code = pco_code
1103: AND delete_mark = 0;
1104:
1105: l_account_value gl_acct_mst.acct_no%TYPE;
1106: l_start NUMBER DEFAULT 1;
1107: l_end NUMBER DEFAULT 0;
1108: l_deli_process NUMBER DEFAULT 0;
1109: l_delimiter_cnt NUMBER DEFAULT 0;

Line 1113: l_acct_no gl_acct_mst.acct_no%TYPE;

1109: l_delimiter_cnt NUMBER DEFAULT 0;
1110: l_count NUMBER DEFAULT 0;
1111: l_opm_seg_values my_opm_seg_values;
1112: l_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
1113: l_acct_no gl_acct_mst.acct_no%TYPE;
1114: BEGIN
1115:
1116: -- Fetch Segment delimiter
1117: OPEN Cur_get_seg_deli(p_co_code);

Line 1211: l_opm_acct_id gl_acct_mst.acct_id%TYPE;

1207:
1208: l_chart_of_accounts_id number(15);
1209: l_opm_company sy_orgn_mst.orgn_code%TYPE;
1210: l_opm_accu_id gl_accu_mst.acctg_unit_id%TYPE;
1211: l_opm_acct_id gl_acct_mst.acct_id%TYPE;
1212:
1213: l_opm_delimiter gl_plcy_mst.segment_delimiter%TYPE;
1214: l_n_accu NUMBER(5);
1215: l_n_acct NUMBER(5);

Line 1279: p_acct_no gl_acct_mst.acct_no%TYPE

1275: AND acctg_unit_no = p_acctg_unit_no;
1276:
1277: CURSOR cur_opm_acct(
1278: p_co_code sy_orgn_mst.orgn_code%TYPE,
1279: p_acct_no gl_acct_mst.acct_no%TYPE
1280: )
1281: IS
1282: SELECT
1283: acct_id, acct_desc, quantity_um

Line 1285: gl_acct_mst

1281: IS
1282: SELECT
1283: acct_id, acct_desc, quantity_um
1284: FROM
1285: gl_acct_mst
1286: WHERE
1287: co_code = p_co_code
1288: AND acct_no = p_acct_no;
1289:

Line 1310: l_acct_uom gl_acct_mst.quantity_um%TYPE := null;

1306: l_statuscode NUMBER DEFAULT 0;
1307: l_segmentuom gl_stat_account_uom.unit_of_measure%TYPE;
1308:
1309: -- RS B2485772
1310: l_acct_uom gl_acct_mst.quantity_um%TYPE := null;
1311: l_opm_db_acct_desc gl_acct_mst.acct_desc%TYPE;
1312: l_opm_db_acct_uom gl_acct_mst.quantity_um%TYPE;
1313: l_opm_db_accu_desc gl_accu_mst.acctg_unit_desc%TYPE;
1314:

Line 1311: l_opm_db_acct_desc gl_acct_mst.acct_desc%TYPE;

1307: l_segmentuom gl_stat_account_uom.unit_of_measure%TYPE;
1308:
1309: -- RS B2485772
1310: l_acct_uom gl_acct_mst.quantity_um%TYPE := null;
1311: l_opm_db_acct_desc gl_acct_mst.acct_desc%TYPE;
1312: l_opm_db_acct_uom gl_acct_mst.quantity_um%TYPE;
1313: l_opm_db_accu_desc gl_accu_mst.acctg_unit_desc%TYPE;
1314:
1315: BEGIN

Line 1312: l_opm_db_acct_uom gl_acct_mst.quantity_um%TYPE;

1308:
1309: -- RS B2485772
1310: l_acct_uom gl_acct_mst.quantity_um%TYPE := null;
1311: l_opm_db_acct_desc gl_acct_mst.acct_desc%TYPE;
1312: l_opm_db_acct_uom gl_acct_mst.quantity_um%TYPE;
1313: l_opm_db_accu_desc gl_accu_mst.acctg_unit_desc%TYPE;
1314:
1315: BEGIN
1316:

Line 1558: INSERT INTO gl_acct_mst(

1554: INTO l_opm_acct_id
1555: FROM dual;
1556:
1557: -- insert the account into OPM
1558: INSERT INTO gl_acct_mst(
1559: ACCT_ID,
1560: ACCT_NO,
1561: CO_CODE,
1562: ACCT_DESC,

Line 1614: UPDATE gl_acct_mst

1610: (l_opm_db_acct_desc <> l_opm_acct_desc) OR
1611: (l_opm_db_acct_desc IS NOT NULL AND l_opm_acct_desc IS NULL) OR
1612: (l_opm_db_acct_desc IS NULL AND l_opm_acct_desc IS NOT NULL) )
1613: THEN
1614: UPDATE gl_acct_mst
1615: SET
1616: acct_desc = l_opm_acct_desc,
1617: quantity_um = l_acct_uom
1618: WHERE