APPS.QPR_PN_REQUEST_HDRS_PKG dependencies on QPR_PN_REQUEST_HDRS_TL

Line 219: insert into QPR_PN_REQUEST_HDRS_TL (

215: X_LAST_UPDATED_BY,
216: X_LAST_UPDATE_LOGIN
217: );
218:
219: insert into QPR_PN_REQUEST_HDRS_TL (
220: REQUEST_HEADER_ID,
221: REFERENCE_NAME,
222: CREATION_DATE,
223: CREATED_BY,

Line 251: from QPR_PN_REQUEST_HDRS_TL T

247: from FND_LANGUAGES L
248: where L.INSTALLED_FLAG in ('I', 'B')
249: and not exists
250: (select NULL
251: from QPR_PN_REQUEST_HDRS_TL T
252: where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
253: and T.LANGUAGE = L.LANGUAGE_CODE);
254:
255: open c;

Line 402: from QPR_PN_REQUEST_HDRS_TL

398:
399: cursor c1 is select
400: REFERENCE_NAME,
401: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
402: from QPR_PN_REQUEST_HDRS_TL
403: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
404: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
405: for update of REQUEST_HEADER_ID nowait;
406: begin

Line 700: update QPR_PN_REQUEST_HDRS_TL set

696: if (sql%notfound) then
697: raise no_data_found;
698: end if;
699:
700: update QPR_PN_REQUEST_HDRS_TL set
701: REFERENCE_NAME = X_REFERENCE_NAME,
702: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
703: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
704: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 718: delete from QPR_PN_REQUEST_HDRS_TL

714: procedure DELETE_ROW (
715: X_REQUEST_HEADER_ID in NUMBER
716: ) is
717: begin
718: delete from QPR_PN_REQUEST_HDRS_TL
719: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
720:
721: if (sql%notfound) then
722: raise no_data_found;

Line 736: delete from QPR_PN_REQUEST_HDRS_TL T

732:
733: procedure ADD_LANGUAGE
734: is
735: begin
736: delete from QPR_PN_REQUEST_HDRS_TL T
737: where not exists
738: (select NULL
739: from QPR_PN_REQUEST_HDRS_B B
740: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID

Line 743: update QPR_PN_REQUEST_HDRS_TL T set (

739: from QPR_PN_REQUEST_HDRS_B B
740: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
741: );
742:
743: update QPR_PN_REQUEST_HDRS_TL T set (
744: REFERENCE_NAME
745: ) = (select
746: B.REFERENCE_NAME
747: from QPR_PN_REQUEST_HDRS_TL B

Line 747: from QPR_PN_REQUEST_HDRS_TL B

743: update QPR_PN_REQUEST_HDRS_TL T set (
744: REFERENCE_NAME
745: ) = (select
746: B.REFERENCE_NAME
747: from QPR_PN_REQUEST_HDRS_TL B
748: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
749: and B.LANGUAGE = T.SOURCE_LANG)
750: where (
751: T.REQUEST_HEADER_ID,

Line 756: from QPR_PN_REQUEST_HDRS_TL SUBB, QPR_PN_REQUEST_HDRS_TL SUBT

752: T.LANGUAGE
753: ) in (select
754: SUBT.REQUEST_HEADER_ID,
755: SUBT.LANGUAGE
756: from QPR_PN_REQUEST_HDRS_TL SUBB, QPR_PN_REQUEST_HDRS_TL SUBT
757: where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
758: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
759: and (SUBB.REFERENCE_NAME <> SUBT.REFERENCE_NAME
760: ));

Line 762: insert into QPR_PN_REQUEST_HDRS_TL (

758: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
759: and (SUBB.REFERENCE_NAME <> SUBT.REFERENCE_NAME
760: ));
761:
762: insert into QPR_PN_REQUEST_HDRS_TL (
763: REQUEST_HEADER_ID,
764: REFERENCE_NAME,
765: CREATION_DATE,
766: CREATED_BY,

Line 790: from QPR_PN_REQUEST_HDRS_TL B, FND_LANGUAGES L

786: --B.PROGRAM_APPLICATION_ID,
787: --B.REQUEST_ID,
788: L.LANGUAGE_CODE,
789: B.SOURCE_LANG
790: from QPR_PN_REQUEST_HDRS_TL B, FND_LANGUAGES L
791: where L.INSTALLED_FLAG in ('I', 'B')
792: and B.LANGUAGE = userenv('LANG')
793: and not exists
794: (select NULL

Line 795: from QPR_PN_REQUEST_HDRS_TL T

791: where L.INSTALLED_FLAG in ('I', 'B')
792: and B.LANGUAGE = userenv('LANG')
793: and not exists
794: (select NULL
795: from QPR_PN_REQUEST_HDRS_TL T
796: where T.REQUEST_HEADER_ID = B.REQUEST_HEADER_ID
797: and T.LANGUAGE = L.LANGUAGE_CODE);
798: end ADD_LANGUAGE;
799: