APPS.GMF_GET_MAPPINGS dependencies on GL_ACCU_MST

Line 600: v_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;

596: REM gemms might be the 3rd segment in oracle financials. */
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;

Line 606: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;

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
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;

Line 1210: l_opm_accu_id gl_accu_mst.acctg_unit_id%TYPE;

1206: l_user_id NUMBER;
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);

Line 1266: p_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE

1262: AND segment_name = p_seg_name;
1263:
1264: CURSOR cur_opm_accu(
1265: p_co_code sy_orgn_mst.orgn_code%TYPE,
1266: p_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE
1267: )
1268: IS
1269: SELECT
1270: acctg_unit_id, acctg_unit_desc

Line 1272: gl_accu_mst

1268: IS
1269: SELECT
1270: acctg_unit_id, acctg_unit_desc
1271: FROM
1272: gl_accu_mst
1273: WHERE
1274: co_code = p_co_code
1275: AND acctg_unit_no = p_acctg_unit_no;
1276:

Line 1313: l_opm_db_accu_desc gl_accu_mst.acctg_unit_desc%TYPE;

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:
1317: l_opm_account_err.acctg_unit_id := -1;

Line 1491: INSERT INTO gl_accu_mst(

1487: INTO l_opm_accu_id
1488: FROM dual;
1489:
1490: -- insert the accounting unit into OPM
1491: INSERT INTO gl_accu_mst(
1492: ACCTG_UNIT_ID,
1493: ACCTG_UNIT_NO,
1494: CO_CODE,
1495: ACCTG_UNIT_DESC,

Line 1530: UPDATE gl_accu_mst

1526: IF( (l_opm_db_accu_desc <> l_opm_accu_desc) OR
1527: (l_opm_db_accu_desc IS NULL AND l_opm_accu_desc IS NOT NULL) OR
1528: (l_opm_db_accu_desc IS NOT NULL AND l_opm_accu_desc IS NULL) )
1529: THEN
1530: UPDATE gl_accu_mst
1531: SET
1532: acctg_unit_desc = l_opm_accu_desc
1533: WHERE
1534: co_code = l_opm_company AND