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.OZF_SETTLEMENT_DOC_PVT dependencies on DBMS_SQL

Line 3427: l_claim_csr_id := DBMS_SQL.open_cursor;

3423: ,p_reason_code_id => p_reason_code_id
3424: ,p_payment_status => 'PENDING'
3425: );
3426:
3427: l_claim_csr_id := DBMS_SQL.open_cursor;
3428: FND_DSQL.set_cursor(l_claim_csr_id);
3429: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3430:
3431: l_stmt_debug := fnd_dsql.get_text(TRUE);

Line 3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);

3431: l_stmt_debug := fnd_dsql.get_text(TRUE);
3432:
3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3434:
3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

Line 3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);

3432:
3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3434:
3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3434:
3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3434:
3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

3435: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

Line 3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3436: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3444: FND_DSQL.do_binds;

Line 3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3437: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3444: FND_DSQL.do_binds;
3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

Line 3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3438: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3444: FND_DSQL.do_binds;
3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3446:

Line 3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

3439: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3440: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3444: FND_DSQL.do_binds;
3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3446:
3447: l_counter := 1;

Line 3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

3441: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3442: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3443: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3444: FND_DSQL.do_binds;
3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3446:
3447: l_counter := 1;
3448: LOOP
3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

Line 3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

3445: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3446:
3447: l_counter := 1;
3448: LOOP
3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3450:
3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

Line 3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);

3447: l_counter := 1;
3448: LOOP
3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3450:
3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);

3448: LOOP
3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3450:
3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3449: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3450:
3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);

3450:
3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

Line 3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3451: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3459:

Line 3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3452: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3459:
3460: l_claim_rma_fetch(l_counter).claim_id := l_claim_rec.claim_id;

Line 3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3453: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3459:
3460: l_claim_rma_fetch(l_counter).claim_id := l_claim_rec.claim_id;
3461: l_claim_rma_fetch(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');

Line 3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

3454: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3455: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3456: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3457: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3458: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3459:
3460: l_claim_rma_fetch(l_counter).claim_id := l_claim_rec.claim_id;
3461: l_claim_rma_fetch(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');
3462: l_claim_rma_fetch(l_counter).object_version_number := l_claim_rec.object_version_number;

Line 3474: DBMS_SQL.close_cursor(l_claim_csr_id);

3470: EXIT;
3471: END IF;
3472: l_counter := l_counter + 1;
3473: END LOOP;
3474: DBMS_SQL.close_cursor(l_claim_csr_id);
3475:
3476: IF l_claim_rma_fetch.count > 0 THEN
3477: FOR i IN 1..l_claim_rma_fetch.count LOOP
3478: FND_MSG_PUB.initialize;

Line 3636: l_claim_csr_id := DBMS_SQL.open_cursor;

3632: ,p_reason_code_id => p_reason_code_id
3633: ,p_payment_status => 'INTERFACED'
3634: );
3635:
3636: l_claim_csr_id := DBMS_SQL.open_cursor;
3637: FND_DSQL.set_cursor(l_claim_csr_id);
3638: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3639:
3640: l_stmt_debug := fnd_dsql.get_text(TRUE);

Line 3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);

3640: l_stmt_debug := fnd_dsql.get_text(TRUE);
3641:
3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3643:
3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

Line 3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);

3641:
3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3643:
3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3643:
3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3643:
3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

3644: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

Line 3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3645: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3653: FND_DSQL.do_binds;

Line 3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3646: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3653: FND_DSQL.do_binds;
3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

Line 3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3647: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3653: FND_DSQL.do_binds;
3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3655:

Line 3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

3648: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3649: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3653: FND_DSQL.do_binds;
3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3655:
3656: l_counter := 1;

Line 3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

3650: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3651: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3652: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3653: FND_DSQL.do_binds;
3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3655:
3656: l_counter := 1;
3657: LOOP
3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

Line 3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

3654: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3655:
3656: l_counter := 1;
3657: LOOP
3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3659:
3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

Line 3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);

3656: l_counter := 1;
3657: LOOP
3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3659:
3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);

3657: LOOP
3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3659:
3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3658: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3659:
3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);

3659:
3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

Line 3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3660: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3668:

Line 3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3661: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3668:
3669: l_claim_rma_setl(l_counter).claim_id := l_claim_rec.claim_id;

Line 3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3662: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3668:
3669: l_claim_rma_setl(l_counter).claim_id := l_claim_rec.claim_id;
3670: l_claim_rma_setl(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');

Line 3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

3663: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3664: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3665: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3666: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3667: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3668:
3669: l_claim_rma_setl(l_counter).claim_id := l_claim_rec.claim_id;
3670: l_claim_rma_setl(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');
3671: l_claim_rma_setl(l_counter).object_version_number := l_claim_rec.object_version_number;

Line 3683: DBMS_SQL.close_cursor(l_claim_csr_id);

3679: EXIT;
3680: END IF;
3681: l_counter := l_counter + 1;
3682: END LOOP;
3683: DBMS_SQL.close_cursor(l_claim_csr_id);
3684:
3685: IF l_claim_rma_setl.count > 0 THEN
3686: FOR i IN 1..l_claim_rma_setl.count LOOP
3687: FND_MSG_PUB.initialize;

Line 3948: l_claim_csr_id := DBMS_SQL.open_cursor;

3944: ,p_reason_code_id => p_reason_code_id
3945: ,p_payment_status => 'INTERFACED'
3946: );
3947:
3948: l_claim_csr_id := DBMS_SQL.open_cursor;
3949: FND_DSQL.set_cursor(l_claim_csr_id);
3950: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
3951:
3952: l_stmt_debug := fnd_dsql.get_text(TRUE);

Line 3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);

3952: l_stmt_debug := fnd_dsql.get_text(TRUE);
3953:
3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3955:
3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

Line 3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);

3953:
3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3955:
3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
3955:
3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3955:
3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

3956: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

Line 3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3957: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3965:

Line 3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3958: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3965:
3966: FND_DSQL.do_binds;

Line 3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3959: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3965:
3966: FND_DSQL.do_binds;
3967: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

Line 3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

3960: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
3961: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3962: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3965:
3966: FND_DSQL.do_binds;
3967: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3968:

Line 3967: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

3963: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3964: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
3965:
3966: FND_DSQL.do_binds;
3967: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3968:
3969: l_counter := 1;
3970: LOOP
3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

Line 3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

3967: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
3968:
3969: l_counter := 1;
3970: LOOP
3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3972:
3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

Line 3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);

3969: l_counter := 1;
3970: LOOP
3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3972:
3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);

3970: LOOP
3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3972:
3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

3971: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
3972:
3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);

3972:
3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

Line 3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

3973: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3981:

Line 3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

3974: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3981:
3982: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;

Line 3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

3975: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3981:
3982: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;
3983: l_claim_id_ver(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');

Line 3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

3976: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
3977: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
3978: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
3979: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
3980: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
3981:
3982: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;
3983: l_claim_id_ver(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');
3984: l_claim_id_ver(l_counter).object_version_number := l_claim_rec.object_version_number;

Line 3996: DBMS_SQL.close_cursor(l_claim_csr_id);

3992: EXIT;
3993: END IF;
3994: l_counter := l_counter + 1;
3995: END LOOP;
3996: DBMS_SQL.close_cursor(l_claim_csr_id);
3997:
3998:
3999: IF l_claim_id_ver.count > 0 THEN
4000: FOR i IN 1..l_claim_id_ver.count LOOP

Line 4627: l_claim_csr_id := DBMS_SQL.open_cursor;

4623: ,p_reason_code_id => p_reason_code_id
4624: ,p_payment_status => 'INTERFACED'
4625: );
4626:
4627: l_claim_csr_id := DBMS_SQL.open_cursor;
4628: FND_DSQL.set_cursor(l_claim_csr_id);
4629: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);
4630:
4631: l_stmt_debug := fnd_dsql.get_text(TRUE);

Line 4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);

4631: l_stmt_debug := fnd_dsql.get_text(TRUE);
4632:
4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
4634:
4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

Line 4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);

4632:
4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
4634:
4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);

4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);
4634:
4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);

4634:
4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);

4635: DBMS_SQL.parse(l_claim_csr_id, l_claim_csr_stmt, DBMS_SQL.native);
4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

Line 4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

4636: DBMS_SQL.define_column(l_claim_csr_id, 1, l_claim_rec.claim_id);
4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
4644: FND_DSQL.do_binds;

Line 4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);

4637: DBMS_SQL.define_column_char(l_claim_csr_id, 2, l_claim_rec.claim_number, 30);
4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
4644: FND_DSQL.do_binds;
4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

Line 4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);

4638: DBMS_SQL.define_column(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
4644: FND_DSQL.do_binds;
4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
4646:

Line 4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);

4639: DBMS_SQL.define_column_char(l_claim_csr_id, 4, l_claim_rec.claim_class, 30);
4640: DBMS_SQL.define_column(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
4644: FND_DSQL.do_binds;
4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
4646:
4647: l_counter := 1;

Line 4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);

4641: DBMS_SQL.define_column(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4642: DBMS_SQL.define_column(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4643: DBMS_SQL.define_column_char(l_claim_csr_id, 8, l_claim_rec.payment_method, 15);
4644: FND_DSQL.do_binds;
4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
4646:
4647: l_counter := 1;
4648: LOOP
4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

Line 4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN

4645: l_claim_num_rows := DBMS_SQL.execute(l_claim_csr_id);
4646:
4647: l_counter := 1;
4648: LOOP
4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
4650:
4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

Line 4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);

4647: l_counter := 1;
4648: LOOP
4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
4650:
4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

Line 4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);

4648: LOOP
4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
4650:
4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

Line 4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);

4649: IF DBMS_SQL.fetch_rows(l_claim_csr_id) > 0 THEN
4650:
4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

Line 4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);

4650:
4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

Line 4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);

4651: DBMS_SQL.column_value(l_claim_csr_id, 1, l_claim_rec.claim_id);
4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
4659:

Line 4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);

4652: DBMS_SQL.column_value_char(l_claim_csr_id, 2, l_claim_rec.claim_number);
4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
4659:
4660: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;

Line 4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);

4653: DBMS_SQL.column_value(l_claim_csr_id, 3, l_claim_rec.object_version_number);
4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
4659:
4660: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;
4661: l_claim_id_ver(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');

Line 4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);

4654: DBMS_SQL.column_value_char(l_claim_csr_id, 4, l_claim_rec.claim_class);
4655: DBMS_SQL.column_value(l_claim_csr_id, 5, l_claim_rec.amount_remaining);
4656: DBMS_SQL.column_value(l_claim_csr_id, 6, l_claim_rec.amount_settled);
4657: DBMS_SQL.column_value(l_claim_csr_id, 7, l_claim_rec.source_object_id);
4658: DBMS_SQL.column_value_char(l_claim_csr_id, 8, l_claim_rec.payment_method);
4659:
4660: l_claim_id_ver(l_counter).claim_id := l_claim_rec.claim_id;
4661: l_claim_id_ver(l_counter).claim_number := RTRIM(l_claim_rec.claim_number, ' ');
4662: l_claim_id_ver(l_counter).object_version_number := l_claim_rec.object_version_number;

Line 4674: DBMS_SQL.close_cursor(l_claim_csr_id);

4670: EXIT;
4671: END IF;
4672: l_counter := l_counter + 1;
4673: END LOOP;
4674: DBMS_SQL.close_cursor(l_claim_csr_id);
4675:
4676:
4677: -- Process individuals Claims
4678: FOR i IN 1..l_claim_id_ver.count LOOP