DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on FND_GLOBAL

Line 845: l_user := FND_GLOBAL.USER_ID;

841: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
842: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
843: END IF;
844:
845: l_user := FND_GLOBAL.USER_ID;
846: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:

Line 846: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

842: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
843: END IF;
844:
845: l_user := FND_GLOBAL.USER_ID;
846: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:
850:

Line 847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;

843: END IF;
844:
845: l_user := FND_GLOBAL.USER_ID;
846: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:
850:
851: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007

Line 848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;

844:
845: l_user := FND_GLOBAL.USER_ID;
846: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:
850:
851: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007
852: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');

Line 1162: -- ,FND_GLOBAL.USER_ID

1158: -- ,l_universe(1)
1159: -- ,l_object_type
1160: -- ,1
1161: -- ,sysdate
1162: -- ,FND_GLOBAL.USER_ID
1163: -- ,FND_GLOBAL.USER_ID
1164: -- ,sysdate
1165: -- ,FND_GLOBAL.USER_ID
1166: -- ,l_scores_tbl(1)

Line 1163: -- ,FND_GLOBAL.USER_ID

1159: -- ,l_object_type
1160: -- ,1
1161: -- ,sysdate
1162: -- ,FND_GLOBAL.USER_ID
1163: -- ,FND_GLOBAL.USER_ID
1164: -- ,sysdate
1165: -- ,FND_GLOBAL.USER_ID
1166: -- ,l_scores_tbl(1)
1167: -- ,p_score_id

Line 1165: -- ,FND_GLOBAL.USER_ID

1161: -- ,sysdate
1162: -- ,FND_GLOBAL.USER_ID
1163: -- ,FND_GLOBAL.USER_ID
1164: -- ,sysdate
1165: -- ,FND_GLOBAL.USER_ID
1166: -- ,l_scores_tbl(1)
1167: -- ,p_score_id
1168: -- ,nvl(FND_GLOBAL.Conc_REQUEST_ID,0));
1169: --

Line 1168: -- ,nvl(FND_GLOBAL.Conc_REQUEST_ID,0));

1164: -- ,sysdate
1165: -- ,FND_GLOBAL.USER_ID
1166: -- ,l_scores_tbl(1)
1167: -- ,p_score_id
1168: -- ,nvl(FND_GLOBAL.Conc_REQUEST_ID,0));
1169: --
1170: -- END IF;
1171: --
1172: -- return l_scores_tbl(1);

Line 1811: l_user := FND_GLOBAL.USER_ID;

1807: IF PG_DEBUG < 10 THEN
1808: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
1809: END IF;
1810:
1811: l_user := FND_GLOBAL.USER_ID;
1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1813: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1815:

Line 1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

1808: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
1809: END IF;
1810:
1811: l_user := FND_GLOBAL.USER_ID;
1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1813: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1815:
1816: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?

Line 1813: l_program := FND_GLOBAL.CONC_PROGRAM_ID;

1809: END IF;
1810:
1811: l_user := FND_GLOBAL.USER_ID;
1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1813: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1815:
1816: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1817: IF PG_DEBUG < 10 THEN

Line 1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;

1810:
1811: l_user := FND_GLOBAL.USER_ID;
1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1813: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1815:
1816: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1817: IF PG_DEBUG < 10 THEN
1818: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);

Line 1924: l_user := FND_GLOBAL.USER_ID;

1920: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Insert records!' );
1921: END IF;
1922:
1923: l_bridge := p_bridge;
1924: l_user := FND_GLOBAL.USER_ID;
1925: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1926: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1928:

Line 1925: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

1921: END IF;
1922:
1923: l_bridge := p_bridge;
1924: l_user := FND_GLOBAL.USER_ID;
1925: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1926: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1928:
1929: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?

Line 1926: l_program := FND_GLOBAL.CONC_PROGRAM_ID;

1922:
1923: l_bridge := p_bridge;
1924: l_user := FND_GLOBAL.USER_ID;
1925: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1926: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1928:
1929: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1930: IF PG_DEBUG < 10 THEN

Line 1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;

1923: l_bridge := p_bridge;
1924: l_user := FND_GLOBAL.USER_ID;
1925: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
1926: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1928:
1929: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1930: IF PG_DEBUG < 10 THEN
1931: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);