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_VALIDATE_ACCOUNT dependencies on GL_ACCU_MST

Line 45: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,

41: ########################################################################*/
42:
43: PROCEDURE validate_segments(
44: p_co_code IN gl_plcy_mst.co_code%TYPE,
45: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,
46: p_acct_id IN gl_acct_mst.acct_id%TYPE,
47: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
48: p_acct_no IN gl_acct_mst.acct_no%TYPE,
49: p_create_combination IN VARCHAR2 DEFAULT 'N',

Line 47: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,

43: PROCEDURE validate_segments(
44: p_co_code IN gl_plcy_mst.co_code%TYPE,
45: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,
46: p_acct_id IN gl_acct_mst.acct_id%TYPE,
47: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
48: p_acct_no IN gl_acct_mst.acct_no%TYPE,
49: p_create_combination IN VARCHAR2 DEFAULT 'N',
50: x_ccid OUT NOCOPY NUMBER,
51: x_concat_seg OUT NOCOPY VARCHAR2,

Line 86: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;

82: AND plcy.co_code = p_co_code
83: AND flex.id_flex_code = 'GL#'
84: ;
85:
86: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;
87: l_acct_no gl_acct_mst.acct_no%TYPE;
88: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
89:
90: l_concat_segs VARCHAR2(4000);

Line 293: CURSOR acctg_unit (p_co_code gl_accu_mst.co_code%TYPE)

289: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL
290: )
291: IS
292:
293: CURSOR acctg_unit (p_co_code gl_accu_mst.co_code%TYPE)
294: IS
295: SELECT DISTINCT mst.acctg_unit_id, mst.acctg_unit_no -- Bug xxx
296: FROM gl_accu_mst mst, gl_accu_map map
297: WHERE mst.acctg_unit_id = map.acctg_unit_id

Line 296: FROM gl_accu_mst mst, gl_accu_map map

292:
293: CURSOR acctg_unit (p_co_code gl_accu_mst.co_code%TYPE)
294: IS
295: SELECT DISTINCT mst.acctg_unit_id, mst.acctg_unit_no -- Bug xxx
296: FROM gl_accu_mst mst, gl_accu_map map
297: WHERE mst.acctg_unit_id = map.acctg_unit_id
298: AND map.co_code = p_co_code
299: AND map.delete_mark = 0
300: AND mst.delete_mark = 0 ;

Line 309: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;

305: l_concat_segs VARCHAR2(4000);
306: l_msg_text VARCHAR2(2000);
307: l_index PLS_INTEGER DEFAULT 0; -- Bug xxx
308:
309: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;
310: l_acct_no gl_acct_mst.acct_no%TYPE;
311:
312: error_stack error_messages_RecType; -- will be used in concurrent program
313: empty_acct_combination acct_combination_TabType;

Line 393: # creates the accu and acct in OPM tables (gl_accu_mst and gl_acct_mst)

389: #
390: # Procedure to validate the accu and acct combination.
391: # If combination or accu/acct ids exits then returns respective ids. Otherwise,
392: # if p_create_acct = 'Y', then tries to create code combination in GL tables and
393: # creates the accu and acct in OPM tables (gl_accu_mst and gl_acct_mst)
394: # and returns accu_id and acct_id.
395: #
396: # Assumptions
397: # Code Combination will be created only if dynamic inserts is ON.

Line 414: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,

410:
411: PROCEDURE get_accu_acct_ids
412: (
413: p_co_code IN gl_plcy_mst.co_code%TYPE,
414: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
415: p_acct_no IN gl_acct_mst.acct_no%TYPE,
416: p_create_acct IN VARCHAR2 DEFAULT 'N',
417: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,
418: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%TYPE,

Line 417: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,

413: p_co_code IN gl_plcy_mst.co_code%TYPE,
414: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
415: p_acct_no IN gl_acct_mst.acct_no%TYPE,
416: p_create_acct IN VARCHAR2 DEFAULT 'N',
417: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,
418: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%TYPE,
419: x_ccid OUT NOCOPY NUMBER,
420: x_status OUT NOCOPY VARCHAR2,
421: x_errmsg OUT NOCOPY VARCHAR2

Line 549: p_acct_id gl_accu_mst.acctg_unit_id%TYPE)

545: RETURN VARCHAR2
546: IS
547:
548: CURSOR acct_no (p_co_code gl_acct_mst.co_code%TYPE,
549: p_acct_id gl_accu_mst.acctg_unit_id%TYPE)
550: IS
551: SELECT
552: acct_no
553: FROM

Line 590: p_co_code gl_accu_mst.co_code%TYPE,

586: ########################################################################*/
587:
588: FUNCTION get_acctg_unit_no
589: (
590: p_co_code gl_accu_mst.co_code%TYPE,
591: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE
592: )
593: RETURN VARCHAR2
594: IS

Line 591: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE

587:
588: FUNCTION get_acctg_unit_no
589: (
590: p_co_code gl_accu_mst.co_code%TYPE,
591: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE
592: )
593: RETURN VARCHAR2
594: IS
595:

Line 596: CURSOR accu_no (p_co_code gl_accu_mst.co_code%TYPE,

592: )
593: RETURN VARCHAR2
594: IS
595:
596: CURSOR accu_no (p_co_code gl_accu_mst.co_code%TYPE,
597: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE)
598: IS
599: SELECT
600: acctg_unit_no

Line 597: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE)

593: RETURN VARCHAR2
594: IS
595:
596: CURSOR accu_no (p_co_code gl_accu_mst.co_code%TYPE,
597: p_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE)
598: IS
599: SELECT
600: acctg_unit_no
601: FROM

Line 602: gl_accu_mst

598: IS
599: SELECT
600: acctg_unit_no
601: FROM
602: gl_accu_mst
603: WHERE
604: acctg_unit_id = p_acctg_unit_id
605: AND co_code = p_co_code
606: ;

Line 608: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;

604: acctg_unit_id = p_acctg_unit_id
605: AND co_code = p_co_code
606: ;
607:
608: l_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE;
609:
610: BEGIN
611:
612: OPEN accu_no (p_co_code, p_acctg_unit_id);