APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_WARRANTY_CONT_CTR_TL

Line 625: INSERT INTO AHL_WARRANTY_CONT_CTR_TL

621: NULL,
622: NULL
623: );
624:
625: INSERT INTO AHL_WARRANTY_CONT_CTR_TL
626: (
627: WARRANTY_CNTRT_COUNTER_ID,
628: LANGUAGE,
629: SOURCE_LANG,

Line 659: FROM AHL_WARRANTY_CONT_CTR_TL T

655: AND AWTCL.LANGUAGE (+) = L.LANGUAGE_CODE
656: AND L.INSTALLED_FLAG IN ('I', 'B')
657: AND NOT EXISTS
658: (SELECT 'X'
659: FROM AHL_WARRANTY_CONT_CTR_TL T
660: WHERE T.WARRANTY_CNTRT_COUNTER_ID = l_warranty_cont_ctr_id
661: AND T.LANGUAGE = L.LANGUAGE_CODE);
662:
663: END LOOP;

Line 857: -- AHL_WARRANTY_CONT_CTR_TL

853: -- Function : Procedure created using utility:$FND_TOP/bin/AFTBLGEN
854: -- To add language dependent rows to tables.
855: -- This procedure adds rows in below two tables
856: -- AHL_WARRANTY_CONTRACTS_TL
857: -- AHL_WARRANTY_CONT_CTR_TL
858: -- Pre-reqs :
859: -- Parameters :
860: --
861: -- End of Comments

Line 952: -- for table AHL_WARRANTY_CONT_CTR_TL

948: from AHL_WARRANTY_CONTRACTS_TL T
949: where T.WARRANTY_CONTRACT_ID = B.WARRANTY_CONTRACT_ID
950: and T.LANGUAGE = L.LANGUAGE_CODE);
951:
952: -- for table AHL_WARRANTY_CONT_CTR_TL
953: delete from AHL_WARRANTY_CONT_CTR_TL T
954: where not exists
955: (select NULL
956: from AHL_WARRANTY_CONT_CTR_B B

Line 953: delete from AHL_WARRANTY_CONT_CTR_TL T

949: where T.WARRANTY_CONTRACT_ID = B.WARRANTY_CONTRACT_ID
950: and T.LANGUAGE = L.LANGUAGE_CODE);
951:
952: -- for table AHL_WARRANTY_CONT_CTR_TL
953: delete from AHL_WARRANTY_CONT_CTR_TL T
954: where not exists
955: (select NULL
956: from AHL_WARRANTY_CONT_CTR_B B
957: where B.WARRANTY_CNTRT_COUNTER_ID = T.WARRANTY_CNTRT_COUNTER_ID

Line 960: update AHL_WARRANTY_CONT_CTR_TL T set (

956: from AHL_WARRANTY_CONT_CTR_B B
957: where B.WARRANTY_CNTRT_COUNTER_ID = T.WARRANTY_CNTRT_COUNTER_ID
958: );
959:
960: update AHL_WARRANTY_CONT_CTR_TL T set (
961: REMARKS,
962: TERMS_AND_CONDITIONS,
963: REACTION_AND_RESOL_TIME,
964: SERVICE_LEVEL_AGREEMENT

Line 970: from AHL_WARRANTY_CONT_CTR_TL B

966: B.REMARKS,
967: B.TERMS_AND_CONDITIONS,
968: B.REACTION_AND_RESOL_TIME,
969: B.SERVICE_LEVEL_AGREEMENT
970: from AHL_WARRANTY_CONT_CTR_TL B
971: where B.WARRANTY_CNTRT_COUNTER_ID = T.WARRANTY_CNTRT_COUNTER_ID
972: and B.LANGUAGE = T.SOURCE_LANG)
973: where (
974: T.WARRANTY_CNTRT_COUNTER_ID,

Line 979: from AHL_WARRANTY_CONT_CTR_TL SUBB, AHL_WARRANTY_CONT_CTR_TL SUBT

975: T.LANGUAGE
976: ) in (select
977: SUBT.WARRANTY_CNTRT_COUNTER_ID,
978: SUBT.LANGUAGE
979: from AHL_WARRANTY_CONT_CTR_TL SUBB, AHL_WARRANTY_CONT_CTR_TL SUBT
980: where SUBB.WARRANTY_CNTRT_COUNTER_ID = SUBT.WARRANTY_CNTRT_COUNTER_ID
981: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
982: and (SUBB.REMARKS <> SUBT.REMARKS
983: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)

Line 996: insert into AHL_WARRANTY_CONT_CTR_TL (

992: or (SUBB.SERVICE_LEVEL_AGREEMENT is null and SUBT.SERVICE_LEVEL_AGREEMENT is not null)
993: or (SUBB.SERVICE_LEVEL_AGREEMENT is not null and SUBT.SERVICE_LEVEL_AGREEMENT is null)
994: ));
995:
996: insert into AHL_WARRANTY_CONT_CTR_TL (
997: WARRANTY_CNTRT_COUNTER_ID,
998: LAST_UPDATE_DATE,
999: LAST_UPDATED_BY,
1000: CREATION_DATE,

Line 1022: from AHL_WARRANTY_CONT_CTR_TL B, FND_LANGUAGES L

1018: B.REACTION_AND_RESOL_TIME,
1019: B.SERVICE_LEVEL_AGREEMENT,
1020: L.LANGUAGE_CODE,
1021: B.SOURCE_LANG
1022: from AHL_WARRANTY_CONT_CTR_TL B, FND_LANGUAGES L
1023: where L.INSTALLED_FLAG in ('I', 'B')
1024: and B.LANGUAGE = userenv('LANG')
1025: and not exists
1026: (select NULL

Line 1027: from AHL_WARRANTY_CONT_CTR_TL T

1023: where L.INSTALLED_FLAG in ('I', 'B')
1024: and B.LANGUAGE = userenv('LANG')
1025: and not exists
1026: (select NULL
1027: from AHL_WARRANTY_CONT_CTR_TL T
1028: where T.WARRANTY_CNTRT_COUNTER_ID = B.WARRANTY_CNTRT_COUNTER_ID
1029: and T.LANGUAGE = L.LANGUAGE_CODE);
1030: END ADD_LANGUAGE;
1031: