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 3068: FROM mtl_ci_xrefs_interface

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

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

3071: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
3072: -- option threshold
3073: 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
3074: IF l_schema IS NOT NULL THEN
3075: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_CI_XREFS_INTERFACE');
3076: END IF;
3077: END IF;
3078: END IF;
3079: --End 3537282 : Gather stats before running

Line 3184: FROM MTL_CI_XREFS_INTERFACE

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

Line 3303: 'MTL_CI_XREFS_INTERFACE', FALSE);

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

Line 3307: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

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

Line 3323: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

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

Line 3343: 'MTL_CI_XREFS_INTERFACE', FALSE);

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

Line 3361: 'MTL_CI_XREFS_INTERFACE', FALSE);

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

Line 3365: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

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

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

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

Line 3396: UPDATE MTL_CI_XREFS_INTERFACE MCIXI

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

Line 5677: FROM MTL_CI_XREFS_INTERFACE

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

Line 5688: UPDATE MTL_CI_XREFS_INTERFACE

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