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.INV_TRANSACTION_FLOW_PVT dependencies on MTL_TRANSACTION_FLOW_HEADERS

Line 200: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

196: -- check duplicate
197: BEGIN
198:
199: SELECT 1 INTO l_count FROM DUAL
200: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
201: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
202: AND START_ORG_ID=P_START_ORG_ID
203: AND END_ORG_ID=P_END_ORG_ID
204: AND FLOW_TYPE=P_FLOW_TYPE

Line 258: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

254: --overlap check
255: BEGIN
256: -- check if a transaction flow with start date < p_start_date
257: SELECT 1 INTO l_count FROM DUAL
258: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
259: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
260: AND START_ORG_ID=P_START_ORG_ID
261: AND END_ORG_ID=P_END_ORG_ID
262: AND FLOW_TYPE=P_FLOW_TYPE

Line 285: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

281: BEGIN
282: --check if a transaction flow with null end date and
283: --start date < p_start_date exists
284: SELECT 1 INTO l_count FROM DUAL
285: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
286: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
287: AND START_ORG_ID=P_START_ORG_ID
288: AND END_ORG_ID=P_END_ORG_ID
289: AND FLOW_TYPE=P_FLOW_TYPE

Line 312: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

308: BEGIN
309: -- check if a transaction flow with not null end date
310: --and start date < p_start_date exists
311: SELECT 1 INTO l_count FROM DUAL
312: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
313: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
314: AND START_ORG_ID=P_START_ORG_ID
315: AND END_ORG_ID=P_END_ORG_ID
316: AND FLOW_TYPE=P_FLOW_TYPE

Line 342: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

338: END;
339: */
340: BEGIN
341: SELECT 1 INTO l_count FROM DUAL
342: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
343: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
344: AND START_ORG_ID=P_START_ORG_ID
345: AND END_ORG_ID=P_END_ORG_ID
346: AND FLOW_TYPE=P_FLOW_TYPE

Line 413: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

409: IF p_end_date IS NULL THEN
410: -- All transaction flows with same attributes should have end date less then the start date of this transaction
411: BEGIN
412: SELECT 1 INTO l_count FROM DUAL
413: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
414: WHERE START_ORG_ID=P_START_ORG_ID
415: AND HEADER_ID <> NVL(P_HEADER_ID,-999)
416: AND END_ORG_ID=P_END_ORG_ID
417: AND FLOW_TYPE=P_FLOW_TYPE

Line 443: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

439: -- Then new Inter-company Transaction Flow can only be
440: -- defined for End Date less then
441: -- the Start Date of existing Inter-company Transaction Flow
442: SELECT 1 INTO l_count FROM DUAL
443: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
444: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
445: AND START_ORG_ID=P_START_ORG_ID
446: AND END_ORG_ID=P_END_ORG_ID
447: AND FLOW_TYPE=P_FLOW_TYPE

Line 467: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

463: -- End Date should be less than the Start Date of any other Inter-company
464: -- Transaction Flow with same attributes and Start Date greater than the
465: -- Start Date of current Inter-company Transaction Flow
466: SELECT 1 INTO l_count FROM DUAL
467: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
468: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
469: AND START_ORG_ID=P_START_ORG_ID
470: AND END_ORG_ID=P_END_ORG_ID
471: AND FLOW_TYPE=P_FLOW_TYPE

Line 499: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

495:
496: */
497: BEGIN
498: SELECT 1 INTO l_count FROM DUAL
499: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
500: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
501: AND START_ORG_ID=P_START_ORG_ID
502: AND END_ORG_ID=P_END_ORG_ID
503: AND FLOW_TYPE=P_FLOW_TYPE

Line 545: FROM MTL_TRANSACTION_FLOW_HEADERS

541: P_QUALIFIER_VALUE_ID IN NUMBER
542: )IS
543: CURSOR DATES(p_sysdate DATE) IS
544: SELECT START_DATE,END_DATE
545: FROM MTL_TRANSACTION_FLOW_HEADERS
546: WHERE START_ORG_ID=P_START_ORG_ID
547: AND END_ORG_ID=P_END_ORG_ID
548: AND FLOW_TYPE=P_FLOW_TYPE
549: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 570: FROM MTL_TRANSACTION_FLOW_HEADERS

566: -- get trx flow with min start date and end date > sysdate or null
567: BEGIN
568: SELECT MIN(START_DATE)
569: INTO l_start_date
570: FROM MTL_TRANSACTION_FLOW_HEADERS
571: WHERE START_ORG_ID=P_START_ORG_ID
572: AND END_ORG_ID=P_END_ORG_ID
573: AND FLOW_TYPE=P_FLOW_TYPE
574: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 700: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

696: -- If a transaction flow with NULL end date exists then no other
697: --transaction flow can be created
698: BEGIN
699: SELECT 1 INTO l_count FROM DUAL
700: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
701: WHERE START_ORG_ID=P_START_ORG_ID
702: AND END_ORG_ID=P_END_ORG_ID
703: AND FLOW_TYPE=P_FLOW_TYPE
704: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 727: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS

723: -- if no trx flow with same attributes and end_date greater than sysdate or null exists
724: -- then default the start date to sysdate
725: BEGIN
726: SELECT 1 INTO l_count FROM DUAL
727: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
728: WHERE START_ORG_ID=P_START_ORG_ID
729: AND END_ORG_ID=P_END_ORG_ID
730: AND FLOW_TYPE=P_FLOW_TYPE
731: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 804: SELECT MAX(END_DATE) INTO L_START_DATE FROM MTL_TRANSACTION_FLOW_HEADERS

800: ELSE
801: -- set the start date to max of end date
802: debug('gap exists is false','Get_Default_Dates');
803: BEGIN
804: SELECT MAX(END_DATE) INTO L_START_DATE FROM MTL_TRANSACTION_FLOW_HEADERS
805: WHERE START_ORG_ID=P_START_ORG_ID
806: AND END_ORG_ID=P_END_ORG_ID
807: AND FLOW_TYPE=P_FLOW_TYPE
808: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 854: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS

850: RETURN FALSE;
851: ELSIF p_start_date>p_ref_date THEN
852: -- a transaction flow with end date = start_date-1second should exists
853: BEGIN
854: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS
855: WHERE START_ORG_ID=P_START_ORG_ID
856: AND END_ORG_ID=P_END_ORG_ID
857: AND FLOW_TYPE=P_FLOW_TYPE
858: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 882: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS

878: ELSE -- gap may exists at end also
879: IF p_start_date>p_ref_date THEN
880: BEGIN
881: -- check gap for start date
882: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS
883: WHERE START_ORG_ID=P_START_ORG_ID
884: AND END_ORG_ID=P_END_ORG_ID
885: AND FLOW_TYPE=P_FLOW_TYPE
886: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 904: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS

900: END IF;
901:
902: -- check gap for end date
903: BEGIN
904: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS
905: WHERE START_ORG_ID=P_START_ORG_ID
906: AND END_ORG_ID=P_END_ORG_ID
907: AND FLOW_TYPE=P_FLOW_TYPE
908: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 926: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS

922: -- if control is coming to this place means that a transaction flow
923: -- with start date greater the end date of current trx flow exists
924: -- we need to check for gap due to end date
925: BEGIN
926: SELECT 1 INTO l_count FROM MTL_TRANSACTION_FLOW_HEADERS
927: WHERE START_ORG_ID=P_START_ORG_ID
928: AND END_ORG_ID=P_END_ORG_ID
929: AND FLOW_TYPE=P_FLOW_TYPE
930: AND NVL(ORGANIZATION_ID,-999)=NVL(P_ORGANIZATION_ID,-999)

Line 2420: FROM MTL_TRANSACTION_FLOW_HEADERS

2416: SELECT START_ORG_ID,END_ORG_ID,FLOW_TYPE,ORGANIZATION_ID,
2417: QUALIFIER_CODE,QUALIFIER_VALUE_ID,START_DATE,END_DATE
2418: INTO l_start_org_id,l_end_org_id,l_flow_type,l_organization_id,
2419: l_qualifier_code,l_qualifier_value_id,l_start_date,l_end_date
2420: FROM MTL_TRANSACTION_FLOW_HEADERS
2421: WHERE HEADER_ID=P_HEADER_ID
2422: FOR UPDATE OF START_DATE,END_DATE NOWAIT;
2423: if g_debug=1 then
2424: debug('Lock accuired for header','Update_IC_Transaction_Flow');

Line 2699: FROM MTL_TRANSACTION_FLOW_HEADERS

2695: SELECT START_ORG_ID,END_ORG_ID,FLOW_TYPE,ORGANIZATION_ID,
2696: QUALIFIER_CODE,QUALIFIER_VALUE_ID,START_DATE,END_DATE
2697: INTO l_start_org_id,l_end_org_id,l_flow_type,l_organization_id,
2698: l_qualifier_code,l_qualifier_value_id,l_start_date,l_end_date
2699: FROM MTL_TRANSACTION_FLOW_HEADERS
2700: WHERE HEADER_ID=P_HEADER_ID
2701: FOR UPDATE OF START_DATE,END_DATE NOWAIT;
2702: if g_debug=1 then
2703: debug('Lock accuired for header','Update_IC_Txn_Flow_hdr');

Line 2972: --It will insert a row into the mtl_transaction_flow_headers

2968:
2969: /*=======================================================================================================*/
2970:
2971: -- This is a Table Handler for the header block
2972: --It will insert a row into the mtl_transaction_flow_headers
2973:
2974: PROCEDURE Insert_Trx_Flow_Header (
2975: P_Header_Id IN NUMBER,
2976: P_Start_Org_Id IN NUMBER,

Line 3011: insert into mtl_transaction_flow_headers

3007: P_Attribute15 IN VARCHAR2
3008: ) IS
3009: BEGIN
3010:
3011: insert into mtl_transaction_flow_headers
3012: (
3013: header_id,
3014: start_org_id,
3015: end_org_id,

Line 3116: Update MTL_TRANSACTION_FLOW_HEADERS

3112: BEGIN
3113: if (g_debug=1) then
3114: debug('Inside UPDATE trx flow header','Update_Trx_Flow_Header');
3115: end if;
3116: Update MTL_TRANSACTION_FLOW_HEADERS
3117: SET
3118:
3119: START_DATE = P_Start_Date,
3120: END_DATE = P_End_Date,

Line 3146: --It will lock a row for update for the mtl_transaction_flow_headers

3142: END Update_Trx_Flow_Header;
3143: /*=======================================================================================================*/
3144:
3145: -- This is a Table Handler for the header block
3146: --It will lock a row for update for the mtl_transaction_flow_headers
3147:
3148: PROCEDURE Lock_Trx_Flow_Header (
3149: P_Header_Id IN NUMBER,
3150: P_Start_Org_Id IN NUMBER,

Line 3187: FROM MTL_TRANSACTION_FLOW_HEADERS

3183:
3184:
3185: CURSOR C IS
3186: SELECT *
3187: FROM MTL_TRANSACTION_FLOW_HEADERS
3188: WHERE header_id=p_header_id
3189: FOR UPDATE of Header_Id NOWAIT;
3190:
3191: Recinfo C%ROWTYPE;