APPS.PO_LINE_TYPES_PKG dependencies on PO_LINE_TYPES_TL

Line 136: insert into PO_LINE_TYPES_TL (

132:
133: begin
134:
135: x_progress := '002';
136: insert into PO_LINE_TYPES_TL (
137: LAST_UPDATE_LOGIN,
138: CREATION_DATE,
139: LINE_TYPE_ID,
140: DESCRIPTION,

Line 162: from PO_LINE_TYPES_TL T

158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from PO_LINE_TYPES_TL T
163: where T.LINE_TYPE_ID = X_LINE_TYPE_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165:
166: open c;

Line 253: from PO_LINE_TYPES_TL

249: cursor c1 is select
250: LINE_TYPE,
251: DESCRIPTION,
252: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
253: from PO_LINE_TYPES_TL
254: where LINE_TYPE_ID = X_LINE_TYPE_ID
255: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
256: for update of LINE_TYPE_ID nowait;
257: begin

Line 413: update PO_LINE_TYPES_TL set

409: if (sql%notfound) then
410: raise no_data_found;
411: end if;
412:
413: update PO_LINE_TYPES_TL set
414: LINE_TYPE = X_LINE_TYPE,
415: DESCRIPTION = X_DESCRIPTION,
416: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
417: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 432: delete from PO_LINE_TYPES_TL

428: procedure DELETE_ROW (
429: X_LINE_TYPE_ID in NUMBER
430: ) is
431: begin
432: delete from PO_LINE_TYPES_TL
433: where LINE_TYPE_ID = X_LINE_TYPE_ID;
434:
435: if (sql%notfound) then
436: raise no_data_found;

Line 450: delete from PO_LINE_TYPES_TL T

446:
447: procedure ADD_LANGUAGE
448: is
449: begin
450: delete from PO_LINE_TYPES_TL T
451: where not exists
452: (select NULL
453: from PO_LINE_TYPES_B B
454: where B.LINE_TYPE_ID = T.LINE_TYPE_ID

Line 457: update PO_LINE_TYPES_TL T set (

453: from PO_LINE_TYPES_B B
454: where B.LINE_TYPE_ID = T.LINE_TYPE_ID
455: );
456:
457: update PO_LINE_TYPES_TL T set (
458: LINE_TYPE,
459: DESCRIPTION
460: ) = (select
461: B.LINE_TYPE,

Line 463: from PO_LINE_TYPES_TL B

459: DESCRIPTION
460: ) = (select
461: B.LINE_TYPE,
462: B.DESCRIPTION
463: from PO_LINE_TYPES_TL B
464: where B.LINE_TYPE_ID = T.LINE_TYPE_ID
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (
467: T.LINE_TYPE_ID,

Line 472: from PO_LINE_TYPES_TL SUBB, PO_LINE_TYPES_TL SUBT

468: T.LANGUAGE
469: ) in (select
470: SUBT.LINE_TYPE_ID,
471: SUBT.LANGUAGE
472: from PO_LINE_TYPES_TL SUBB, PO_LINE_TYPES_TL SUBT
473: where SUBB.LINE_TYPE_ID = SUBT.LINE_TYPE_ID
474: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
475: and (SUBB.LINE_TYPE <> SUBT.LINE_TYPE
476: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 481: insert into PO_LINE_TYPES_TL (

477: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
478: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
479: ));
480:
481: insert into PO_LINE_TYPES_TL (
482: LAST_UPDATE_LOGIN,
483: CREATION_DATE,
484: LINE_TYPE_ID,
485: DESCRIPTION,

Line 503: from PO_LINE_TYPES_TL B, FND_LANGUAGES L

499: B.LAST_UPDATED_BY,
500: B.CREATED_BY,
501: L.LANGUAGE_CODE,
502: B.SOURCE_LANG
503: from PO_LINE_TYPES_TL B, FND_LANGUAGES L
504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL

Line 508: from PO_LINE_TYPES_TL T

504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL
508: from PO_LINE_TYPES_TL T
509: where T.LINE_TYPE_ID = B.LINE_TYPE_ID
510: and T.LANGUAGE = L.LANGUAGE_CODE);
511: end ADD_LANGUAGE;
512:

Line 532: from PO_LINE_TYPES_TL

528: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
529:
530: select LAST_UPDATED_BY, LAST_UPDATE_DATE
531: into db_luby, db_ludate
532: from PO_LINE_TYPES_TL
533: where line_type_id = X_LINE_TYPE_ID
534: and language = userenv('LANG') ;
535:
536: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 539: update PO_LINE_TYPES_TL set

535:
536: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
537: db_ludate, X_CUSTOM_MODE)) then
538:
539: update PO_LINE_TYPES_TL set
540: line_type = X_LINE_TYPE,
541: description = X_DESCRIPTION,
542: last_update_date = f_ludate ,
543: last_updated_by = f_luby,