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)
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'
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
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
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
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)
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'
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
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
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
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)
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'
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
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
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
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(
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
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(
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