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.INVCIINT dependencies on MTL_CI_XREFS_INTERFACE

Line 3067: FROM mtl_ci_xrefs_interface

3063:
3064: --Start 3537282 : Gather stats before running
3065: IF fnd_global.conc_program_id <> -1 THEN
3066: SELECT count(*) INTO l_records
3067: FROM mtl_ci_xrefs_interface
3068: WHERE process_flag = 1;
3069:
3070: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
3071: -- option threshold

Line 3074: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_CI_XREFS_INTERFACE');

3070: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
3071: -- option threshold
3072: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
3073: IF l_schema IS NOT NULL THEN
3074: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_CI_XREFS_INTERFACE');
3075: END IF;
3076: END IF;
3077: END IF;
3078: --End 3537282 : Gather stats before running

Line 3183: FROM MTL_CI_XREFS_INTERFACE

3179: Request_Id,
3180: Program_Application_Id,
3181: Program_Id,
3182: Program_Update_Date
3183: FROM MTL_CI_XREFS_INTERFACE
3184: WHERE Process_Flag = 1
3185: AND Process_Mode = 1
3186: OR Process_Mode = 3
3187: AND UPPER(Transaction_Type) = 'CREATE'

Line 3302: 'MTL_CI_XREFS_INTERFACE', FALSE);

3298: L_Success := 3;
3299:
3300: Error_Counter := Error_Counter + 1;
3301: FND_MESSAGE.Set_Token('TABLE',
3302: 'MTL_CI_XREFS_INTERFACE', FALSE);
3303: Error_Message := FND_MESSAGE.Get;
3304: Manage_Error_Code('OUT', NULL, Curr_Error);
3305:
3306: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

Line 3306: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

3302: 'MTL_CI_XREFS_INTERFACE', FALSE);
3303: Error_Message := FND_MESSAGE.Get;
3304: Manage_Error_Code('OUT', NULL, Curr_Error);
3305:
3306: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3307: SET MCIXI.Error_Code = Curr_Error,
3308: MCIXI.Error_Explanation = substrb(Error_Message,1,235),
3309: MCIXI.Process_Mode = 2
3310: WHERE MCIXI.Rowid = Recinfo2.Row_Id;

Line 3322: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

3318: Error_Counter := Error_Counter + 1;
3319: Error_Number := SQLCODE;
3320: Error_Message := SUBSTRB(SQLERRM, 1, 512);
3321:
3322: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3323: SET MCIXI.Error_Code = TO_CHAR(Error_Number),
3324: MCIXI.Error_Explanation = substrb(Error_Message,1,235),
3325: MCIXI.Process_Mode = 2
3326: WHERE MCIXI.Rowid = Recinfo2.Row_Id;

Line 3342: 'MTL_CI_XREFS_INTERFACE', FALSE);

3338: L_Success := 3;
3339:
3340: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
3341: FND_MESSAGE.Set_Token('TABLE',
3342: 'MTL_CI_XREFS_INTERFACE', FALSE);
3343: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
3344: Error_Message := FND_MESSAGE.Get;
3345: --DBMS_OUTPUT.Put_Line(Error_Message);
3346: END IF;

Line 3360: 'MTL_CI_XREFS_INTERFACE', FALSE);

3356: L_Success := 3;
3357:
3358: Error_Counter := Error_Counter + 1;
3359: FND_MESSAGE.Set_Token('TABLE',
3360: 'MTL_CI_XREFS_INTERFACE', FALSE);
3361: Error_Message := FND_MESSAGE.Get;
3362: Manage_Error_Code('OUT', NULL, Curr_Error);
3363:
3364: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

Line 3364: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

3360: 'MTL_CI_XREFS_INTERFACE', FALSE);
3361: Error_Message := FND_MESSAGE.Get;
3362: Manage_Error_Code('OUT', NULL, Curr_Error);
3363:
3364: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3365: SET MCIXI.Error_Code = Curr_Error,
3366: MCIXI.Error_Explanation = substrb(Error_Message,1,235),
3367: MCIXI.Process_Mode = 2
3368: WHERE MCIXI.Rowid = Recinfo2.Row_Id;

Line 3385: MTL_CI_XREFS_INTERFACE are already locked by some other session.

3381:
3382:
3383: /* Fix for bug 5263099 - Added the below code to handle the scenario
3384: where Cursor CI_XRefs_Cur fails to open because the rows in
3385: MTL_CI_XREFS_INTERFACE are already locked by some other session.
3386: It leads to "ORA-00054-resource busy and acquire with NOWAIT specified" error.
3387: So we check for this error condition SQLCODE= -54.
3388: Manage_Error_Code will set the Current_Error_Code to the corresponding
3389: error msg which shall then be shown in the conc prog log file.

Line 3395: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

3391: If SQLCODE= -54 Then
3392: Manage_Error_Code('IN',substrb(Error_Message,1,235), Curr_Error);
3393: End If;
3394:
3395: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3396: SET MCIXI.Error_Code = TO_CHAR(Error_Number),
3397: MCIXI.Error_Explanation = substrb(Error_Message,1,235),
3398: MCIXI.Process_Mode = 2
3399: WHERE MCIXI.Rowid = Recinfo2.Row_Id;

Line 5676: FROM MTL_CI_XREFS_INTERFACE

5672:
5673: ELSIF ((P_Origin = 'X') AND (UPPER(P_Delete_Record) = 'Y')) THEN
5674:
5675: DELETE
5676: FROM MTL_CI_XREFS_INTERFACE
5677: WHERE Rowid = P_Temp_RowId;
5678:
5679: ELSIF ((P_Origin = 'I') AND (UPPER(P_Delete_Record) = 'N')) THEN
5680:

Line 5687: UPDATE MTL_CI_XREFS_INTERFACE

5683: WHERE Rowid = P_Temp_RowId;
5684:
5685: ELSIF ((P_Origin = 'X') AND (UPPER(P_Delete_Record) = 'N')) THEN
5686:
5687: UPDATE MTL_CI_XREFS_INTERFACE
5688: SET Process_Mode = 3
5689: WHERE Rowid = P_Temp_RowId;
5690:
5691: ELSE