DBA Data[Home] [Help]

APPS.OZF_CLAIM_UTILITY_PVT dependencies on FND_GLOBAL

Line 369: , NVL(FND_GLOBAL.user_id,-1)

365: VALUES
366: (
367: OZF_RULE_BASED_LOG_S.nextval
368: , SYSDATE
369: , NVL(FND_GLOBAL.user_id,-1)
370: , SYSDATE
371: , NVL(FND_GLOBAL.user_id,-1)
372: , NVL(FND_GLOBAL.conc_login_id,-1)
373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

Line 371: , NVL(FND_GLOBAL.user_id,-1)

367: OZF_RULE_BASED_LOG_S.nextval
368: , SYSDATE
369: , NVL(FND_GLOBAL.user_id,-1)
370: , SYSDATE
371: , NVL(FND_GLOBAL.user_id,-1)
372: , NVL(FND_GLOBAL.conc_login_id,-1)
373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
374: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
375: , 'RULEBASED'

Line 372: , NVL(FND_GLOBAL.conc_login_id,-1)

368: , SYSDATE
369: , NVL(FND_GLOBAL.user_id,-1)
370: , SYSDATE
371: , NVL(FND_GLOBAL.user_id,-1)
372: , NVL(FND_GLOBAL.conc_login_id,-1)
373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
374: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
375: , 'RULEBASED'
376: --, l_exactmatchTbl(I).claim_id

Line 373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

369: , NVL(FND_GLOBAL.user_id,-1)
370: , SYSDATE
371: , NVL(FND_GLOBAL.user_id,-1)
372: , NVL(FND_GLOBAL.conc_login_id,-1)
373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
374: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
375: , 'RULEBASED'
376: --, l_exactmatchTbl(I).claim_id
377: , l_exact_match_rec_type.claim_id

Line 374: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)

370: , SYSDATE
371: , NVL(FND_GLOBAL.user_id,-1)
372: , NVL(FND_GLOBAL.conc_login_id,-1)
373: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
374: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
375: , 'RULEBASED'
376: --, l_exactmatchTbl(I).claim_id
377: , l_exact_match_rec_type.claim_id
378: , null

Line 422: , NVL(FND_GLOBAL.user_id,-1)

418: VALUES
419: (
420: OZF_RULE_BASED_LOG_S.nextval
421: , SYSDATE
422: , NVL(FND_GLOBAL.user_id,-1)
423: , SYSDATE
424: , NVL(FND_GLOBAL.user_id,-1)
425: , NVL(FND_GLOBAL.conc_login_id,-1)
426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

Line 424: , NVL(FND_GLOBAL.user_id,-1)

420: OZF_RULE_BASED_LOG_S.nextval
421: , SYSDATE
422: , NVL(FND_GLOBAL.user_id,-1)
423: , SYSDATE
424: , NVL(FND_GLOBAL.user_id,-1)
425: , NVL(FND_GLOBAL.conc_login_id,-1)
426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
427: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
428: , 'RULEBASED'

Line 425: , NVL(FND_GLOBAL.conc_login_id,-1)

421: , SYSDATE
422: , NVL(FND_GLOBAL.user_id,-1)
423: , SYSDATE
424: , NVL(FND_GLOBAL.user_id,-1)
425: , NVL(FND_GLOBAL.conc_login_id,-1)
426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
427: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
428: , 'RULEBASED'
429: --, l_possiblematchTbl(J).claim_id

Line 426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

422: , NVL(FND_GLOBAL.user_id,-1)
423: , SYSDATE
424: , NVL(FND_GLOBAL.user_id,-1)
425: , NVL(FND_GLOBAL.conc_login_id,-1)
426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
427: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
428: , 'RULEBASED'
429: --, l_possiblematchTbl(J).claim_id
430: , l_poss_match_rec_type.claim_id

Line 427: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)

423: , SYSDATE
424: , NVL(FND_GLOBAL.user_id,-1)
425: , NVL(FND_GLOBAL.conc_login_id,-1)
426: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
427: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
428: , 'RULEBASED'
429: --, l_possiblematchTbl(J).claim_id
430: , l_poss_match_rec_type.claim_id
431: , null

Line 471: , NVL(FND_GLOBAL.user_id,-1)

467: VALUES
468: (
469: OZF_RULE_BASED_LOG_S.nextval
470: , SYSDATE
471: , NVL(FND_GLOBAL.user_id,-1)
472: , SYSDATE
473: , NVL(FND_GLOBAL.user_id,-1)
474: , NVL(FND_GLOBAL.conc_login_id,-1)
475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

Line 473: , NVL(FND_GLOBAL.user_id,-1)

469: OZF_RULE_BASED_LOG_S.nextval
470: , SYSDATE
471: , NVL(FND_GLOBAL.user_id,-1)
472: , SYSDATE
473: , NVL(FND_GLOBAL.user_id,-1)
474: , NVL(FND_GLOBAL.conc_login_id,-1)
475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
476: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
477: , 'RULEBASED'

Line 474: , NVL(FND_GLOBAL.conc_login_id,-1)

470: , SYSDATE
471: , NVL(FND_GLOBAL.user_id,-1)
472: , SYSDATE
473: , NVL(FND_GLOBAL.user_id,-1)
474: , NVL(FND_GLOBAL.conc_login_id,-1)
475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
476: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
477: , 'RULEBASED'
478: , l_accrual_match_rec_type.claim_id

Line 475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)

471: , NVL(FND_GLOBAL.user_id,-1)
472: , SYSDATE
473: , NVL(FND_GLOBAL.user_id,-1)
474: , NVL(FND_GLOBAL.conc_login_id,-1)
475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
476: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
477: , 'RULEBASED'
478: , l_accrual_match_rec_type.claim_id
479: , l_accrual_match_rec_type.qp_list_header_id

Line 476: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)

472: , SYSDATE
473: , NVL(FND_GLOBAL.user_id,-1)
474: , NVL(FND_GLOBAL.conc_login_id,-1)
475: , NVL(FND_GLOBAL.CONC_REQUEST_ID,-1)
476: , NVL(FND_GLOBAL.PROG_APPL_ID,-1)
477: , 'RULEBASED'
478: , l_accrual_match_rec_type.claim_id
479: , l_accrual_match_rec_type.qp_list_header_id
480: , null

Line 1007: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

1003: l_claim_rec.user_status_id := to_number(
1004: ozf_utility_pvt.get_default_user_status(
1005: p_status_type => 'OZF_CLAIM_STATUS',
1006: p_status_code => l_claim_rec.status_code));
1007: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1008: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
1009: l_claim_rec.settled_from := 'RULEBASED';
1010:
1011: OZF_Claim_PVT.Update_Claim(

Line 1008: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

1004: ozf_utility_pvt.get_default_user_status(
1005: p_status_type => 'OZF_CLAIM_STATUS',
1006: p_status_code => l_claim_rec.status_code));
1007: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1008: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
1009: l_claim_rec.settled_from := 'RULEBASED';
1010:
1011: OZF_Claim_PVT.Update_Claim(
1012: p_api_version => l_api_version

Line 1264: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

1260: l_claim_rec.user_status_id := to_number(
1261: ozf_utility_pvt.get_default_user_status(
1262: p_status_type => 'OZF_CLAIM_STATUS',
1263: p_status_code => l_claim_rec.status_code));
1264: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1265: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
1266: l_claim_rec.settled_from := 'RULEBASED';
1267:
1268: OZF_Claim_PVT.Update_Claim(

Line 1265: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

1261: ozf_utility_pvt.get_default_user_status(
1262: p_status_type => 'OZF_CLAIM_STATUS',
1263: p_status_code => l_claim_rec.status_code));
1264: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1265: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
1266: l_claim_rec.settled_from := 'RULEBASED';
1267:
1268: OZF_Claim_PVT.Update_Claim(
1269: p_api_version => l_api_version