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 2006/04/12 15:57 ssthakur noship $ */
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 54: END pon_contracts_tl_pkg;

50: AND cont2.language = lang.language_code);
51:
52: END add_language;
53:
54: END pon_contracts_tl_pkg;