APPS.PON_CONTRACTS_TL_PKG dependencies on PON_CONTRACTS_TL

Line 1: PACKAGE BODY pon_contracts_tl_pkg AS

1: PACKAGE BODY pon_contracts_tl_pkg AS
2: /* $Header: PONCNTB.pls 120.0.12020000.2 2013/02/09 06:16:44 hvutukur ship $ */
3:
4: PROCEDURE add_language IS
5:

Line 7: INSERT INTO PON_CONTRACTS_TL (

3:
4: PROCEDURE add_language IS
5:
6: BEGIN
7: INSERT INTO PON_CONTRACTS_TL (
8: CONTRACT_ID,
9: VERSION_NUM,
10: TITLE,
11: ABSTRACT,

Line 42: FROM pon_contracts_tl cont,

38: SYSDATE,
39: cont.last_updated_by,
40: SYSDATE,
41: cont.source_lang
42: FROM pon_contracts_tl cont,
43: fnd_languages lang
44: WHERE cont.language = USERENV('LANG')
45: AND lang.INSTALLED_FLAG in ('I', 'B')
46: AND NOT EXISTS (SELECT NULL

Line 47: FROM pon_contracts_tl cont2

43: fnd_languages lang
44: WHERE cont.language = USERENV('LANG')
45: AND lang.INSTALLED_FLAG in ('I', 'B')
46: AND NOT EXISTS (SELECT NULL
47: FROM pon_contracts_tl cont2
48: WHERE cont2.contract_id = cont.contract_id
49: and cont2.version_num = cont.version_num
50: AND cont2.language = lang.language_code);
51:

Line 101: END pon_contracts_tl_pkg;

97:
98:
99: END copy_attachments;
100:
101: END pon_contracts_tl_pkg;