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 372: FROM okc_k_headers_b

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

Line 377: FROM okc_k_headers_b

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

Line 1172: FROM okc_k_headers_b

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

Line 1429: FROM okc_k_headers_b

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

Line 1681: from okc_k_headers_b

1677: -- /Rules migration/
1678: --FOr other contracts classes, conversion data is now stored at the header level
1679: select CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_rate_DATE
1680: into g_conversion_type, g_conversion_rate, g_conversion_date
1681: from okc_k_headers_b
1682: where id = l_chrv_rec.id;
1683: End If;
1684:
1685: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);

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

2782: l_no_data_found BOOLEAN := TRUE;
2783:
2784: -- Bug 1922121: Compilation errors on ktst115. Problem occurred
2785: -- because application_id is defined as varchar2(240) in
2786: -- okc_k_headers_bh/hv and as NUMBER in okc_k_headers_b/v. This gives
2787: -- problems in the UNION ALL because it tries to combine datatypes
2788: -- Fix: Put a to_char() around application_id in the first cursor
2789:
2790: CURSOR c_chrv_rec IS

Line 4382: ,OKC_K_HEADERS_B okcH

4378: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4379: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4380: FROM
4381: OKC_PRICE_ATT_VALUES okcPAV
4382: ,OKC_K_HEADERS_B okcH
4383: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4384: and okcH.ID = P_To_Chr_ID
4385: and okcPAV.CLE_ID is NULL
4386: and okcPAV.CHR_ID = P_From_Chr_ID

Line 4828: ,OKC_K_HEADERS_B okcH

4824: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4825: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4826: FROM
4827: OKC_PRICE_ATT_VALUES okcPAV
4828: ,OKC_K_HEADERS_B okcH
4829: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4830: and okcH.ID = P_To_Chr_ID
4831: and okcPAV.CLE_ID is NULL
4832: and okcPAV.CHR_ID = P_From_Chr_ID

Line 5275: ,OKC_K_HEADERS_B okcH

5271: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5272: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5273: FROM
5274: OKC_PRICE_ATT_VALUES okcPAV
5275: ,OKC_K_HEADERS_B okcH
5276: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
5277: and okcH.ID = P_To_Chr_ID
5278: and okcPAV.CLE_ID is NULL
5279: and okcPAV.CHR_ID = P_From_Chr_ID;

Line 7042: ,OKC_K_HEADERS_B okcH

7038: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7039: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7040: FROM
7041: OKC_PRICE_ADJUSTMENTS okcPA
7042: ,OKC_K_HEADERS_B okcH
7043: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7044: and okcH.ID = P_To_Chr_ID
7045: and okcPA.CLE_ID is NULL
7046: and okcPA.CHR_ID = P_From_Chr_ID

Line 7191: ,OKC_K_HEADERS_B okcH

7187: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7188: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7189: FROM
7190: OKC_PRICE_ADJUSTMENTS okcPA
7191: ,OKC_K_HEADERS_B okcH
7192: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7193: and okcH.ID = P_To_Chr_ID
7194: and okcPA.CLE_ID is NULL
7195: and okcPA.CHR_ID = P_From_Chr_ID

Line 7340: ,OKC_K_HEADERS_B okcH

7336: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7337: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7338: FROM
7339: OKC_PRICE_ADJUSTMENTS okcPA
7340: ,OKC_K_HEADERS_B okcH
7341: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7342: and okcH.ID = P_To_Chr_ID
7343: and okcPA.CLE_ID is NULL
7344: and okcPA.CHR_ID = P_From_Chr_ID;

Line 8021: ,OKC_K_HEADERS_B okcH

8017: ,'COPY' AS okcPRB_ORIG_SYSTEM_REFERENCE1
8018: ,NULL AS okcPRB_ORIG_SYSTEM_SOURCE_CODE
8019: FROM
8020: OKC_K_PARTY_ROLES_B okcPRB
8021: ,OKC_K_HEADERS_B okcH
8022: where okcPRB.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
8023: and okcPRB.CLE_ID is NULL
8024: and okcH.ID = P_To_Chr_ID
8025: and okcPRB.DNZ_CHR_ID = P_From_Chr_ID

Line 11436: ,OKC_K_HEADERS_B okcH

11432: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11433: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11434: FROM
11435: OKS_K_SALES_CREDITS oksSC
11436: ,OKC_K_HEADERS_B okcH
11437: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11438: AND oksSC.CLE_ID IS NULL
11439: AND okcH.ID = P_To_Chr_ID
11440: AND oksSC.CHR_ID = P_From_Chr_ID

Line 11476: ,OKC_K_HEADERS_B okcH

11472: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11473: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11474: FROM
11475: OKS_K_SALES_CREDITS oksSC
11476: ,OKC_K_HEADERS_B okcH
11477: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11478: AND oksSC.CLE_ID IS NULL
11479: AND okcH.ID = P_To_Chr_ID
11480: AND oksSC.CHR_ID = P_From_Chr_ID;

Line 11518: ,OKC_K_HEADERS_B okcH

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

Line 12044: ,OKC_K_HEADERS_B okcH

12040: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12041: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12042: FROM
12043: OKS_STREAM_LEVELS_B oksSL
12044: ,OKC_K_HEADERS_B okcH
12045: WHERE
12046: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12047: AND okcH.ID = P_To_Chr_ID
12048: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12163: ,OKC_K_HEADERS_B okcH

12159: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12160: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12161: FROM
12162: OKS_STREAM_LEVELS_B oksSL
12163: ,OKC_K_HEADERS_B okcH
12164: WHERE
12165: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12166: AND okcH.ID = P_To_Chr_ID
12167: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12305: ,OKC_K_HEADERS_B okcH

12301: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12302: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12303: FROM
12304: OKS_STREAM_LEVELS_B oksSL
12305: ,OKC_K_HEADERS_B okcH
12306: WHERE
12307: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12308: AND okcH.ID = P_To_Chr_ID
12309: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 13375: OKC_K_HEADERS_B okcH

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

Line 15534: from okc_k_headers_b

15530:
15531: Function IsSourceContractTemplate(P_From_Chr_ID IN NUMBER) RETURN VARCHAR2 IS
15532: CURSOR GetTemplateYN IS
15533: select template_yn
15534: from okc_k_headers_b
15535: where id = P_From_Chr_ID;
15536:
15537: l_Template_YN VARCHAR2(1);
15538: Begin

Line 16933: from okc_k_headers_b

16929: ---------------------------------------------------------------------------
16930: ------------Cursor to get Contract Number of newly created contract--------
16931: CURSOR get_new_contract_number(P_To_Chr_ID IN NUMBER) IS
16932: select contract_number
16933: from okc_k_headers_b
16934: where id = P_To_Chr_ID;
16935:
16936: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
16937: ----------------------------------------------------------------------------

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

16932: select contract_number
16933: from okc_k_headers_b
16934: where id = P_To_Chr_ID;
16935:
16936: l_new_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
16937: ----------------------------------------------------------------------------
16938:
16939: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16940: l_euro_currency VARCHAR2(15) := NULL;

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

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
19223: SET a.ESTIMATED_AMOUNT = (select sum(b.PRICE_NEGOTIATED)
19224: FROM OKC_K_LINES_B b
19225: where b.DNZ_CHR_ID = a.ID
19226: and b.CLE_ID IS NULL

Line 20061: from okc_k_headers_b a

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

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

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

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

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
24570: SET a.ESTIMATED_AMOUNT = (select sum(b.PRICE_NEGOTIATED)
24571: FROM OKC_K_LINES_B b
24572: where b.DNZ_CHR_ID = a.ID
24573: and b.CLE_ID IS NULL