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.OKC_CHR_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 299: FROM OKC_K_HEADERS_ALL_B

295: SELECT 'x'
296: --npalepu 08-11-2005 modified for bug # 4691662.
297: --Replaced table okc_k_headers_b with headers_All_b table
298: /* FROM OKC_K_HEADERS_B */
299: FROM OKC_K_HEADERS_ALL_B
300: --end npalepu
301: WHERE id = p_chrv_rec.chr_id_response;
302:
303: BEGIN

Line 383: FROM OKC_K_HEADERS_ALL_B

379: SELECT 'x'
380: --npalepu 08-11-2005 modified for bug # 4691662.
381: --Replaced table okc_k_headers_b with headers_All_b table
382: /* FROM OKC_K_HEADERS_B */
383: FROM OKC_K_HEADERS_ALL_B
384: --end npalepu
385: WHERE id = p_chrv_rec.chr_id_award;
386:
387: BEGIN

Line 2665: -- FUNCTION get_rec for: OKC_K_HEADERS_ALL_B

2661:
2662: END add_language;
2663:
2664: ---------------------------------------------------------------------------
2665: -- FUNCTION get_rec for: OKC_K_HEADERS_ALL_B
2666: ---------------------------------------------------------------------------
2667: FUNCTION get_rec (
2668: p_chr_rec IN chr_rec_type,
2669: x_no_data_found OUT NOCOPY BOOLEAN

Line 2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC

2771: PAYMENT_INSTRUCTION_TYPE,
2772: ORG_ID, --mmadhavi added for MOAC
2773: -- R12 Data Model Changes 4485150 End
2774: CANCELLED_AMOUNT -- LLC
2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC
2776: WHERE okc_k_headers_all_b.id = p_id;
2777: l_chr_pk chr_pk_csr%ROWTYPE;
2778: l_chr_rec chr_rec_type;
2779: BEGIN

Line 2776: WHERE okc_k_headers_all_b.id = p_id;

2772: ORG_ID, --mmadhavi added for MOAC
2773: -- R12 Data Model Changes 4485150 End
2774: CANCELLED_AMOUNT -- LLC
2775: FROM Okc_K_Headers_All_B --mmadhavi changed to _ALL for MOAC
2776: WHERE okc_k_headers_all_b.id = p_id;
2777: l_chr_pk chr_pk_csr%ROWTYPE;
2778: l_chr_rec chr_rec_type;
2779: BEGIN
2780:

Line 3111: FROM OKC_K_HEADERS_ALL_B CHRB,

3107: PAYMENT_INSTRUCTION_TYPE,
3108: ORG_ID, --mmadhavi added for MOAC
3109: CANCELLED_AMOUNT -- LLC
3110: -- R12 Data Model Changes 4485150 End
3111: FROM OKC_K_HEADERS_ALL_B CHRB,
3112: OKC_K_HEADERS_TL CHRT
3113: WHERE CHRB.ID = p_id
3114: AND CHRB.ID = CHRT.ID
3115: AND CHRT.LANGUAGE = USERENV('LANG');

Line 4042: FROM okc_k_headers_all_b

4038: SELECT 'x'
4039: --npalepu 08-11-2005 modified for bug # 4691662.
4040: --Replaced table okc_k_headers_b with headers_All_b table
4041: /* FROM okc_k_headers_b */
4042: FROM okc_k_headers_all_b
4043: --end npalepu
4044: WHERE contract_number = p_chrv_rec.contract_number
4045: AND contract_number_modifier IS NULL
4046: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4053: FROM okc_k_headers_all_b

4049: SELECT 'x'
4050: --npalepu 08-11-2005 modified for bug # 4691662.
4051: --Replaced table okc_k_headers_b with headers_All_b table
4052: /* FROM okc_k_headers_b */
4053: FROM okc_k_headers_all_b
4054: --end npalepu
4055: WHERE contract_number = p_chrv_rec.contract_number
4056: AND contract_number_modifier = p_chrv_rec.contract_number_modifier
4057: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4127: FROM okc_k_headers_all_b

4123: SELECT 'x'
4124: --npalepu 08-11-2005 modified for bug # 4691662.
4125: --Replaced table okc_k_headers_b with headers_All_b table
4126: /* FROM okc_k_headers_b */
4127: FROM okc_k_headers_all_b
4128: --end npalepu
4129: WHERE contract_number = p_chrv_rec.contract_number
4130: AND contract_number_modifier IS NULL
4131: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4138: FROM okc_k_headers_all_b

4134: SELECT 'x'
4135: --npalepu 08-11-2005 modified for bug # 4691662.
4136: --Replaced table okc_k_headers_b with headers_All_b table
4137: /* FROM okc_k_headers_b */
4138: FROM okc_k_headers_all_b
4139: --end npalepu
4140: WHERE contract_number = p_chrv_rec.contract_number
4141: AND contract_number_modifier = p_chrv_rec.contract_number_modifier
4142: AND id <> nvl(p_chrv_rec.id, - 99999);

Line 4757: -- insert_row for:OKC_K_HEADERS_ALL_B --

4753: ---------------------------------------------------------------------------
4754: -- PROCEDURE insert_row
4755: ---------------------------------------------------------------------------
4756: ------------------------------------
4757: -- insert_row for:OKC_K_HEADERS_ALL_B --
4758: ------------------------------------
4759: PROCEDURE insert_row(
4760: p_init_msg_list IN VARCHAR2,
4761: x_return_status OUT NOCOPY VARCHAR2,

Line 4773: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --

4769: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4770: l_chr_rec chr_rec_type := p_chr_rec;
4771: l_def_chr_rec chr_rec_type;
4772: ----------------------------------------
4773: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --
4774: ----------------------------------------
4775: FUNCTION Set_Attributes (
4776: p_chr_rec IN chr_rec_type,
4777: x_chr_rec OUT NOCOPY chr_rec_type

Line 4817: INSERT INTO OKC_K_HEADERS_ALL_B( --mmadhavi changed to _ALL for MOAC

4813: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4814: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4815: RAISE OKC_API.G_EXCEPTION_ERROR;
4816: END IF;
4817: INSERT INTO OKC_K_HEADERS_ALL_B( --mmadhavi changed to _ALL for MOAC
4818: id,
4819: contract_number,
4820: authoring_org_id,
4821: org_id, --mmadhavi added for MOAC

Line 5638: -- lock_row for:OKC_K_HEADERS_ALL_B --

5634: ---------------------------------------------------------------------------
5635: -- PROCEDURE lock_row
5636: ---------------------------------------------------------------------------
5637: ----------------------------------
5638: -- lock_row for:OKC_K_HEADERS_ALL_B --
5639: ----------------------------------
5640: PROCEDURE lock_row(
5641: p_init_msg_list IN VARCHAR2,
5642: x_return_status OUT NOCOPY VARCHAR2,

Line 5651: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

5647: E_Resource_Busy EXCEPTION;
5648: PRAGMA EXCEPTION_INIT(E_Resource_Busy, - 00054);
5649: CURSOR lock_csr (p_chr_rec IN chr_rec_type) IS
5650: SELECT OBJECT_VERSION_NUMBER
5651: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
5652: WHERE ID = p_chr_rec.id
5653: AND OBJECT_VERSION_NUMBER = p_chr_rec.object_version_number
5654: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5655:

Line 5658: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

5654: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5655:
5656: CURSOR lchk_csr (p_chr_rec IN chr_rec_type) IS
5657: SELECT OBJECT_VERSION_NUMBER
5658: FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
5659: WHERE ID = p_chr_rec.id;
5660: l_api_version CONSTANT NUMBER := 1;
5661: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 6162: -- update_row for:OKC_K_HEADERS_ALL_B --

6158: ---------------------------------------------------------------------------
6159: -- PROCEDURE update_row
6160: ---------------------------------------------------------------------------
6161: ------------------------------------
6162: -- update_row for:OKC_K_HEADERS_ALL_B --
6163: ------------------------------------
6164: PROCEDURE update_row(
6165: p_init_msg_list IN VARCHAR2,
6166: x_return_status OUT NOCOPY VARCHAR2,

Line 6586: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --

6582: RETURN(l_return_status);
6583:
6584: END populate_new_record;
6585: ----------------------------------------
6586: -- Set_Attributes for:OKC_K_HEADERS_ALL_B --
6587: ----------------------------------------
6588: FUNCTION Set_Attributes (
6589: p_chr_rec IN chr_rec_type,
6590: x_chr_rec OUT NOCOPY chr_rec_type

Line 6637: UPDATE OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

6633: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6634: RAISE OKC_API.G_EXCEPTION_ERROR;
6635: END IF;
6636:
6637: UPDATE OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
6638: SET CONTRACT_NUMBER = l_def_chr_rec.contract_number,
6639: --AUTHORING_ORG_ID = l_def_chr_rec.authoring_org_id,
6640: CONTRACT_NUMBER_MODIFIER = l_def_chr_rec.contract_number_modifier,
6641: CHR_ID_RESPONSE = l_def_chr_rec.chr_id_response,

Line 7827: -- delete_row for:OKC_K_HEADERS_ALL_B --

7823: ---------------------------------------------------------------------------
7824: -- PROCEDURE delete_row
7825: ---------------------------------------------------------------------------
7826: ------------------------------------
7827: -- delete_row for:OKC_K_HEADERS_ALL_B --
7828: ------------------------------------
7829: PROCEDURE delete_row(
7830: p_init_msg_list IN VARCHAR2,
7831: x_return_status OUT NOCOPY VARCHAR2,

Line 7857: DELETE FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

7853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7854: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7855: RAISE OKC_API.G_EXCEPTION_ERROR;
7856: END IF;
7857: DELETE FROM OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
7858: WHERE ID = l_chr_rec.id;
7859:
7860: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7861: IF (l_debug = 'Y') THEN

Line 8567: INTO OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC

8563: END LOOP;
8564:
8565: FORALL i IN 1..l_tabsize
8566: INSERT
8567: INTO OKC_K_HEADERS_ALL_B --mmadhavi changed to _ALL for MOAC
8568: (
8569: id,
8570: -- GCHADHA --
8571: -- BUG 3941485 --

Line 8892: INSERT INTO okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC

8888: okc_debug.Set_Indentation('OKC_CHR_PVT');
8889: okc_debug.LOG('23700: Entered create_version', 2);
8890: END IF;
8891:
8892: INSERT INTO okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC
8893: (
8894: major_version,
8895: id,
8896: contract_number,

Line 9100: FROM okc_k_headers_all_b --mamdhavi changed to _ALL for MOAC

9096: term_cancel_source,
9097: payment_instruction_type,
9098: cancelled_amount -- LLC
9099: -- R12 Data Model Changes 4485150 End
9100: FROM okc_k_headers_all_b --mamdhavi changed to _ALL for MOAC
9101: WHERE id = p_chr_id;
9102:
9103: --------------------------------
9104: -- Versioning TL Table

Line 9241: INSERT INTO okc_k_headers_all_b --mmadhavi changed to _ALL for MOAC

9237: --------------------------------------
9238: -- Restore Base Table
9239: --------------------------------------
9240:
9241: INSERT INTO okc_k_headers_all_b --mmadhavi changed to _ALL for MOAC
9242: (
9243: id,
9244: contract_number,
9245: authoring_org_id,

Line 9446: FROM okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC

9442: term_cancel_source,
9443: payment_instruction_type,
9444: cancelled_amount -- LLC
9445: -- R12 data Model Changes 4485150 End
9446: FROM okc_k_headers_all_bh --mmadhavi changed to _ALL for MOAC
9447: WHERE id = p_chr_id
9448: AND major_version = p_major_version;
9449:
9450: RETURN l_return_status;