DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_SECURITY

Line 354: | Call to zx_security.set_security_context |

350:
351: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl := ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).tax_regime_tbl;
352:
353: /*--------------------------------------------+
354: | Call to zx_security.set_security_context |
355: +--------------------------------------------*/
356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,
357: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).internal_organization_id,
358: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).effective_date,

Line 356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,

352:
353: /*--------------------------------------------+
354: | Call to zx_security.set_security_context |
355: +--------------------------------------------*/
356: ZX_SECURITY.set_security_context(ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).legal_entity_id,
357: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).internal_organization_id,
358: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_trx_id_index).effective_date,
359: l_return_status
360: );

Line 475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

471: */
472:
473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;

Line 476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

472:
473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;
480:

Line 477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

473: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
474: l_event_class_rec.ICX_SESSION_ID is not null THEN
475: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
476: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
477: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
478:
479: END IF;
480:
481: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user

Line 1356: ZX_SECURITY.G_ICX_SESSION_ID := null;

1352: DUMP_MSG;
1353: END IF;
1354:
1355: --Reset the icx_session_id at end of API
1356: ZX_SECURITY.G_ICX_SESSION_ID := null;
1357: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1358: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1359:
1360:

Line 1357: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1353: END IF;
1354:
1355: --Reset the icx_session_id at end of API
1356: ZX_SECURITY.G_ICX_SESSION_ID := null;
1357: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1358: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1359:
1360:
1361: --Reset G_PUB_CALLING_SRVC at end of API

Line 1358: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1354:
1355: --Reset the icx_session_id at end of API
1356: ZX_SECURITY.G_ICX_SESSION_ID := null;
1357: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1358: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1359:
1360:
1361: --Reset G_PUB_CALLING_SRVC at end of API
1362: ZX_API_PUB.G_PUB_CALLING_SRVC := null;

Line 1745: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

1741:
1742: --Set the global variable if icx_session_id is not null
1743: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1744: l_event_class_rec.ICX_SESSION_ID is not null THEN
1745: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;

Line 1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1742: --Set the global variable if icx_session_id is not null
1743: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1744: l_event_class_rec.ICX_SESSION_ID is not null THEN
1745: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;
1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1743: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
1744: l_event_class_rec.ICX_SESSION_ID is not null THEN
1745: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;
1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1751: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 1749: ZX_SECURITY.G_ICX_SESSION_ID := null;

1745: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;
1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1751: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1752: END IF;
1753:

Line 1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1746: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;
1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1751: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1752: END IF;
1753:
1754: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user

Line 1751: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

1747: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1748: ELSE
1749: ZX_SECURITY.G_ICX_SESSION_ID := null;
1750: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1751: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
1752: END IF;
1753:
1754: -- Bug 4948674: Following Delete will not work when there are different dbms sessions used for the same user
1755: -- session when call originates from a FWK UI. Moved the following Delete logic to the end of this API for O2C

Line 1944: := zx_security.g_effective_date;

1940: := l_event_class_rec.internal_organization_id;
1941: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).legal_entity_id
1942: := l_event_class_rec.legal_entity_id;
1943: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).effective_date
1944: := zx_security.g_effective_date;
1945: ZX_GLOBAL_STRUCTURES_PKG.ptnr_tax_regime_tbl(l_ptnr_index).tax_regime_tbl
1946: := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl;
1947: END IF;
1948: END IF;

Line 2212: ZX_SECURITY.G_ICX_SESSION_ID := null;

2208: DUMP_MSG;
2209: END IF;
2210:
2211: --Reset the icx_session_id at end of API
2212: ZX_SECURITY.G_ICX_SESSION_ID := null;
2213: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2214: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2215:
2216: --Reset the calling API info at end of API

Line 2213: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

2209: END IF;
2210:
2211: --Reset the icx_session_id at end of API
2212: ZX_SECURITY.G_ICX_SESSION_ID := null;
2213: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2214: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2215:
2216: --Reset the calling API info at end of API
2217: ZX_API_PUB.G_PUB_CALLING_SRVC := null;

Line 2214: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

2210:
2211: --Reset the icx_session_id at end of API
2212: ZX_SECURITY.G_ICX_SESSION_ID := null;
2213: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2214: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
2215:
2216: --Reset the calling API info at end of API
2217: ZX_API_PUB.G_PUB_CALLING_SRVC := null;
2218:

Line 5423: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;

5419: where rownum = 1;
5420:
5421: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
5422: l_event_class_rec.ICX_SESSION_ID is not null THEN
5423: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
5424: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5426:
5427: ELSE

Line 5424: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5420:
5421: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
5422: l_event_class_rec.ICX_SESSION_ID is not null THEN
5423: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
5424: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5426:
5427: ELSE
5428: ZX_SECURITY.G_ICX_SESSION_ID := null;

Line 5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5421: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
5422: l_event_class_rec.ICX_SESSION_ID is not null THEN
5423: ZX_SECURITY.G_ICX_SESSION_ID := l_event_class_rec.ICX_SESSION_ID;
5424: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5426:
5427: ELSE
5428: ZX_SECURITY.G_ICX_SESSION_ID := null;
5429: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

Line 5428: ZX_SECURITY.G_ICX_SESSION_ID := null;

5424: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5426:
5427: ELSE
5428: ZX_SECURITY.G_ICX_SESSION_ID := null;
5429: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5430: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5431:
5432: END IF;

Line 5429: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5425: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5426:
5427: ELSE
5428: ZX_SECURITY.G_ICX_SESSION_ID := null;
5429: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5430: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5431:
5432: END IF;
5433:

Line 5430: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5426:
5427: ELSE
5428: ZX_SECURITY.G_ICX_SESSION_ID := null;
5429: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5430: --dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5431:
5432: END IF;
5433:
5434: -- Check if trx line dist qty is passed when variance calc flag is 'Y'

Line 5863: ZX_SECURITY.G_ICX_SESSION_ID := null;

5859:
5860: -- Bug fix 5417887 end
5861:
5862: --Reset the icx_session_id at end of API
5863: ZX_SECURITY.G_ICX_SESSION_ID := null;
5864: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5865: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5866:
5867:

Line 5864: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5860: -- Bug fix 5417887 end
5861:
5862: --Reset the icx_session_id at end of API
5863: ZX_SECURITY.G_ICX_SESSION_ID := null;
5864: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5865: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5866:
5867:
5868: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5865: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));

5861:
5862: --Reset the icx_session_id at end of API
5863: ZX_SECURITY.G_ICX_SESSION_ID := null;
5864: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5865: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
5866:
5867:
5868: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5869: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_API_PUB: '||l_api_name||'()-');

Line 8887: | Call to zx_security.set_security_context |

8883: x_return_status := FND_API.G_RET_STS_SUCCESS;
8884:
8885:
8886: /*--------------------------------------------+
8887: | Call to zx_security.set_security_context |
8888: +--------------------------------------------*/
8889:
8890: x_effective_date := determine_effective_date(p_transaction_date,
8891: p_related_doc_date,

Line 8895: ZX_SECURITY.set_security_context(p_legal_entity_id,

8891: p_related_doc_date,
8892: p_adjusted_doc_date);
8893: l_effective_date := x_effective_date;
8894:
8895: ZX_SECURITY.set_security_context(p_legal_entity_id,
8896: p_internal_org_id,
8897: l_effective_date,
8898: l_return_status
8899: );

Line 8903: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

8899: );
8900:
8901: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8902: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8903: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');
8904: END IF;
8905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8906: RAISE FND_API.G_EXC_ERROR;
8907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 9052: | Call to zx_security.set_security_context |

9048: x_return_status := FND_API.G_RET_STS_SUCCESS;
9049:
9050:
9051: /*--------------------------------------------+
9052: | Call to zx_security.set_security_context |
9053: +--------------------------------------------*/
9054: ZX_SECURITY.set_security_context(p_legal_entity_id,
9055: p_internal_org_id,
9056: determine_effective_date(p_transaction_date,

Line 9054: ZX_SECURITY.set_security_context(p_legal_entity_id,

9050:
9051: /*--------------------------------------------+
9052: | Call to zx_security.set_security_context |
9053: +--------------------------------------------*/
9054: ZX_SECURITY.set_security_context(p_legal_entity_id,
9055: p_internal_org_id,
9056: determine_effective_date(p_transaction_date,
9057: p_related_doc_date,
9058: p_adjusted_doc_date,

Line 9063: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;

9059: p_provnl_tax_det_date),
9060: l_return_status
9061: );
9062:
9063: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;
9064:
9065: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9066: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

Line 9067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');

9063: x_effective_date := ZX_SECURITY.G_EFFECTIVE_DATE;
9064:
9065: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9066: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,G_PKG_NAME||': '||l_api_name||':ZX_SECURITY.set_security_context returned errors');
9068: END IF;
9069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9070: RAISE FND_API.G_EXC_ERROR;
9071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN