DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_QUALIFIERS

Line 9408: -- copy_oks_qualifiers

9404:
9405: End copy_oks_rev_distributions;
9406:
9407: --===================================================
9408: -- copy_oks_qualifiers
9409: -- Parameters: P_From_Chr_ID : Header ID of source contract
9410: -- P_To_Chr_ID : Header ID of target contract
9411: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9412: -- or as part of component copy from UI (value = 'Y')

Line 9414: PROCEDURE copy_oks_qualifiers(P_From_Chr_ID IN NUMBER

9410: -- P_To_Chr_ID : Header ID of target contract
9411: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
9412: -- or as part of component copy from UI (value = 'Y')
9413: --====================================================
9414: PROCEDURE copy_oks_qualifiers(P_From_Chr_ID IN NUMBER
9415: ,P_To_Chr_ID IN NUMBER
9416: ,P_Partial_Copy_YN IN VARCHAR2
9417: ,P_Lines_Count IN NUMBER DEFAULT 0
9418: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 9420: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_QUALIFIERS';

9416: ,P_Partial_Copy_YN IN VARCHAR2
9417: ,P_Lines_Count IN NUMBER DEFAULT 0
9418: ,x_return_status OUT NOCOPY VARCHAR2) IS
9419:
9420: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_QUALIFIERS';
9421: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
9422:
9423: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9424:

Line 9470: OKS_QUALIFIERS oksQ

9466: , oksQ.QUAL_ATTR_VALUE_FROM_NUMBER AS oksQ_QUAL_ATTRVALUE_FROM_NUM
9467: , oksQ.QUAL_ATTR_VALUE_TO_NUMBER AS oksQ_QUAL_ATTRVALUE_TO_NUM
9468: , oksQ.SECURITY_GROUP_ID AS oksQ_SECURITY_GROUP_ID
9469: FROM
9470: OKS_QUALIFIERS oksQ
9471: ,OKC_K_LINES_B okcB
9472: WHERE
9473: oksQ.LIST_LINE_ID = okcB.ORIG_SYSTEM_ID1
9474: AND okcB.CLE_ID IS NULL --Qualifiers are only for Top Lines

Line 9522: OKS_QUALIFIERS oksQ

9518: , oksQ.QUAL_ATTR_VALUE_FROM_NUMBER AS oksQ_QUAL_ATTRVALUE_FROM_NUM
9519: , oksQ.QUAL_ATTR_VALUE_TO_NUMBER AS oksQ_QUAL_ATTRVALUE_TO_NUM
9520: , oksQ.SECURITY_GROUP_ID AS oksQ_SECURITY_GROUP_ID
9521: FROM
9522: OKS_QUALIFIERS oksQ
9523: ,OKC_K_LINES_B_TEMP okcBT
9524: WHERE
9525: oksQ.LIST_LINE_ID = okcBT.ORIG_SYSTEM_ID1
9526: AND okcBT.CLE_ID IS NULL --Qualifiers are only for Top Lines

Line 9629: INSERT INTO OKS_QUALIFIERS(

9625: , OksQRecTab.OksQ_SECURITY_GROUP_ID LIMIT G_BULK_FETCH_LIMIT;
9626: End If;
9627:
9628: FORALL i IN OksQRecTab.OksQ_NewQualifierID.FIRST .. OksQRecTab.OksQ_NewQualifierID.LAST
9629: INSERT INTO OKS_QUALIFIERS(
9630: QUALIFIER_ID
9631: , REQUEST_ID
9632: , PROGRAM_APPLICATION_ID
9633: , PROGRAM_ID

Line 9751: End copy_oks_qualifiers;

9747: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
9748: RAISE;
9749:
9750:
9751: End copy_oks_qualifiers;
9752:
9753: -----------------------------------------------------------
9754: --===================================================
9755: -- copy_oks_coverage_timezones

Line 19545: -------------Copy of OKS_QUALIFIERS----------------------------------

19541: RAISE G_EXCEPTION_HALT_VALIDATION;
19542: End If;
19543: End;
19544: ---------------------------------------------------------------------
19545: -------------Copy of OKS_QUALIFIERS----------------------------------
19546: Begin
19547: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19548: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19549: FND_LOG.string(FND_LOG.level_statement

Line 19550: ,l_module_name||'.copy_oks_qualifiers'

19546: Begin
19547: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19548: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19549: FND_LOG.string(FND_LOG.level_statement
19550: ,l_module_name||'.copy_oks_qualifiers'
19551: ,'Before call to copy_oks_qualifiers'
19552: );
19553: END IF;
19554: END IF;

Line 19551: ,'Before call to copy_oks_qualifiers'

19547: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19548: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19549: FND_LOG.string(FND_LOG.level_statement
19550: ,l_module_name||'.copy_oks_qualifiers'
19551: ,'Before call to copy_oks_qualifiers'
19552: );
19553: END IF;
19554: END IF;
19555:

Line 19556: copy_oks_qualifiers(P_From_Chr_ID => P_From_Chr_ID

19552: );
19553: END IF;
19554: END IF;
19555:
19556: copy_oks_qualifiers(P_From_Chr_ID => P_From_Chr_ID
19557: ,P_To_Chr_ID => P_To_Chr_ID
19558: ,P_Partial_Copy_YN => 'N'
19559: ,x_return_status => l_return_status);
19560:

Line 19564: ,l_module_name||'.copy_oks_qualifiers'

19560:
19561: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19562: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19563: FND_LOG.string(FND_LOG.level_statement
19564: ,l_module_name||'.copy_oks_qualifiers'
19565: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status
19566: ||' '||SQLERRM
19567: );
19568: END IF;

Line 19565: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status

19561: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19562: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19563: FND_LOG.string(FND_LOG.level_statement
19564: ,l_module_name||'.copy_oks_qualifiers'
19565: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status
19566: ||' '||SQLERRM
19567: );
19568: END IF;
19569: END IF;

Line 24880: -------------Copy of OKS_QUALIFIERS----------------------------------

24876: End If;
24877: End;
24878: END IF;
24879: ---------------------------------------------------------------------
24880: -------------Copy of OKS_QUALIFIERS----------------------------------
24881: IF (P_Lines_Tbl.COUNT > 0) then
24882: Begin
24883: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24884: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24886: ,l_module_name||'.copy_oks_qualifiers'

24882: Begin
24883: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24884: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24885: FND_LOG.string(FND_LOG.level_statement
24886: ,l_module_name||'.copy_oks_qualifiers'
24887: ,'Before call to copy_oks_qualifiers'
24888: );
24889: END IF;
24890: END IF;

Line 24887: ,'Before call to copy_oks_qualifiers'

24883: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24884: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24885: FND_LOG.string(FND_LOG.level_statement
24886: ,l_module_name||'.copy_oks_qualifiers'
24887: ,'Before call to copy_oks_qualifiers'
24888: );
24889: END IF;
24890: END IF;
24891:

Line 24892: copy_oks_qualifiers(P_From_Chr_ID => P_From_Chr_ID

24888: );
24889: END IF;
24890: END IF;
24891:
24892: copy_oks_qualifiers(P_From_Chr_ID => P_From_Chr_ID
24893: ,P_To_Chr_ID => P_To_Chr_ID
24894: ,P_Partial_Copy_YN => 'Y'
24895: ,P_Lines_Count => P_Lines_Tbl.COUNT
24896: ,x_return_status => l_return_status);

Line 24901: ,l_module_name||'.copy_oks_qualifiers'

24897:
24898: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24899: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24900: FND_LOG.string(FND_LOG.level_statement
24901: ,l_module_name||'.copy_oks_qualifiers'
24902: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status
24903: ||' '||SQLERRM
24904: );
24905: END IF;

Line 24902: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status

24898: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24899: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24900: FND_LOG.string(FND_LOG.level_statement
24901: ,l_module_name||'.copy_oks_qualifiers'
24902: ,'After call to copy_oks_qualifiers: x_return_status:'||l_return_status
24903: ||' '||SQLERRM
24904: );
24905: END IF;
24906: END IF;