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 FND_DSQL

Line 3240: FND_DSQL.init;

3236: l_cursor_id NUMBER;
3237: i NUMBER;
3238: BEGIN
3239:
3240: FND_DSQL.init;
3241:
3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
3243: FND_DSQL.add_text('FROM ozf_claims ');
3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');

Line 3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');

3238: BEGIN
3239:
3240: FND_DSQL.init;
3241:
3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
3243: FND_DSQL.add_text('FROM ozf_claims ');
3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
3245:
3246: i := p_payment_method_tbl.FIRST;

Line 3243: FND_DSQL.add_text('FROM ozf_claims ');

3239:
3240: FND_DSQL.init;
3241:
3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
3243: FND_DSQL.add_text('FROM ozf_claims ');
3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
3245:
3246: i := p_payment_method_tbl.FIRST;
3247: IF i IS NOT NULL THEN

Line 3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');

3240: FND_DSQL.init;
3241:
3242: FND_DSQL.add_text('SELECT claim_id, claim_number, object_version_number, claim_class, amount_remaining, amount_settled, source_object_id, payment_method ');
3243: FND_DSQL.add_text('FROM ozf_claims ');
3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
3245:
3246: i := p_payment_method_tbl.FIRST;
3247: IF i IS NOT NULL THEN
3248: FND_DSQL.add_text(' AND ( ');

Line 3248: FND_DSQL.add_text(' AND ( ');

3244: FND_DSQL.add_text('WHERE status_code = ''PENDING_CLOSE'' ');
3245:
3246: i := p_payment_method_tbl.FIRST;
3247: IF i IS NOT NULL THEN
3248: FND_DSQL.add_text(' AND ( ');
3249: LOOP
3250: FND_DSQL.add_text(' payment_method = ');
3251: FND_DSQL.add_bind(p_payment_method_tbl(i));
3252: EXIT WHEN i = p_payment_method_tbl.LAST;

Line 3250: FND_DSQL.add_text(' payment_method = ');

3246: i := p_payment_method_tbl.FIRST;
3247: IF i IS NOT NULL THEN
3248: FND_DSQL.add_text(' AND ( ');
3249: LOOP
3250: FND_DSQL.add_text(' payment_method = ');
3251: FND_DSQL.add_bind(p_payment_method_tbl(i));
3252: EXIT WHEN i = p_payment_method_tbl.LAST;
3253: i:=p_payment_method_tbl.NEXT(i);
3254: FND_DSQL.add_text(' OR ');

Line 3251: FND_DSQL.add_bind(p_payment_method_tbl(i));

3247: IF i IS NOT NULL THEN
3248: FND_DSQL.add_text(' AND ( ');
3249: LOOP
3250: FND_DSQL.add_text(' payment_method = ');
3251: FND_DSQL.add_bind(p_payment_method_tbl(i));
3252: EXIT WHEN i = p_payment_method_tbl.LAST;
3253: i:=p_payment_method_tbl.NEXT(i);
3254: FND_DSQL.add_text(' OR ');
3255: END LOOP;

Line 3254: FND_DSQL.add_text(' OR ');

3250: FND_DSQL.add_text(' payment_method = ');
3251: FND_DSQL.add_bind(p_payment_method_tbl(i));
3252: EXIT WHEN i = p_payment_method_tbl.LAST;
3253: i:=p_payment_method_tbl.NEXT(i);
3254: FND_DSQL.add_text(' OR ');
3255: END LOOP;
3256: FND_DSQL.add_text(' ) ');
3257: END IF;
3258:

Line 3256: FND_DSQL.add_text(' ) ');

3252: EXIT WHEN i = p_payment_method_tbl.LAST;
3253: i:=p_payment_method_tbl.NEXT(i);
3254: FND_DSQL.add_text(' OR ');
3255: END LOOP;
3256: FND_DSQL.add_text(' ) ');
3257: END IF;
3258:
3259: IF p_payment_status IS NOT NULL THEN
3260: FND_DSQL.add_text(' AND payment_status = ');

Line 3260: FND_DSQL.add_text(' AND payment_status = ');

3256: FND_DSQL.add_text(' ) ');
3257: END IF;
3258:
3259: IF p_payment_status IS NOT NULL THEN
3260: FND_DSQL.add_text(' AND payment_status = ');
3261: FND_DSQL.add_bind(p_payment_status);
3262: END IF;
3263:
3264:

Line 3261: FND_DSQL.add_bind(p_payment_status);

3257: END IF;
3258:
3259: IF p_payment_status IS NOT NULL THEN
3260: FND_DSQL.add_text(' AND payment_status = ');
3261: FND_DSQL.add_bind(p_payment_status);
3262: END IF;
3263:
3264:
3265: IF p_claim_class IS NOT NULL THEN

Line 3266: FND_DSQL.add_text(' AND claim_class = ');

3262: END IF;
3263:
3264:
3265: IF p_claim_class IS NOT NULL THEN
3266: FND_DSQL.add_text(' AND claim_class = ');
3267: FND_DSQL.add_bind(p_claim_class);
3268: END IF;
3269:
3270: IF p_cust_account_id IS NOT NULL THEN

Line 3267: FND_DSQL.add_bind(p_claim_class);

3263:
3264:
3265: IF p_claim_class IS NOT NULL THEN
3266: FND_DSQL.add_text(' AND claim_class = ');
3267: FND_DSQL.add_bind(p_claim_class);
3268: END IF;
3269:
3270: IF p_cust_account_id IS NOT NULL THEN
3271: FND_DSQL.add_text(' AND cust_account_id = ');

Line 3271: FND_DSQL.add_text(' AND cust_account_id = ');

3267: FND_DSQL.add_bind(p_claim_class);
3268: END IF;
3269:
3270: IF p_cust_account_id IS NOT NULL THEN
3271: FND_DSQL.add_text(' AND cust_account_id = ');
3272: FND_DSQL.add_bind(p_cust_account_id);
3273: END IF;
3274:
3275: IF p_claim_type_id IS NOT NULL THEN

Line 3272: FND_DSQL.add_bind(p_cust_account_id);

3268: END IF;
3269:
3270: IF p_cust_account_id IS NOT NULL THEN
3271: FND_DSQL.add_text(' AND cust_account_id = ');
3272: FND_DSQL.add_bind(p_cust_account_id);
3273: END IF;
3274:
3275: IF p_claim_type_id IS NOT NULL THEN
3276: FND_DSQL.add_text(' AND claim_type_id = ');

Line 3276: FND_DSQL.add_text(' AND claim_type_id = ');

3272: FND_DSQL.add_bind(p_cust_account_id);
3273: END IF;
3274:
3275: IF p_claim_type_id IS NOT NULL THEN
3276: FND_DSQL.add_text(' AND claim_type_id = ');
3277: FND_DSQL.add_bind(p_claim_type_id);
3278: END IF;
3279:
3280: IF p_reason_code_id IS NOT NULL THEN

Line 3277: FND_DSQL.add_bind(p_claim_type_id);

3273: END IF;
3274:
3275: IF p_claim_type_id IS NOT NULL THEN
3276: FND_DSQL.add_text(' AND claim_type_id = ');
3277: FND_DSQL.add_bind(p_claim_type_id);
3278: END IF;
3279:
3280: IF p_reason_code_id IS NOT NULL THEN
3281: FND_DSQL.add_text(' AND reason_code_id = ');

Line 3281: FND_DSQL.add_text(' AND reason_code_id = ');

3277: FND_DSQL.add_bind(p_claim_type_id);
3278: END IF;
3279:
3280: IF p_reason_code_id IS NOT NULL THEN
3281: FND_DSQL.add_text(' AND reason_code_id = ');
3282: FND_DSQL.add_bind(p_reason_code_id);
3283: END IF;
3284:
3285: END Get_claim_csr;

Line 3282: FND_DSQL.add_bind(p_reason_code_id);

3278: END IF;
3279:
3280: IF p_reason_code_id IS NOT NULL THEN
3281: FND_DSQL.add_text(' AND reason_code_id = ');
3282: FND_DSQL.add_bind(p_reason_code_id);
3283: END IF;
3284:
3285: END Get_claim_csr;
3286:

Line 3428: FND_DSQL.set_cursor(l_claim_csr_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);
3432:

Line 3429: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);

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);
3432:
3433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

Line 3431: l_stmt_debug := fnd_dsql.get_text(TRUE);

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);
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);

Line 3444: FND_DSQL.do_binds;

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;
3448: LOOP

Line 3637: FND_DSQL.set_cursor(l_claim_csr_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);
3641:

Line 3638: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);

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);
3641:
3642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

Line 3640: l_stmt_debug := fnd_dsql.get_text(TRUE);

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);
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);

Line 3653: FND_DSQL.do_binds;

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;
3657: LOOP

Line 3949: FND_DSQL.set_cursor(l_claim_csr_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);
3953:

Line 3950: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);

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);
3953:
3954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

Line 3952: l_stmt_debug := fnd_dsql.get_text(TRUE);

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);
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);

Line 3966: FND_DSQL.do_binds;

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:
3969: l_counter := 1;
3970: LOOP

Line 4628: FND_DSQL.set_cursor(l_claim_csr_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);
4632:

Line 4629: l_claim_csr_stmt := FND_DSQL.get_text(FALSE);

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);
4632:
4633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'QUERY CLAIM SQL :: ' || l_stmt_debug);

Line 4631: l_stmt_debug := fnd_dsql.get_text(TRUE);

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);
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);

Line 4644: FND_DSQL.do_binds;

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;
4648: LOOP