APPS.FND_SEED_STAGE_UTIL dependencies on FND_SEED_STAGE_CONFIG

Line 90: l_upload_lob FND_SEED_STAGE_CONFIG.UPLOAD_STMT%TYPE;

86: IS
87: TYPE csr_type IS REF CURSOR;
88:
89: config_csr csr_type;
90: l_upload_lob FND_SEED_STAGE_CONFIG.UPLOAD_STMT%TYPE;
91: l_stmt_len FND_SEED_STAGE_CONFIG.STMT_LEN%TYPE;
92:
93: status_csr csr_type;
94: l_str VARCHAR2(4000);

Line 91: l_stmt_len FND_SEED_STAGE_CONFIG.STMT_LEN%TYPE;

87: TYPE csr_type IS REF CURSOR;
88:
89: config_csr csr_type;
90: l_upload_lob FND_SEED_STAGE_CONFIG.UPLOAD_STMT%TYPE;
91: l_stmt_len FND_SEED_STAGE_CONFIG.STMT_LEN%TYPE;
92:
93: status_csr csr_type;
94: l_str VARCHAR2(4000);
95:

Line 125: FROM fnd_seed_stage_config

121: G_MSG_TAB.delete;
122:
123: if p_debug = 0 then
124: l_str := 'SELECT upload_stmt, stmt_len
125: FROM fnd_seed_stage_config
126: WHERE lct_file = :1
127: AND proc_id = :2
128: AND entity_name = ''PLSQL_WRAPPER_CODE''';
129: else

Line 131: FROM fnd_seed_stage_config_debug

127: AND proc_id = :2
128: AND entity_name = ''PLSQL_WRAPPER_CODE''';
129: else
130: l_str := 'SELECT upload_stmt, stmt_len
131: FROM fnd_seed_stage_config_debug
132: WHERE lct_file = :1
133: AND proc_id = :2
134: AND entity_name = ''PLSQL_WRAPPER_CODE''';
135: end if;

Line 140: l_msg := 'No record found in FND_SEED_STAGE_CONFIG with the plsql wrapper code';

136:
137: OPEN config_csr FOR l_str USING p_lct_file, p_proc_id;
138: FETCH config_csr INTO l_upload_lob, l_stmt_len;
139: if config_csr%NOTFOUND then
140: l_msg := 'No record found in FND_SEED_STAGE_CONFIG with the plsql wrapper code';
141: x_abort := 1;
142: x_err_count := 1;
143: x_err_tab(1) := l_msg;
144: CLOSE config_csr;