APPS.CE_STATEMENT_RECONS_PKG dependencies on CE_STATEMENT_RECONCILS_ALL

Line 168: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'

164: FETCH C_STMT_LOCK INTO X_Row_Id, X_org_id_tmp, X_legal_entity_id_tmp;
165: if (C_STMT_LOCK%NOTFOUND) then
166: CLOSE C_STMT_LOCK;
167: ELSE
168: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'
169: WHERE rowid = X_Row_id;
170: CLOSE C_STMT_LOCK;
171: END IF;
172: ELSE

Line 178: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'

174: FETCH C_LOCK INTO X_Row_Id, X_org_id_tmp, X_legal_entity_id_tmp;
175: if (C_LOCK%NOTFOUND) then
176: CLOSE C_LOCK;
177: ELSE
178: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'
179: WHERE rowid = X_Row_id;
180: CLOSE C_LOCK;
181: END IF;
182: END IF;

Line 205: INSERT INTO CE_STATEMENT_RECONCILS_ALL(

201:
202: cep_standard.debug( ' Y_org_id ='||Y_org_id);
203: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
204:
205: INSERT INTO CE_STATEMENT_RECONCILS_ALL(
206: statement_line_id,
207: reference_type,
208: reference_id,
209: status_flag,

Line 383: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'

379: FETCH C_LOCK INTO X_Row_Id, x_org_id_tmp, x_legal_entity_id_tmp;
380: if (C_LOCK%NOTFOUND) then
381: CLOSE C_LOCK;
382: ELSE
383: UPDATE CE_STATEMENT_RECONCILS_ALL SET current_record_flag = 'N'
384: WHERE rowid = X_Row_id;
385: CLOSE C_LOCK;
386: END IF;
387: IF l_DEBUG in ('Y', 'C') THEN

Line 388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');

384: WHERE rowid = X_Row_id;
385: CLOSE C_LOCK;
386: END IF;
387: IF l_DEBUG in ('Y', 'C') THEN
388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
389: END IF;
390:
391: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
392: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

Line 410: INSERT INTO CE_STATEMENT_RECONCILS_ALL(

406: cep_standard.debug( ' Y_org_id ='||Y_org_id);
407: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
408:
409:
410: INSERT INTO CE_STATEMENT_RECONCILS_ALL(
411: statement_line_id,
412: reference_type,
413: reference_id,
414: je_header_id,

Line 458: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');

454: X_program_update_date,
455: NULL));
456:
457: IF l_DEBUG in ('Y', 'C') THEN
458: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
459: END IF;
460: OPEN C_ROWID;
461: FETCH C_ROWID INTO X_Row_Id;
462: if (C_ROWID%NOTFOUND) then

Line 547: UPDATE CE_STATEMENT_RECONCILS_ALL

543: X_creation_date DATE,
544: X_last_updated_by NUMBER,
545: X_last_update_date DATE) IS
546: BEGIN
547: UPDATE CE_STATEMENT_RECONCILS_ALL
548: SET
549: statement_line_id = X_Statement_Line_Id,
550: reference_type = X_Reference_Type,
551: reference_id = X_Reference_Id,

Line 566: DELETE FROM CE_STATEMENT_RECONCILS_ALL

562: END Update_Row;
563:
564: PROCEDURE Delete_Row(X_Row_id VARCHAR2) IS
565: BEGIN
566: DELETE FROM CE_STATEMENT_RECONCILS_ALL
567: WHERE rowid = X_Row_Id;
568:
569: if (SQL%NOTFOUND) then
570: Raise NO_DATA_FOUND;