1177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1178: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
1179: END IF;
1180:
1181: l_user := FND_GLOBAL.USER_ID;
1182: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1183: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1184: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1185:
1178: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
1179: END IF;
1180:
1181: l_user := FND_GLOBAL.USER_ID;
1182: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1183: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1184: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1185:
1186: --Begin Bug 8933776 30-Nov-2009 barathsr
1179: END IF;
1180:
1181: l_user := FND_GLOBAL.USER_ID;
1182: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1183: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1184: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1185:
1186: --Begin Bug 8933776 30-Nov-2009 barathsr
1187: if l_components_tbl is not null or l_components_tbl.count>1 then
1180:
1181: l_user := FND_GLOBAL.USER_ID;
1182: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1183: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1184: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1185:
1186: --Begin Bug 8933776 30-Nov-2009 barathsr
1187: if l_components_tbl is not null or l_components_tbl.count>1 then
1188: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'count in comp tab-->'||l_components_tbl.count);
1628: -- ,l_universe(1)
1629: -- ,l_object_type
1630: -- ,1
1631: -- ,sysdate
1632: -- ,FND_GLOBAL.USER_ID
1633: -- ,FND_GLOBAL.USER_ID
1634: -- ,sysdate
1635: -- ,FND_GLOBAL.USER_ID
1636: -- ,l_scores_tbl(1)
1629: -- ,l_object_type
1630: -- ,1
1631: -- ,sysdate
1632: -- ,FND_GLOBAL.USER_ID
1633: -- ,FND_GLOBAL.USER_ID
1634: -- ,sysdate
1635: -- ,FND_GLOBAL.USER_ID
1636: -- ,l_scores_tbl(1)
1637: -- ,p_score_id
1631: -- ,sysdate
1632: -- ,FND_GLOBAL.USER_ID
1633: -- ,FND_GLOBAL.USER_ID
1634: -- ,sysdate
1635: -- ,FND_GLOBAL.USER_ID
1636: -- ,l_scores_tbl(1)
1637: -- ,p_score_id
1638: -- ,nvl(FND_GLOBAL.Conc_REQUEST_ID,0));
1639: --
1634: -- ,sysdate
1635: -- ,FND_GLOBAL.USER_ID
1636: -- ,l_scores_tbl(1)
1637: -- ,p_score_id
1638: -- ,nvl(FND_GLOBAL.Conc_REQUEST_ID,0));
1639: --
1640: -- END IF;
1641: --
1642: -- return l_scores_tbl(1);
2482: IF PG_DEBUG < 10 THEN
2483: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
2484: END IF;
2485:
2486: l_user := FND_GLOBAL.USER_ID;
2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2488: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2489: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2490:
2483: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
2484: END IF;
2485:
2486: l_user := FND_GLOBAL.USER_ID;
2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2488: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2489: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2490:
2491: -- start fro bug 13335079 pnaveenk added org_id to iex_score_histories
2484: END IF;
2485:
2486: l_user := FND_GLOBAL.USER_ID;
2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2488: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2489: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2490:
2491: -- start fro bug 13335079 pnaveenk added org_id to iex_score_histories
2492: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
2485:
2486: l_user := FND_GLOBAL.USER_ID;
2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2488: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2489: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2490:
2491: -- start fro bug 13335079 pnaveenk added org_id to iex_score_histories
2492: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
2493:
2601: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Insert records!' );
2602: END IF;
2603:
2604: l_bridge := p_bridge;
2605: l_user := FND_GLOBAL.USER_ID;
2606: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2607: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2608: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2609:
2602: END IF;
2603:
2604: l_bridge := p_bridge;
2605: l_user := FND_GLOBAL.USER_ID;
2606: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2607: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2608: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2609:
2610: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2603:
2604: l_bridge := p_bridge;
2605: l_user := FND_GLOBAL.USER_ID;
2606: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2607: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2608: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2609:
2610: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2611: IF PG_DEBUG < 10 THEN
2604: l_bridge := p_bridge;
2605: l_user := FND_GLOBAL.USER_ID;
2606: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2607: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2608: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2609:
2610: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2611: IF PG_DEBUG < 10 THEN
2612: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id ||