APPS.INV_TRANSACTION_FLOW_PVT dependencies on MTL_TRANSACTION_FLOW_LINES

Line 2442: FROM MTL_TRANSACTION_FLOW_LINES

2438: -- accuire lock for lines
2439: BEGIN
2440: SELECT FROM_ORG_ID,FROM_ORGANIZATION_ID,TO_ORG_ID,TO_ORGANIZATION_ID
2441: INTO l_from_org_id,l_from_organization_id,l_to_org_id,l_to_organization_id
2442: FROM MTL_TRANSACTION_FLOW_LINES
2443: WHERE HEADER_ID=P_HEADER_ID
2444: FOR UPDATE NOWAIT;
2445: if g_debug=1 then
2446: debug('Lock accuired for lines','Update_IC_Transaction_Flow');

Line 2873: FROM MTL_TRANSACTION_FLOW_LINES

2869: -- accuire lock for lines
2870: BEGIN
2871: SELECT FROM_ORG_ID
2872: INTO l_from_org_id
2873: FROM MTL_TRANSACTION_FLOW_LINES
2874: WHERE HEADER_ID=p_header_id
2875: AND line_number=p_line_number
2876: FOR UPDATE NOWAIT;
2877: if g_debug=1 then

Line 3299: --It will insert a row into the mtl_transaction_flow_lines

3295:
3296:
3297:
3298: -- This is a Table Handler for the header block
3299: --It will insert a row into the mtl_transaction_flow_lines
3300: --Since Update is not allowed at lines block there are no table handlers
3301: --for update and lock for the lines block
3302:
3303: PROCEDURE Insert_Trx_Flow_Lines (

Line 3335: insert into mtl_transaction_flow_lines

3331: ) IS
3332:
3333: BEGIN
3334:
3335: insert into mtl_transaction_flow_lines
3336: (
3337: header_id,
3338: line_number,
3339: from_org_id,

Line 3431: Update MTL_TRANSACTION_FLOW_LINES

3427: BEGIN
3428: if (g_debug=1) then
3429: debug('Inside UPDATE trx flow lines','Update_Trx_Flow_Lines');
3430: end if;
3431: Update MTL_TRANSACTION_FLOW_LINES
3432: SET
3433: LAST_UPDATED_BY = P_Last_Updated_By,
3434: LAST_UPDATE_LOGIN = P_Last_Update_Login,
3435: LAST_UPDATE_DATE = P_Last_Update_Date,

Line 3490: FROM MTL_TRANSACTION_FLOW_LINES

3486:
3487:
3488: CURSOR C IS
3489: SELECT *
3490: FROM MTL_TRANSACTION_FLOW_LINES
3491: WHERE header_id = P_Header_Id
3492: and Line_Number=P_Line_Number
3493: FOR UPDATE of Header_Id NOWAIT;
3494: