DBA Data[Home] [Help]

APPS.GL_MOVEMERGE_ACCOUNTS_PKG dependencies on GL_MOVEMERGE_ACCOUNTS

Line 1: PACKAGE BODY gl_movemerge_accounts_pkg AS

1: PACKAGE BODY gl_movemerge_accounts_pkg AS
2: /* $Header: glimmacb.pls 120.3 2005/05/05 01:17:22 kvora ship $ */
3:
4: --
5: -- PRIVATE DATA DECLARATIONS

Line 28: FROM gl_movemerge_accounts p

24: CURSOR line_count IS
25: SELECT 1
26: FROM DUAL
27: WHERE EXISTS (SELECT 1
28: FROM gl_movemerge_accounts p
29: WHERE movemerge_request_id = mm_id
30: AND line_number = lineno
31: AND (rowid <> row_id OR row_id IS NULL));
32: BEGIN

Line 49: 'gl_movemerge_accounts_pkg.line_number_is_unique');

45: WHEN OTHERS THEN
46: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
47: fnd_message.set_token(
48: 'PROCEDURE',
49: 'gl_movemerge_accounts_pkg.line_number_is_unique');
50: RAISE;
51: END line_number_is_unique;
52:
53:

Line 76: FROM gl_movemerge_accounts p

72: CURSOR source_count IS
73: SELECT 1
74: FROM DUAL
75: WHERE EXISTS (SELECT 1
76: FROM gl_movemerge_accounts p
77: WHERE movemerge_request_id = mm_id
78: AND (rowid <> row_id OR row_id IS NULL)
79: AND nvl(source_segment1, ' ') = nvl(ss1, ' ')
80: AND nvl(source_segment2, ' ') = nvl(ss2, ' ')

Line 126: 'gl_movemerge_accounts_pkg.source_spec_is_unique');

122: WHEN OTHERS THEN
123: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
124: fnd_message.set_token(
125: 'PROCEDURE',
126: 'gl_movemerge_accounts_pkg.source_spec_is_unique');
127: RAISE;
128: END source_spec_is_unique;
129:
130:

Line 138: END gl_movemerge_accounts_pkg;

134: BEGIN
135: line_number_is_unique(mm_id, lineno, row_id);
136: END pre_insert;
137:
138: END gl_movemerge_accounts_pkg;