APPS.GMF_VALIDATE_ACCOUNT dependencies on GL_ACCT_MST

Line 46: p_acct_id IN gl_acct_mst.acct_id%TYPE,

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',
50: x_ccid OUT NOCOPY NUMBER,

Line 48: p_acct_no IN gl_acct_mst.acct_no%TYPE,

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,
52: x_status OUT NOCOPY VARCHAR2,

Line 87: l_acct_no gl_acct_mst.acct_no%TYPE;

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);
91: l_concat_segs1 VARCHAR2(4000);

Line 286: p_acct_id IN gl_acct_mst.acct_id%TYPE,

282:
283: PROCEDURE cross_validate
284: (
285: p_co_code IN gl_plcy_mst.co_code%TYPE,
286: p_acct_id IN gl_acct_mst.acct_id%TYPE,
287: p_called_from IN VARCHAR2,
288: x_status OUT NOCOPY VARCHAR2,
289: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL
290: )

Line 289: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL

285: p_co_code IN gl_plcy_mst.co_code%TYPE,
286: p_acct_id IN gl_acct_mst.acct_id%TYPE,
287: p_called_from IN VARCHAR2,
288: x_status OUT NOCOPY VARCHAR2,
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)

Line 310: l_acct_no gl_acct_mst.acct_no%TYPE;

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;
314: empty_error_messages error_messages_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 415: p_acct_no IN gl_acct_mst.acct_no%TYPE,

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,
419: x_ccid OUT NOCOPY NUMBER,

Line 418: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%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
422: )

Line 542: p_co_code gl_acct_mst.co_code%TYPE,

538: ########################################################################*/
539:
540: FUNCTION get_acct_no
541: (
542: p_co_code gl_acct_mst.co_code%TYPE,
543: p_acct_id gl_acct_mst.acct_id%TYPE
544: )
545: RETURN VARCHAR2
546: IS

Line 543: p_acct_id gl_acct_mst.acct_id%TYPE

539:
540: FUNCTION get_acct_no
541: (
542: p_co_code gl_acct_mst.co_code%TYPE,
543: p_acct_id gl_acct_mst.acct_id%TYPE
544: )
545: RETURN VARCHAR2
546: IS
547:

Line 548: CURSOR acct_no (p_co_code gl_acct_mst.co_code%TYPE,

544: )
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

Line 554: gl_acct_mst

550: IS
551: SELECT
552: acct_no
553: FROM
554: gl_acct_mst
555: WHERE
556: acct_id = p_acct_id
557: AND co_code = p_co_code
558: ;

Line 560: l_acct_no gl_acct_mst.acct_no%TYPE;

556: acct_id = p_acct_id
557: AND co_code = p_co_code
558: ;
559:
560: l_acct_no gl_acct_mst.acct_no%TYPE;
561:
562: BEGIN
563: OPEN acct_no (p_co_code, p_acct_id);
564: FETCH acct_no INTO l_acct_no;