eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_LINES_DET_FACTORS_PKG dependencies on ZX_LINES_DET_FACTORS

Line 1: PACKAGE BODY ZX_LINES_DET_FACTORS_PKG AS

1: PACKAGE BODY ZX_LINES_DET_FACTORS_PKG AS
2: /* $Header: zxiflinedetfactb.pls 120.21 2006/06/28 16:56:04 lxzhang ship $ */
3:
4: /* ======================================================================*
5: | Global Data Types |

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_LINES_DET_FACTORS_PKG';

4: /* ======================================================================*
5: | Global Data Types |
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_LINES_DET_FACTORS_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 24: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_LINES_DET_FACTORS_PKG.';

20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_LINES_DET_FACTORS_PKG.';
25:
26: CURSOR get_lines_det_factors(p_transaction_rec ZX_API_PUB.transaction_rec_type) IS
27: SELECT APPLICATION_ID,
28: ENTITY_CODE,

Line 49: FROM ZX_LINES_DET_FACTORS

45: INPUT_TAX_CLASSIFICATION_CODE,
46: OUTPUT_TAX_CLASSIFICATION_CODE,
47: USER_UPD_DET_FACTORS_FLAG,
48: TAX_EVENT_CLASS_CODE
49: FROM ZX_LINES_DET_FACTORS
50: WHERE application_id = p_transaction_rec.application_id
51: AND entity_code = p_transaction_rec.entity_code
52: AND event_class_code = p_transaction_rec.event_class_code
53: AND trx_id = p_transaction_rec.trx_id

Line 59: | at line level back to zx_lines_det_factors |

55:
56:
57: /* ============================================================================*
58: | PROCEDURE update_line_det_attribs : Update only the determining applicable |
59: | at line level back to zx_lines_det_factors |
60: * ===========================================================================*/
61: PROCEDURE update_line_det_attribs (
62: p_trx_biz_category IN VARCHAR2,
63: p_line_intended_use IN VARCHAR2,

Line 79: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');

75: l_return_status VARCHAR2(1);
76:
77: BEGIN
78: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');
80: END IF;
81:
82: /*-----------------------------------------+
83: | Initialize return status to SUCCESS |

Line 89: | Update zx_lines_det_factors |

85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87:
88: /*-----------------------------------------+
89: | Update zx_lines_det_factors |
90: +-----------------------------------------*/
91: UPDATE ZX_LINES_DET_FACTORS SET
92: trx_business_category = p_trx_biz_category,
93: line_intended_use = p_line_intended_use,

Line 91: UPDATE ZX_LINES_DET_FACTORS SET

87:
88: /*-----------------------------------------+
89: | Update zx_lines_det_factors |
90: +-----------------------------------------*/
91: UPDATE ZX_LINES_DET_FACTORS SET
92: trx_business_category = p_trx_biz_category,
93: line_intended_use = p_line_intended_use,
94: user_defined_fisc_class = p_user_def_fisc_class,
95: product_fisc_classification = p_prod_fisc_class,

Line 113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-');

109: AND trx_line_id = p_transaction_line_rec.trx_line_id
110: AND trx_level_type = p_transaction_line_rec.trx_level_type;
111:
112: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-');
114: END IF;
115:
116: EXCEPTION
117: WHEN OTHERS THEN

Line 146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');

142: l_event_class_rec ZX_API_PUB.event_class_rec_type;
143:
144: BEGIN
145: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');
147: END IF;
148:
149:
150: /*-----------------------------------------+

Line 217: UPDATE ZX_LINES_DET_FACTORS SET

213: CLOSE get_lines_det_factors;
214:
215:
216: FORALL i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST .. ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),

Line 239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-'||' RETURN_STATUS = ' || l_return_status);

235: AND event_class_code = p_transaction_rec.event_class_code
236: AND trx_id = p_transaction_rec.trx_id ;
237:
238: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-'||' RETURN_STATUS = ' || l_return_status);
240: END IF;
241:
242: EXCEPTION
243: WHEN OTHERS THEN

Line 257: | in zx_lines_det_factors |

253: END update_header_det_attribs;
254:
255: /* =======================================================================*
256: | PROCEDURE lock_line_det_factors : Lock all the lines of a transaction |
257: | in zx_lines_det_factors |
258: * =======================================================================*/
259: PROCEDURE lock_line_det_factors (
260: p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
261: x_return_status OUT NOCOPY VARCHAR2

Line 302: END ZX_LINES_DET_FACTORS_PKG;

298:
299: END IF;
300: END lock_line_det_factors;
301:
302: END ZX_LINES_DET_FACTORS_PKG;
303: