APPS.CN_NOT_TRX_GRP dependencies on CN_NOT_TRX

Line 1: PACKAGE BODY CN_NOT_TRX_GRP as

1: PACKAGE BODY CN_NOT_TRX_GRP as
2: /* $Header: cngntxb.pls 120.1 2005/09/05 05:36:39 apink noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOT_TRX_GRP';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOT_TRX_GRP';

1: PACKAGE BODY CN_NOT_TRX_GRP as
2: /* $Header: cngntxb.pls 120.1 2005/09/05 05:36:39 apink noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_NOT_TRX_GRP';
5:
6: ------------------------------------------------------------------------------+
7: -- Procedure : Col_Adjustments
8: ------------------------------------------------------------------------------+

Line 24: FROM cn_not_trx

20: l_api_version CONSTANT NUMBER := 1.0;
21: -- cursor which loops through all the adjusted lines
22: CURSOR c_changed_lines IS
23: SELECT *
24: FROM cn_not_trx
25: WHERE adjusted_flag = 'Y'
26: AND collected_flag = 'N'
27: AND (negated_flag IS NULL OR negated_flag = 'N')
28: AND org_id = p_org_id; -- Added For R12 MOAC Changes

Line 59: UPDATE cn_not_trx

55: l_changed_line_rec.source_trx_line_id,
56: l_changed_line_rec.source_doc_type,
57: p_org_id);
58: -- update negated_flag to 'Y'
59: UPDATE cn_not_trx
60: SET negated_flag = 'Y'
61: WHERE not_trx_id = l_changed_line_rec.not_trx_id
62: AND org_id = p_org_id; -- Added For R12 MOAC Changes
63: END LOOP;

Line 107: END CN_NOT_TRX_GRP;

103: p_encoded => FND_API.G_FALSE);
104: END Col_Adjustments;
105:
106:
107: END CN_NOT_TRX_GRP;