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 OKC_K_HEADERS_B

Line 24: G_TrgHdrStartDate OKC_K_HEADERS_B.START_DATE%TYPE;

20:
21: /*The following Target header related package variables are used in the routines "create_bsch_using_PPSetup" and
22: update_line_inv_and_acct_rule
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;

Line 25: G_TrgHdrEndDate OKC_K_HEADERS_B.END_DATE%TYPE;

21: /*The following Target header related package variables are used in the routines "create_bsch_using_PPSetup" and
22: update_line_inv_and_acct_rule
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;

Line 26: G_TrgHdrInvRuleID OKC_K_HEADERS_B.INV_RULE_ID%TYPE;

22: update_line_inv_and_acct_rule
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;

Line 374: FROM okc_k_headers_b

370: l_template_yn VARCHAR2(3);
371:
372: CURSOR c_template IS
373: SELECT template_yn
374: FROM okc_k_headers_b
375: WHERE id = p_chr_id;
376:
377: CURSOR invalid_template IS
378: SELECT '1'

Line 379: FROM okc_k_headers_b

375: WHERE id = p_chr_id;
376:
377: CURSOR invalid_template IS
378: SELECT '1'
379: FROM okc_k_headers_b
380: WHERE template_yn = 'Y'
381: AND nvl(end_date, sysdate+1) >= trunc(sysdate)
382: AND id = p_chr_id;
383: BEGIN

Line 1174: FROM okc_k_headers_b

1170: PROCEDURE Set_Attach_Session_Vars(p_chr_id NUMBER) IS
1171: l_app_id NUMBER;
1172: Cursor l_chr_csr Is
1173: SELECT application_id
1174: FROM okc_k_headers_b
1175: WHERE id = p_chr_id;
1176: BEGIN
1177: If (p_chr_id IS NOT NULL AND
1178: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

Line 1431: FROM okc_k_headers_b

1427: WHERE id = p_to_cle_id;
1428:
1429: CURSOR c_chr IS
1430: SELECT start_date,end_date
1431: FROM okc_k_headers_b
1432: WHERE id = p_to_chr_id;
1433:
1434: BEGIN
1435: IF (p_to_chr_id IS NULL OR p_to_chr_id = OKC_API.G_MISS_NUM) THEN

Line 1688: from okc_k_headers_b

1684: -- /Rules migration/
1685: --FOr other contracts classes, conversion data is now stored at the header level
1686: select CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_rate_DATE
1687: into g_conversion_type, g_conversion_rate, g_conversion_date
1688: from okc_k_headers_b
1689: where id = l_chrv_rec.id;
1690: End If;
1691:
1692: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);

Line 2823: -- okc_k_headers_bh/hv and as NUMBER in okc_k_headers_b/v. This gives

2819: l_no_data_found BOOLEAN := TRUE;
2820:
2821: -- Bug 1922121: Compilation errors on ktst115. Problem occurred
2822: -- because application_id is defined as varchar2(240) in
2823: -- okc_k_headers_bh/hv and as NUMBER in okc_k_headers_b/v. This gives
2824: -- problems in the UNION ALL because it tries to combine datatypes
2825: -- Fix: Put a to_char() around application_id in the first cursor
2826:
2827: CURSOR c_chrv_rec IS

Line 4419: ,OKC_K_HEADERS_B okcH

4415: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4416: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4417: FROM
4418: OKC_PRICE_ATT_VALUES okcPAV
4419: ,OKC_K_HEADERS_B okcH
4420: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4421: and okcH.ID = P_To_Chr_ID
4422: and okcPAV.CLE_ID is NULL
4423: and okcPAV.CHR_ID = P_From_Chr_ID

Line 4865: ,OKC_K_HEADERS_B okcH

4861: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4862: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4863: FROM
4864: OKC_PRICE_ATT_VALUES okcPAV
4865: ,OKC_K_HEADERS_B okcH
4866: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4867: and okcH.ID = P_To_Chr_ID
4868: and okcPAV.CLE_ID is NULL
4869: and okcPAV.CHR_ID = P_From_Chr_ID

Line 5312: ,OKC_K_HEADERS_B okcH

5308: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5309: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5310: FROM
5311: OKC_PRICE_ATT_VALUES okcPAV
5312: ,OKC_K_HEADERS_B okcH
5313: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
5314: and okcH.ID = P_To_Chr_ID
5315: and okcPAV.CLE_ID is NULL
5316: and okcPAV.CHR_ID = P_From_Chr_ID;

Line 7079: ,OKC_K_HEADERS_B okcH

7075: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7076: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7077: FROM
7078: OKC_PRICE_ADJUSTMENTS okcPA
7079: ,OKC_K_HEADERS_B okcH
7080: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7081: and okcH.ID = P_To_Chr_ID
7082: and okcPA.CLE_ID is NULL
7083: and okcPA.CHR_ID = P_From_Chr_ID

Line 7228: ,OKC_K_HEADERS_B okcH

7224: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7225: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7226: FROM
7227: OKC_PRICE_ADJUSTMENTS okcPA
7228: ,OKC_K_HEADERS_B okcH
7229: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7230: and okcH.ID = P_To_Chr_ID
7231: and okcPA.CLE_ID is NULL
7232: and okcPA.CHR_ID = P_From_Chr_ID

Line 7377: ,OKC_K_HEADERS_B okcH

7373: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7374: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7375: FROM
7376: OKC_PRICE_ADJUSTMENTS okcPA
7377: ,OKC_K_HEADERS_B okcH
7378: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7379: and okcH.ID = P_To_Chr_ID
7380: and okcPA.CLE_ID is NULL
7381: and okcPA.CHR_ID = P_From_Chr_ID;

Line 8058: ,OKC_K_HEADERS_B okcH

8054: ,'COPY' AS okcPRB_ORIG_SYSTEM_REFERENCE1
8055: ,NULL AS okcPRB_ORIG_SYSTEM_SOURCE_CODE
8056: FROM
8057: OKC_K_PARTY_ROLES_B okcPRB
8058: ,OKC_K_HEADERS_B okcH
8059: where okcPRB.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
8060: and okcPRB.CLE_ID is NULL
8061: and okcH.ID = P_To_Chr_ID
8062: and okcPRB.DNZ_CHR_ID = P_From_Chr_ID

Line 11481: ,OKC_K_HEADERS_B okcH

11477: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11478: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11479: FROM
11480: OKS_K_SALES_CREDITS oksSC
11481: ,OKC_K_HEADERS_B okcH
11482: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11483: AND oksSC.CLE_ID IS NULL
11484: AND okcH.ID = P_To_Chr_ID
11485: AND oksSC.CHR_ID = P_From_Chr_ID

Line 11521: ,OKC_K_HEADERS_B okcH

11517: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11518: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11519: FROM
11520: OKS_K_SALES_CREDITS oksSC
11521: ,OKC_K_HEADERS_B okcH
11522: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11523: AND oksSC.CLE_ID IS NULL
11524: AND okcH.ID = P_To_Chr_ID
11525: AND oksSC.CHR_ID = P_From_Chr_ID;

Line 11563: ,OKC_K_HEADERS_B okcH

11559: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11560: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11561: FROM
11562: OKS_K_SALES_CREDITS oksSC
11563: ,OKC_K_HEADERS_B okcH
11564: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11565: AND oksSC.CLE_ID IS NULL
11566: AND okcH.ID = P_To_Chr_ID
11567: AND oksSC.CHR_ID = P_From_Chr_ID

Line 12089: ,OKC_K_HEADERS_B okcH

12085: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12086: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12087: FROM
12088: OKS_STREAM_LEVELS_B oksSL
12089: ,OKC_K_HEADERS_B okcH
12090: WHERE
12091: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12092: AND okcH.ID = P_To_Chr_ID
12093: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12208: ,OKC_K_HEADERS_B okcH

12204: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12205: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12206: FROM
12207: OKS_STREAM_LEVELS_B oksSL
12208: ,OKC_K_HEADERS_B okcH
12209: WHERE
12210: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12211: AND okcH.ID = P_To_Chr_ID
12212: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12350: ,OKC_K_HEADERS_B okcH

12346: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12347: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12348: FROM
12349: OKS_STREAM_LEVELS_B oksSL
12350: ,OKC_K_HEADERS_B okcH
12351: WHERE
12352: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12353: AND okcH.ID = P_To_Chr_ID
12354: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 13420: OKC_K_HEADERS_B okcH

13416: ,oksH.PERIOD_TYPE
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:

Line 15579: from okc_k_headers_b

15575:
15576: Function IsSourceContractTemplate(P_From_Chr_ID IN NUMBER) RETURN VARCHAR2 IS
15577: CURSOR GetTemplateYN IS
15578: select template_yn
15579: from okc_k_headers_b
15580: where id = P_From_Chr_ID;
15581:
15582: l_Template_YN VARCHAR2(1);
15583: Begin

Line 17000: from okc_k_headers_b

16996: ---------------------------------------------------------------------------
16997: ------------Cursor to get Contract Number of newly created contract--------
16998: CURSOR get_new_contract_number(P_To_Chr_ID IN NUMBER) IS
16999: select contract_number
17000: from okc_k_headers_b
17001: where id = P_To_Chr_ID;
17002:
17003: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
17004: ----------------------------------------------------------------------------

Line 17003: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

16999: select contract_number
17000: from okc_k_headers_b
17001: where id = P_To_Chr_ID;
17002:
17003: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
17004: ----------------------------------------------------------------------------
17005:
17006: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17007: l_euro_currency VARCHAR2(15) := NULL;

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 19357: UPDATE OKC_K_HEADERS_B a

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
19358: SET a.ESTIMATED_AMOUNT = (select sum(b.PRICE_NEGOTIATED)
19359: FROM OKC_K_LINES_B b
19360: where b.DNZ_CHR_ID = a.ID
19361: and b.CLE_ID IS NULL

Line 20208: from okc_k_headers_b a

20204: a.contract_number
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:

Line 20213: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

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;
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:

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 24764: UPDATE OKC_K_HEADERS_B a

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
24765: SET a.ESTIMATED_AMOUNT = nvl((select sum(b.PRICE_NEGOTIATED)
24766: FROM OKC_K_LINES_B b
24767: where b.DNZ_CHR_ID = a.ID
24768: and b.CLE_ID IS NULL