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.AHL_PRD_WORKORDER_PVT dependencies on AHL_WORKORDER_TXNS

Line 4045: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );

4041: p_x_prd_workorder_rec.AOG_FLAG
4042: );
4043:
4044: IF ( G_DEBUG = 'Y' ) THEN
4045: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );
4046: END IF;
4047:
4048: INSERT INTO AHL_WORKORDER_TXNS
4049: (

Line 4048: INSERT INTO AHL_WORKORDER_TXNS

4044: IF ( G_DEBUG = 'Y' ) THEN
4045: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDER_TXNS' );
4046: END IF;
4047:
4048: INSERT INTO AHL_WORKORDER_TXNS
4049: (
4050: WORKORDER_TXN_ID,
4051: OBJECT_VERSION_NUMBER,
4052: LAST_UPDATE_DATE,

Line 4089: AHL_WORKORDER_TXNS_S.NEXTVAL,

4085: UC_HEADER_ID,
4086: NHA_UC_HEADER_ID
4087: ) VALUES
4088: (
4089: AHL_WORKORDER_TXNS_S.NEXTVAL,
4090: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,
4091: p_x_prd_workorder_rec.LAST_UPDATE_DATE,
4092: p_x_prd_workorder_rec.LAST_UPDATED_BY,
4093: p_x_prd_workorder_rec.CREATION_DATE,

Line 5191: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );

5187: END IF;
5188:
5189:
5190: IF ( G_DEBUG = 'Y' ) THEN
5191: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );
5192: END IF;
5193:
5194: INSERT INTO AHL_WORKORDER_TXNS
5195: (

Line 5194: INSERT INTO AHL_WORKORDER_TXNS

5190: IF ( G_DEBUG = 'Y' ) THEN
5191: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_TXNS' );
5192: END IF;
5193:
5194: INSERT INTO AHL_WORKORDER_TXNS
5195: (
5196: WORKORDER_TXN_ID,
5197: OBJECT_VERSION_NUMBER,
5198: LAST_UPDATE_DATE,

Line 5220: AHL_WORKORDER_TXNS_S.NEXTVAL,

5216: NHA_UC_HEADER_ID,
5217: AOG_FLAG
5218: ) VALUES
5219: (
5220: AHL_WORKORDER_TXNS_S.NEXTVAL,
5221: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
5222: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5223: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
5224: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),

Line 11024: INSERT INTO AHL_WORKORDER_TXNS

11020: l_x_prd_workorder_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_parent_wo_end_date, 'HH24' ) );
11021: l_x_prd_workorder_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_parent_wo_end_date, 'MI' ) );
11022:
11023:
11024: INSERT INTO AHL_WORKORDER_TXNS
11025: (
11026: WORKORDER_TXN_ID,
11027: OBJECT_VERSION_NUMBER,
11028: LAST_UPDATE_DATE,

Line 11045: AHL_WORKORDER_TXNS_S.NEXTVAL,

11041: COMPLETION_SUBINVENTORY,
11042: COMPLETION_LOCATOR_ID
11043: ) VALUES
11044: (
11045: AHL_WORKORDER_TXNS_S.NEXTVAL,
11046: NVL(l_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
11047: NVL(l_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
11048: NVL(l_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
11049: NVL(l_x_prd_workorder_rec.CREATION_DATE,SYSDATE),

Line 12743: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'Workorder updation over. Lets insert transaction details to AHL_WORKORDER_TXNS table');

12739: and OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM;
12740:
12741:
12742: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12743: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'Workorder updation over. Lets insert transaction details to AHL_WORKORDER_TXNS table');
12744: END IF;
12745:
12746: FOR I IN P_WORKORDER_ID_TBL.first .. P_WORKORDER_ID_TBL.last
12747: LOOP

Line 12752: -- Insert into AHL_WORKORDER_TXNS table workorder by workorder

12748: OPEN GET_WORKORDER_REC(P_WORKORDER_ID_TBL(I).WORKORDER_ID);
12749: FETCH GET_WORKORDER_REC INTO L_PRD_WORKORDER_REC;
12750: CLOSE GET_WORKORDER_REC;
12751:
12752: -- Insert into AHL_WORKORDER_TXNS table workorder by workorder
12753: INSERT INTO AHL_WORKORDER_TXNS
12754: (
12755: WORKORDER_TXN_ID,
12756: OBJECT_VERSION_NUMBER,

Line 12753: INSERT INTO AHL_WORKORDER_TXNS

12749: FETCH GET_WORKORDER_REC INTO L_PRD_WORKORDER_REC;
12750: CLOSE GET_WORKORDER_REC;
12751:
12752: -- Insert into AHL_WORKORDER_TXNS table workorder by workorder
12753: INSERT INTO AHL_WORKORDER_TXNS
12754: (
12755: WORKORDER_TXN_ID,
12756: OBJECT_VERSION_NUMBER,
12757: LAST_UPDATE_DATE,

Line 12776: AHL_WORKORDER_TXNS_S.NEXTVAL,

12772: AOG_FLAG
12773: )
12774: VALUES
12775: (
12776: AHL_WORKORDER_TXNS_S.NEXTVAL,
12777: NVL(L_PRD_WORKORDER_REC.OBJECT_VERSION_NUMBER,1),
12778: SYSDATE,
12779: FND_GLOBAL.USER_ID,
12780: SYSDATE,