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.IEX_SCORE_PVT dependencies on IEX_SCORE_PUB

Line 15: P_Score_rec IN IEX_SCORE_PUB.SCORE_REC_TYPE,

11: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
12: PG_DEBUG NUMBER ;
13:
14: Procedure Validate_Score(P_Init_Msg_List IN VARCHAR2 ,
15: P_Score_rec IN IEX_SCORE_PUB.SCORE_REC_TYPE,
16: X_Dup_Status OUT NOCOPY VARCHAR2,
17: X_Return_Status OUT NOCOPY VARCHAR2,
18: X_Msg_Count OUT NOCOPY NUMBER,
19: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 21: l_score_rec IEX_SCORE_PUB.SCORE_REC_TYPE ;

17: X_Return_Status OUT NOCOPY VARCHAR2,
18: X_Msg_Count OUT NOCOPY NUMBER,
19: X_Msg_Data OUT NOCOPY VARCHAR2)
20: IS
21: l_score_rec IEX_SCORE_PUB.SCORE_REC_TYPE ;
22:
23: BEGIN
24: l_score_rec := p_score_rec;
25:

Line 337: P_SCORE_REC IN IEX_SCORE_PUB.SCORE_REC_TYPE,

333:
334: PROCEDURE Create_Score(p_api_version IN NUMBER := 1.0,
335: p_init_msg_list IN VARCHAR2 ,
336: p_commit IN VARCHAR2 ,
337: P_SCORE_REC IN IEX_SCORE_PUB.SCORE_REC_TYPE,
338: x_dup_status OUT NOCOPY VARCHAR2,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,

Line 354: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;

350: l_return_status VARCHAR2(1);
351: l_msg_count NUMBER;
352: l_msg_data VARCHAR2(32767);
353: l_rowid Varchar2(50);
354: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;
355: l_score_id NUMBER ;
356: l_msg Varchar2(50);
357:
358: BEGIN

Line 568: P_SCORE_REC IN IEX_SCORE_PUB.SCORE_REC_TYPE,

564:
565: Procedure Update_Score(p_api_version IN NUMBER := 1.0,
566: p_init_msg_list IN VARCHAR2 ,
567: p_commit IN VARCHAR2 ,
568: P_SCORE_REC IN IEX_SCORE_PUB.SCORE_REC_TYPE,
569: x_dup_status OUT NOCOPY VARCHAR2,
570: x_return_status OUT NOCOPY VARCHAR2,
571: x_msg_count OUT NOCOPY NUMBER,
572: x_msg_data OUT NOCOPY VARCHAR2)

Line 606: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;

602: l_return_status VARCHAR2(1);
603: l_msg_count NUMBER;
604: l_msg_data VARCHAR2(32767);
605: l_rowid Varchar2(50);
606: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;
607: l_score_id NUMBER ;
608: l_SCORE_REF_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;
609:
610:

Line 608: l_SCORE_REF_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;

604: l_msg_data VARCHAR2(32767);
605: l_rowid Varchar2(50);
606: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;
607: l_score_id NUMBER ;
608: l_SCORE_REF_REC IEX_SCORE_PUB.SCORE_REC_TYPE ;
609:
610:
611: BEGIN
612:

Line 1067: P_SCORE_COMP_Rec IN IEX_SCORE_PUB.SCORE_COMP_Rec_TYPE,

1063:
1064: Procedure Create_SCORE_COMP(p_api_version IN NUMBER := 1.0,
1065: p_init_msg_list IN VARCHAR2 ,
1066: p_commit IN VARCHAR2 ,
1067: P_SCORE_COMP_Rec IN IEX_SCORE_PUB.SCORE_COMP_Rec_TYPE,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2,
1071: x_SCORE_COMP_ID OUT NOCOPY NUMBER)

Line 1085: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;

1081: l_return_status VARCHAR2(1);
1082: l_msg_count NUMBER;
1083: l_msg_data VARCHAR2(32767);
1084: l_rowid Varchar2(50);
1085: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
1086: l_msg Varchar2(50);
1087:
1088: BEGIN
1089: l_SCORE_COMP_REC := p_score_comp_rec;

Line 1246: P_SCORE_COMP_Rec IN IEX_SCORE_PUB.SCORE_COMP_Rec_TYPE,

1242:
1243: Procedure Update_SCORE_COMP(p_api_version IN NUMBER := 1.0,
1244: p_init_msg_list IN VARCHAR2 ,
1245: p_commit IN VARCHAR2 ,
1246: P_SCORE_COMP_Rec IN IEX_SCORE_PUB.SCORE_COMP_Rec_TYPE,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_msg_count OUT NOCOPY NUMBER,
1249: x_msg_data OUT NOCOPY VARCHAR2)
1250:

Line 1274: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;

1270: l_return_status VARCHAR2(1);
1271: l_msg_count NUMBER;
1272: l_msg_data VARCHAR2(32767);
1273: l_rowid Varchar2(50);
1274: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
1275: l_SCORE_COMP_REF_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
1276:
1277:
1278: BEGIN

Line 1275: l_SCORE_COMP_REF_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;

1271: l_msg_count NUMBER;
1272: l_msg_data VARCHAR2(32767);
1273: l_rowid Varchar2(50);
1274: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
1275: l_SCORE_COMP_REF_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
1276:
1277:
1278: BEGIN
1279: l_SCORE_COMP_REC := p_score_comp_rec;

Line 1645: P_SCORE_COMP_TYPE_Rec IN IEX_SCORE_PUB.SCORE_COMP_TYPE_Rec_TYPE ,

1641: Procedure Create_SCORE_COMP_TYPE
1642: (p_api_version IN NUMBER := 1.0,
1643: p_init_msg_list IN VARCHAR2 ,
1644: p_commit IN VARCHAR2 ,
1645: P_SCORE_COMP_TYPE_Rec IN IEX_SCORE_PUB.SCORE_COMP_TYPE_Rec_TYPE ,
1646: x_dup_status OUT NOCOPY VARCHAR2,
1647: x_return_status OUT NOCOPY VARCHAR2,
1648: x_msg_count OUT NOCOPY NUMBER,
1649: x_msg_data OUT NOCOPY VARCHAR2,

Line 1664: l_SCORE_COMP_Type_REC IEX_SCORE_PUB.SCORE_COMP_Type_REC_TYPE ;

1660: l_return_status VARCHAR2(1);
1661: l_msg_count NUMBER;
1662: l_msg_data VARCHAR2(32767);
1663: l_rowid Varchar2(50);
1664: l_SCORE_COMP_Type_REC IEX_SCORE_PUB.SCORE_COMP_Type_REC_TYPE ;
1665:
1666: BEGIN
1667: l_SCORE_COMP_Type_REC := p_score_comp_type_rec;
1668:

Line 1806: P_SCORE_COMP_Type_Rec IN IEX_SCORE_PUB.SCORE_COMP_Type_Rec_TYPE,

1802: -- new column DISPLAY_ORDER
1803: Procedure Update_SCORE_COMP_TYPE(p_api_version IN NUMBER := 1.0,
1804: p_init_msg_list IN VARCHAR2 ,
1805: p_commit IN VARCHAR2 ,
1806: P_SCORE_COMP_Type_Rec IN IEX_SCORE_PUB.SCORE_COMP_Type_Rec_TYPE,
1807: x_dup_status OUT NOCOPY VARCHAR2,
1808: x_return_status OUT NOCOPY VARCHAR2,
1809: x_msg_count OUT NOCOPY NUMBER,
1810: x_msg_data OUT NOCOPY VARCHAR2)

Line 1851: l_SCORE_COMP_TYPE_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;

1847: l_return_status VARCHAR2(1);
1848: l_msg_count NUMBER;
1849: l_msg_data VARCHAR2(32767);
1850: l_rowid Varchar2(50);
1851: l_SCORE_COMP_TYPE_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;
1852: l_SCORE_COMP_TYPE_REF_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;
1853:
1854: BEGIN
1855:

Line 1852: l_SCORE_COMP_TYPE_REF_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;

1848: l_msg_count NUMBER;
1849: l_msg_data VARCHAR2(32767);
1850: l_rowid Varchar2(50);
1851: l_SCORE_COMP_TYPE_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;
1852: l_SCORE_COMP_TYPE_REF_REC IEX_SCORE_PUB.SCORE_COMP_TYPE_REC_TYPE ;
1853:
1854: BEGIN
1855:
1856: l_SCORE_COMP_TYPE_REC := p_score_comp_type_rec;

Line 2204: p_SCORE_COMP_DET_REC IN IEX_SCORE_PUB.SCORE_COMP_DET_REC_Type,

2200:
2201: Procedure Create_SCORE_COMP_DET(p_api_version IN NUMBER := 1.0,
2202: p_init_msg_list IN VARCHAR2 ,
2203: p_commit IN VARCHAR2 ,
2204: p_SCORE_COMP_DET_REC IN IEX_SCORE_PUB.SCORE_COMP_DET_REC_Type,
2205: x_return_status OUT NOCOPY VARCHAR2,
2206: x_msg_count OUT NOCOPY NUMBER,
2207: x_msg_data OUT NOCOPY VARCHAR2,
2208: x_score_comp_det_id OUT NOCOPY NUMBER)

Line 2222: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;

2218: l_return_status VARCHAR2(1);
2219: l_msg_count NUMBER;
2220: l_msg_data VARCHAR2(32767);
2221: l_rowid Varchar2(50);
2222: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;
2223: l_msg Varchar2(50);
2224:
2225: BEGIN
2226: l_SCORE_COMP_DET_REC := p_SCORE_COMP_DET_REC;

Line 2373: p_SCORE_COMP_DET_Rec IN IEX_SCORE_PUB.SCORE_COMP_DET_REC_Type,

2369:
2370: Procedure Update_SCORE_COMP_DET(p_api_version IN NUMBER := 1.0,
2371: p_init_msg_list IN VARCHAR2 ,
2372: p_commit IN VARCHAR2 ,
2373: p_SCORE_COMP_DET_Rec IN IEX_SCORE_PUB.SCORE_COMP_DET_REC_Type,
2374: x_return_status OUT NOCOPY VARCHAR2,
2375: x_msg_count OUT NOCOPY NUMBER,
2376: x_msg_data OUT NOCOPY VARCHAR2)
2377:

Line 2404: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;

2400: l_return_status VARCHAR2(1);
2401: l_msg_count NUMBER;
2402: l_msg_data VARCHAR2(32767);
2403: l_rowid Varchar2(50);
2404: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;
2405: l_SCORE_COMP_DET_REF_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;
2406:
2407:
2408: BEGIN

Line 2405: l_SCORE_COMP_DET_REF_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;

2401: l_msg_count NUMBER;
2402: l_msg_data VARCHAR2(32767);
2403: l_rowid Varchar2(50);
2404: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;
2405: l_SCORE_COMP_DET_REF_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE ;
2406:
2407:
2408: BEGIN
2409:

Line 2802: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE;

2798: SCORE_ID
2799: FROM IEX_DEL_STATUSES
2800: WHERE SCORE_ID = IN_SCORE_ID;
2801: --
2802: l_SCORE_REC IEX_SCORE_PUB.SCORE_REC_TYPE;
2803: l_score_id NUMBER ;
2804: l_len NUMBER ;
2805: l_add NUMBER ;
2806: l_score_name VARCHAR2(256);

Line 2808: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;

2804: l_len NUMBER ;
2805: l_add NUMBER ;
2806: l_score_name VARCHAR2(256);
2807: l_tmp_score_name VARCHAR2(60);
2808: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
2809: l_score_comp_id NUMBER ;
2810: l_score_comp_id_new NUMBER ;
2811: l_score_comp_id_tbl DBMS_SQL.NUMBER_TABLE;
2812: l_score_comp_id_new_tbl DBMS_SQL.NUMBER_TABLE;

Line 2813: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE;

2809: l_score_comp_id NUMBER ;
2810: l_score_comp_id_new NUMBER ;
2811: l_score_comp_id_tbl DBMS_SQL.NUMBER_TABLE;
2812: l_score_comp_id_new_tbl DBMS_SQL.NUMBER_TABLE;
2813: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE;
2814: l_score_comp_det_id NUMBER;
2815: idx NUMBER;
2816: newidx NUMBER;
2817: l_FILTER_REC IEX_FILTER_PUB.FILTER_REC_TYPE;

Line 3049: --l_score_comp_det_rec := IEX_SCORE_PUB.G_MISS_SCORE_COMP_DET_REC;

3045:
3046: FOR s in C_GET_SCORE_COMP_DET (l_score_comp_id)
3047: LOOP
3048: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdet loop');
3049: --l_score_comp_det_rec := IEX_SCORE_PUB.G_MISS_SCORE_COMP_DET_REC;
3050: l_score_comp_det_rec := null;
3051: l_score_comp_det_id := s.score_comp_det_id;
3052: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdetid='||l_score_comp_det_id);
3053: Open C_Get_Score_Comp_Det_Rec(l_score_comp_det_id);

Line 3320: l_score_comp_tbl IEX_SCORE_PUB.SCORE_ENG_COMP_TBL;

3316:
3317: l_score NUMBER;
3318: l_count NUMBER;
3319: l_score_id NUMBER := NULL;
3320: l_score_comp_tbl IEX_SCORE_PUB.SCORE_ENG_COMP_TBL;
3321: l_components_count NUMBER;
3322: i NUMBER := 0;
3323: l_party_id NUMBER;
3324: l_party_count NUMBER := 0;

Line 3560: X_SCORE_COMP_TBL OUT NOCOPY IEX_SCORE_PUB.SCORE_ENG_COMP_TBL)

3556: /* this procedure will return the components for a score engine, if no score_id is passed, then it will pick
3557: up the profile IEX_USE_THIS_SCORE to determine the engine to use
3558: */
3559: PROCEDURE Get_Components(P_SCORE_ID IN OUT NOCOPY NUMBER,
3560: X_SCORE_COMP_TBL OUT NOCOPY IEX_SCORE_PUB.SCORE_ENG_COMP_TBL)
3561: IS
3562:
3563: l_score_comp_tbl IEX_SCORE_PUB.SCORE_ENG_COMP_TBL;
3564:

Line 3563: l_score_comp_tbl IEX_SCORE_PUB.SCORE_ENG_COMP_TBL;

3559: PROCEDURE Get_Components(P_SCORE_ID IN OUT NOCOPY NUMBER,
3560: X_SCORE_COMP_TBL OUT NOCOPY IEX_SCORE_PUB.SCORE_ENG_COMP_TBL)
3561: IS
3562:
3563: l_score_comp_tbl IEX_SCORE_PUB.SCORE_ENG_COMP_TBL;
3564:
3565: i NUMBER := 0;
3566: l_score_id NUMBER;
3567: l_score_engine_name VARCHAR2(50);