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.OKS_COPY_CONTRACT_PVT dependencies on OKS_K_HEADERS_B

Line 27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;

23: */
24: G_TrgHdrStartDate OKC_K_HEADERS_B.START_DATE%TYPE;
25: G_TrgHdrEndDate OKC_K_HEADERS_B.END_DATE%TYPE;
26: G_TrgHdrInvRuleID OKC_K_HEADERS_B.INV_RULE_ID%TYPE;
27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;
28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;
29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;
31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;

Line 28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;

24: G_TrgHdrStartDate OKC_K_HEADERS_B.START_DATE%TYPE;
25: G_TrgHdrEndDate OKC_K_HEADERS_B.END_DATE%TYPE;
26: G_TrgHdrInvRuleID OKC_K_HEADERS_B.INV_RULE_ID%TYPE;
27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;
28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;
29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;
31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;
32:

Line 29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

25: G_TrgHdrEndDate OKC_K_HEADERS_B.END_DATE%TYPE;
26: G_TrgHdrInvRuleID OKC_K_HEADERS_B.INV_RULE_ID%TYPE;
27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;
28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;
29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;
31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;
32:
33: ----------------------------------------------------------------------------

Line 30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;

26: G_TrgHdrInvRuleID OKC_K_HEADERS_B.INV_RULE_ID%TYPE;
27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;
28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;
29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;
31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;
32:
33: ----------------------------------------------------------------------------
34: --PL/SQL Table to check the party has already copied.

Line 31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;

27: G_TrgHdrAcctRuleID OKS_K_HEADERS_B.ACCT_RULE_ID%TYPE;
28: G_TrgHdrPeriodStart OKS_K_HEADERS_B.PERIOD_START%TYPE;
29: G_TrgHdrPeriodType OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
30: G_TrgHdrPriceUOM OKS_K_HEADERS_B.PRICE_UOM%TYPE;
31: G_TrgHdrBillingScheduleType OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE;
32:
33: ----------------------------------------------------------------------------
34: --PL/SQL Table to check the party has already copied.
35: --If Yes give the new cpl_id ----Begins

Line 13376: ,OKS_K_HEADERS_B oksH

13372: ,oksH.PRICE_UOM
13373: ,oksH.BILLING_SCHEDULE_TYPE
13374: from
13375: OKC_K_HEADERS_B okcH
13376: ,OKS_K_HEADERS_B oksH
13377: where okcH.ID = P_To_Chr_ID
13378: AND oksH.CHR_ID = okcH.ID;
13379:
13380: CURSOR GetTargetLines_F IS

Line 15501: FROM oks_k_headers_b

15497: l_module_name VARCHAR2(256) := G_APP_NAME ||'.plsql.' || G_PKG_NAME || '.' || l_api_name;
15498:
15499: CURSOR getPPAttributes IS
15500: SELECT period_type, period_start
15501: FROM oks_k_headers_b
15502: WHERE chr_id = P_Chr_ID;
15503: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15504: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15505:

Line 15503: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

15499: CURSOR getPPAttributes IS
15500: SELECT period_type, period_start
15501: FROM oks_k_headers_b
15502: WHERE chr_id = P_Chr_ID;
15503: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15504: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15505:
15506: Begin
15507: OPEN getPPAttributes;

Line 15504: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

15500: SELECT period_type, period_start
15501: FROM oks_k_headers_b
15502: WHERE chr_id = P_Chr_ID;
15503: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15504: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15505:
15506: Begin
15507: OPEN getPPAttributes;
15508: FETCH getPPAttributes INTO l_period_type,l_period_start;

Line 15600: from oks_k_headers_b

15596: ---------------------------------------------------------------------------
15597: ------------Cursor to get PRICE UOM of newly created contract--------
15598: CURSOR get_new_price_uom(P_To_Chr_ID IN NUMBER) IS
15599: select price_uom
15600: from oks_k_headers_b
15601: where chr_id = P_To_Chr_ID;
15602:
15603: l_TrgtHeaderPriceUom OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
15604: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);

Line 15603: l_TrgtHeaderPriceUom OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;

15599: select price_uom
15600: from oks_k_headers_b
15601: where chr_id = P_To_Chr_ID;
15602:
15603: l_TrgtHeaderPriceUom OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
15604: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);
15605: ----------------------------------------------------------------------------
15606: -- End Bug# 5531198 hkamdar 21-Sep-2006
15607:

Line 19218: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal

19214:
19215: End;
19216: ---------------------------------------------------------------------------------
19217: --------------------------------------------------------------------------------
19218: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal
19219: --sum of OKC_K_LINES_B.PRICE_NEGOTIATED of all top lines and OKS_K_LINES_B.TAX_AMOUNT
19220: --of all top lines respectively
19221: Begin
19222: UPDATE OKC_K_HEADERS_B a

Line 19230: UPDATE OKS_K_HEADERS_B a

19226: and b.CLE_ID IS NULL
19227: AND b.DATE_CANCELLED IS NULL) --Cancelled toplines shouldn't be included in sum.
19228: WHERE a.ID = P_To_Chr_ID;
19229:
19230: UPDATE OKS_K_HEADERS_B a
19231: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
19232: FROM
19233: OKS_K_LINES_B b
19234: ,OKC_K_LINES_B c

Line 20062: ,oks_k_headers_b b

20058: ,a.start_date
20059: ,a.end_date
20060: ,b.price_uom
20061: from okc_k_headers_b a
20062: ,oks_k_headers_b b
20063: where a.id = P_To_Chr_ID
20064: and a.id = b.chr_id;
20065:
20066: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

Line 20069: l_Target_Hdr_Price_UOM OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;

20065:
20066: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
20067: l_Hdr_Start_Date DATE;
20068: l_Hdr_End_Date DATE;
20069: l_Target_Hdr_Price_UOM OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
20070:
20071: -- Bug# 5531198 hkamdar 21-Sep-2006
20072: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);
20073: -- End Bug# 5531198 hkamdar 21-Sep-2006

Line 24565: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal

24561:
24562: End;
24563: --------------------------------------------------------------------------------
24564: --------------------------------------------------------------------------------
24565: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal
24566: --sum of OKC_K_LINES_B.PRICE_NEGOTIATED of all top lines and OKS_K_LINES_B.TAX_AMOUNT
24567: --of all top lines respectively
24568: Begin
24569: UPDATE OKC_K_HEADERS_B a

Line 24577: UPDATE OKS_K_HEADERS_B a

24573: and b.CLE_ID IS NULL
24574: AND b.DATE_CANCELLED IS NULL) --Cancelled toplines shouldn't be included in sum
24575: WHERE a.ID = P_To_Chr_ID;
24576:
24577: UPDATE OKS_K_HEADERS_B a
24578: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
24579: FROM
24580: OKS_K_LINES_B b
24581: ,OKC_K_LINES_B c

Line 25497: ,OKS_K_HEADERS_B oks

25493: oks.TRXN_EXTENSION_ID
25494: ,okc.BILL_TO_SITE_USE_ID
25495: FROM
25496: OKC_K_HEADERS_ALL_B okc
25497: ,OKS_K_HEADERS_B oks
25498: WHERE
25499: okc.id = oks.chr_id
25500: and okc.id = p_chr_id;
25501:

Line 25700: /--Call to copy source contract record in OKS_K_HEADERS_B /

25696: END IF;
25697: --================================End of Copy Contract Document===================================
25698:
25699: --===================-Start of Copy OKS Header attributes ========================================
25700: /*--Call to copy source contract record in OKS_K_HEADERS_B */
25701: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25702: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25703: FND_LOG.string(FND_LOG.level_statement
25704: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

Line 25786: UPDATE OKS_K_HEADERS_B

25782: RAISE G_EXCEPTION_HALT_VALIDATION;
25783: END IF;
25784: END IF;
25785:
25786: UPDATE OKS_K_HEADERS_B
25787: SET TRXN_EXTENSION_ID = l_Hdr_New_Trxn_Extn_ID
25788: WHERE CHR_ID = l_to_chr_id;
25789:
25790: If SQL%NOTFOUND then

Line 25794: ,'Error in Update OKS_K_HEADERS_B, row not found for update'

25790: If SQL%NOTFOUND then
25791: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25792: FND_LOG.string(FND_LOG.level_statement
25793: ,l_module_name||'.Create_Transaction_Extension'
25794: ,'Error in Update OKS_K_HEADERS_B, row not found for update'
25795: );
25796: END IF;
25797: l_return_status := FND_API.G_RET_STS_ERROR;
25798: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 26035: l_stage := 'Updating OKS_K_HEADERS_B';

26031: --end npalepu
26032: WHERE ID = P_To_Chr_ID;
26033:
26034: --Update OKS_K_HEADERS--
26035: l_stage := 'Updating OKS_K_HEADERS_B';
26036: UPDATE OKS_K_HEADERS_B
26037: SET
26038: quote_to_contact_id = NULL
26039: ,quote_to_site_id = NULL

Line 26036: UPDATE OKS_K_HEADERS_B

26032: WHERE ID = P_To_Chr_ID;
26033:
26034: --Update OKS_K_HEADERS--
26035: l_stage := 'Updating OKS_K_HEADERS_B';
26036: UPDATE OKS_K_HEADERS_B
26037: SET
26038: quote_to_contact_id = NULL
26039: ,quote_to_site_id = NULL
26040: ,quote_to_email_id = NULL

Line 26268: ,OKS_K_HEADERS_B oks

26264: oks.TRXN_EXTENSION_ID
26265: ,okc.BILL_TO_SITE_USE_ID
26266: FROM
26267: OKC_K_HEADERS_ALL_B okc
26268: ,OKS_K_HEADERS_B oks
26269: WHERE
26270: okc.id = oks.chr_id
26271: and okc.id = p_from_chr_id;
26272:

Line 26583: /--Call to copy source contract record in OKS_K_HEADERS_B /

26579: IF (l_Target_Contract_New_YN = 'Y') then
26580:
26581: --===================-Start of Copy OKS Header attributes ========================================
26582: Begin
26583: /*--Call to copy source contract record in OKS_K_HEADERS_B */
26584: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26585: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26586: FND_LOG.string(FND_LOG.level_statement
26587: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

Line 26671: UPDATE OKS_K_HEADERS_B

26667: RAISE G_EXCEPTION_HALT_VALIDATION;
26668: END IF;
26669: END IF;
26670:
26671: UPDATE OKS_K_HEADERS_B
26672: SET TRXN_EXTENSION_ID = l_Hdr_New_Trxn_Extn_ID
26673: WHERE CHR_ID = l_to_chr_id;
26674:
26675: If SQL%NOTFOUND then

Line 26679: ,'Error in Update OKS_K_HEADERS_B, row not found for update'

26675: If SQL%NOTFOUND then
26676: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26677: FND_LOG.string(FND_LOG.level_statement
26678: ,l_module_name||'.Create_Transaction_Extension'
26679: ,'Error in Update OKS_K_HEADERS_B, row not found for update'
26680: );
26681: END IF;
26682: l_return_status := FND_API.G_RET_STS_ERROR;
26683: RAISE G_EXCEPTION_HALT_VALIDATION;