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: ---Commented the plsql table definition in package body and added in package spec for bug 14387486

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: ---Commented the plsql table definition in package body and added in package spec for bug 14387486
34: /*

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: ---Commented the plsql table definition in package body and added in package spec for bug 14387486
34: /*
35: ----------------------------------------------------------------------------

Line 13421: ,OKS_K_HEADERS_B oksH

13417: ,oksH.PRICE_UOM
13418: ,oksH.BILLING_SCHEDULE_TYPE
13419: from
13420: OKC_K_HEADERS_B okcH
13421: ,OKS_K_HEADERS_B oksH
13422: where okcH.ID = P_To_Chr_ID
13423: AND oksH.CHR_ID = okcH.ID;
13424:
13425: CURSOR GetTargetLines_F IS

Line 15546: FROM oks_k_headers_b

15542: l_module_name VARCHAR2(256) := G_APP_NAME ||'.plsql.' || G_PKG_NAME || '.' || l_api_name;
15543:
15544: CURSOR getPPAttributes IS
15545: SELECT period_type, period_start
15546: FROM oks_k_headers_b
15547: WHERE chr_id = P_Chr_ID;
15548: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15549: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15550:

Line 15548: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

15544: CURSOR getPPAttributes IS
15545: SELECT period_type, period_start
15546: FROM oks_k_headers_b
15547: WHERE chr_id = P_Chr_ID;
15548: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15549: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15550:
15551: Begin
15552: OPEN getPPAttributes;

Line 15549: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

15545: SELECT period_type, period_start
15546: FROM oks_k_headers_b
15547: WHERE chr_id = P_Chr_ID;
15548: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
15549: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
15550:
15551: Begin
15552: OPEN getPPAttributes;
15553: FETCH getPPAttributes INTO l_period_type,l_period_start;

Line 15646: from oks_k_headers_b

15642: ---------------------------------------------------------------------------
15643: ------------Cursor to get PRICE UOM of newly created contract--------
15644: CURSOR get_new_price_uom(P_To_Chr_ID IN NUMBER) IS
15645: select price_uom
15646: from oks_k_headers_b
15647: where chr_id = P_To_Chr_ID;
15648:
15649: l_TrgtHeaderPriceUom OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
15650: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);

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

15645: select price_uom
15646: from oks_k_headers_b
15647: where chr_id = P_To_Chr_ID;
15648:
15649: l_TrgtHeaderPriceUom OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
15650: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);
15651: ----------------------------------------------------------------------------
15652: -- End Bug# 5531198 hkamdar 21-Sep-2006
15653:

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

19349:
19350: End;
19351: ---------------------------------------------------------------------------------
19352: --------------------------------------------------------------------------------
19353: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal
19354: --sum of OKC_K_LINES_B.PRICE_NEGOTIATED of all top lines and OKS_K_LINES_B.TAX_AMOUNT
19355: --of all top lines respectively
19356: Begin
19357: UPDATE OKC_K_HEADERS_B a

Line 19365: UPDATE OKS_K_HEADERS_B a

19361: and b.CLE_ID IS NULL
19362: AND b.DATE_CANCELLED IS NULL) --Cancelled toplines shouldn't be included in sum.
19363: WHERE a.ID = P_To_Chr_ID;
19364:
19365: UPDATE OKS_K_HEADERS_B a
19366: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
19367: FROM
19368: OKS_K_LINES_B b
19369: ,OKC_K_LINES_B c

Line 20209: ,oks_k_headers_b b

20205: ,a.start_date
20206: ,a.end_date
20207: ,b.price_uom
20208: from okc_k_headers_b a
20209: ,oks_k_headers_b b
20210: where a.id = P_To_Chr_ID
20211: and a.id = b.chr_id;
20212:
20213: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

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

20212:
20213: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
20214: l_Hdr_Start_Date DATE;
20215: l_Hdr_End_Date DATE;
20216: l_Target_Hdr_Price_UOM OKS_K_HEADERS_B.PRICE_UOM%TYPE := NULL;
20217:
20218: -- Bug# 5531198 hkamdar 21-Sep-2006
20219: l_TrgtHeaderPriceUomExists_YN VARCHAR2(1);
20220: -- End Bug# 5531198 hkamdar 21-Sep-2006

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

24756:
24757: End;
24758: --------------------------------------------------------------------------------
24759: --------------------------------------------------------------------------------
24760: --Update of OKC_K_HEADERS_B.ESTIMATED_AMOUNT and OKS_K_HEADERS_B.TAX_AMOUNT to equal
24761: --sum of OKC_K_LINES_B.PRICE_NEGOTIATED of all top lines and OKS_K_LINES_B.TAX_AMOUNT
24762: --of all top lines respectively
24763: Begin
24764: UPDATE OKC_K_HEADERS_B a

Line 24772: UPDATE OKS_K_HEADERS_B a

24768: and b.CLE_ID IS NULL
24769: AND b.DATE_CANCELLED IS NULL),0) --Cancelled toplines shouldn't be included in sum.Nvl added for 12636704
24770: WHERE a.ID = P_To_Chr_ID;
24771:
24772: UPDATE OKS_K_HEADERS_B a
24773: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
24774: FROM
24775: OKS_K_LINES_B b
24776: ,OKC_K_LINES_B c

Line 25693: ,OKS_K_HEADERS_B oks

25689: oks.TRXN_EXTENSION_ID
25690: ,okc.BILL_TO_SITE_USE_ID
25691: FROM
25692: OKC_K_HEADERS_ALL_B okc
25693: ,OKS_K_HEADERS_B oks
25694: WHERE
25695: okc.id = oks.chr_id
25696: and okc.id = p_chr_id;
25697:

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

25892: END IF;
25893: --================================End of Copy Contract Document===================================
25894:
25895: --===================-Start of Copy OKS Header attributes ========================================
25896: /*--Call to copy source contract record in OKS_K_HEADERS_B */
25897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25898: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25899: FND_LOG.string(FND_LOG.level_statement
25900: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

Line 25982: UPDATE OKS_K_HEADERS_B

25978: RAISE G_EXCEPTION_HALT_VALIDATION;
25979: END IF;
25980: END IF;
25981:
25982: UPDATE OKS_K_HEADERS_B
25983: SET TRXN_EXTENSION_ID = l_Hdr_New_Trxn_Extn_ID
25984: WHERE CHR_ID = l_to_chr_id;
25985:
25986: If SQL%NOTFOUND then

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

25986: If SQL%NOTFOUND then
25987: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25988: FND_LOG.string(FND_LOG.level_statement
25989: ,l_module_name||'.Create_Transaction_Extension'
25990: ,'Error in Update OKS_K_HEADERS_B, row not found for update'
25991: );
25992: END IF;
25993: l_return_status := FND_API.G_RET_STS_ERROR;
25994: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 26234: l_stage := 'Updating OKS_K_HEADERS_B';

26230: --end npalepu
26231: WHERE ID = P_To_Chr_ID;
26232:
26233: --Update OKS_K_HEADERS--
26234: l_stage := 'Updating OKS_K_HEADERS_B';
26235: UPDATE OKS_K_HEADERS_B
26236: SET
26237: quote_to_contact_id = NULL
26238: ,quote_to_site_id = NULL

Line 26235: UPDATE OKS_K_HEADERS_B

26231: WHERE ID = P_To_Chr_ID;
26232:
26233: --Update OKS_K_HEADERS--
26234: l_stage := 'Updating OKS_K_HEADERS_B';
26235: UPDATE OKS_K_HEADERS_B
26236: SET
26237: quote_to_contact_id = NULL
26238: ,quote_to_site_id = NULL
26239: ,quote_to_email_id = NULL

Line 26467: ,OKS_K_HEADERS_B oks

26463: oks.TRXN_EXTENSION_ID
26464: ,okc.BILL_TO_SITE_USE_ID
26465: FROM
26466: OKC_K_HEADERS_ALL_B okc
26467: ,OKS_K_HEADERS_B oks
26468: WHERE
26469: okc.id = oks.chr_id
26470: and okc.id = p_from_chr_id;
26471:

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

26778: IF (l_Target_Contract_New_YN = 'Y') then
26779:
26780: --===================-Start of Copy OKS Header attributes ========================================
26781: Begin
26782: /*--Call to copy source contract record in OKS_K_HEADERS_B */
26783: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26784: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
26785: FND_LOG.string(FND_LOG.level_statement
26786: ,l_module_name||'.oks_setup_util_pub.copy_hdr_attr'

Line 26870: UPDATE OKS_K_HEADERS_B

26866: RAISE G_EXCEPTION_HALT_VALIDATION;
26867: END IF;
26868: END IF;
26869:
26870: UPDATE OKS_K_HEADERS_B
26871: SET TRXN_EXTENSION_ID = l_Hdr_New_Trxn_Extn_ID
26872: WHERE CHR_ID = l_to_chr_id;
26873:
26874: If SQL%NOTFOUND then

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

26874: If SQL%NOTFOUND then
26875: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
26876: FND_LOG.string(FND_LOG.level_statement
26877: ,l_module_name||'.Create_Transaction_Extension'
26878: ,'Error in Update OKS_K_HEADERS_B, row not found for update'
26879: );
26880: END IF;
26881: l_return_status := FND_API.G_RET_STS_ERROR;
26882: RAISE G_EXCEPTION_HALT_VALIDATION;