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.OKL_CMG_PVT dependencies on OKL_CONDITION_MSSGS_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CONDITION_MSSGS_V';

13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
15:
16: --GLOBAL VARIABLES
17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CONDITION_MSSGS_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 135: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS_V

131: BEGIN
132: RETURN(get_rec(p_cmg_rec, l_row_notfound));
133: END get_rec;
134: ---------------------------------------------------------------------------
135: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS_V
136: ---------------------------------------------------------------------------
137: FUNCTION get_rec (
138: p_cmgv_rec IN cmgv_rec_type,
139: x_no_data_found OUT NOCOPY BOOLEAN

Line 169: FROM Okl_Condition_Mssgs_V

165: CREATION_DATE,
166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Condition_Mssgs_V
170: WHERE okl_condition_mssgs_v.id = p_id;
171: l_okl_cmgv_pk okl_cmgv_pk_csr%ROWTYPE;
172: l_cmgv_rec cmgv_rec_type;
173: BEGIN

Line 170: WHERE okl_condition_mssgs_v.id = p_id;

166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Condition_Mssgs_V
170: WHERE okl_condition_mssgs_v.id = p_id;
171: l_okl_cmgv_pk okl_cmgv_pk_csr%ROWTYPE;
172: l_cmgv_rec cmgv_rec_type;
173: BEGIN
174: x_no_data_found := TRUE;

Line 218: -- FUNCTION null_out_defaults for: OKL_CONDITION_MSSGS_V --

214: RETURN(get_rec(p_cmgv_rec, l_row_notfound));
215: END get_rec;
216:
217: -----------------------------------------------------------
218: -- FUNCTION null_out_defaults for: OKL_CONDITION_MSSGS_V --
219: -----------------------------------------------------------
220: FUNCTION null_out_defaults (
221: p_cmgv_rec IN cmgv_rec_type
222: ) RETURN cmgv_rec_type IS

Line 467: p_token2_value => 'OKL_CONDITION_MSSGS_V',

463: p_msg_name => G_NO_PARENT_RECORD,
464: p_token1 => G_COL_NAME_TOKEN,
465: p_token1_value => 'ims_id',
466: p_token2 => G_CHILD_TABLE_TOKEN,
467: p_token2_value => 'OKL_CONDITION_MSSGS_V',
468: p_token3 => G_PARENT_TABLE_TOKEN,
469: p_token3_value => 'OKL_INVOICE_MSSGS_V');
470:
471: -- notify caller of en error

Line 556: p_token2_value => 'OKL_CONDITION_MSSGS_V',

552: p_msg_name => G_NO_PARENT_RECORD,
553: p_token1 => G_COL_NAME_TOKEN,
554: p_token1_value => 'ivm_id',
555: p_token2 => G_CHILD_TABLE_TOKEN,
556: p_token2_value => 'OKL_CONDITION_MSSGS_V',
557: p_token3 => G_PARENT_TABLE_TOKEN,
558: p_token3_value => 'OKL_INVC_MSS_PRCDRS_V');
559:
560: -- notify caller of en error

Line 600: FROM okl_condition_mssgs_v

596: ) RETURN VARCHAR2 IS
597:
598: CURSOR l_cmgv_csr IS
599: SELECT 'x'
600: FROM okl_condition_mssgs_v
601: WHERE ims_id = p_cmgv_rec.ims_id
602: AND ivm_id = p_cmgv_rec.ivm_id
603: AND id <> nvl (p_cmgv_rec.id, -99999);
604:

Line 664: -- Validate_Attributes for:OKL_CONDITION_MSSGS_V --

660: -- Post-Generation Change
661: -- By RDRAGUIL on 24-APR-2001
662: ---------------------------------------------------------------------------
663: ---------------------------------------------------
664: -- Validate_Attributes for:OKL_CONDITION_MSSGS_V --
665: ---------------------------------------------------
666: FUNCTION Validate_Attributes (
667: p_cmgv_rec IN cmgv_rec_type
668: ) RETURN VARCHAR2 IS

Line 743: -- Validate_Record for:OKL_CONDITION_MSSGS_V --

739: -- Post-Generation Change
740: -- By RDRAGUIL on 24-APR-2001
741: ---------------------------------------------------------------------------
742: -----------------------------------------------
743: -- Validate_Record for:OKL_CONDITION_MSSGS_V --
744: -----------------------------------------------
745: FUNCTION Validate_Record (
746: p_cmgv_rec IN cmgv_rec_type
747: ) RETURN VARCHAR2 IS

Line 853: -- validate_row for:OKL_CONDITION_MSSGS_V --

849: ---------------------------------------------------------------------------
850: -- PROCEDURE validate_row
851: ---------------------------------------------------------------------------
852: --------------------------------------------
853: -- validate_row for:OKL_CONDITION_MSSGS_V --
854: --------------------------------------------
855: PROCEDURE validate_row(
856: p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1153: -- insert_row for:OKL_CONDITION_MSSGS_V --

1149: '_PVT'
1150: );
1151: END insert_row;
1152: ------------------------------------------
1153: -- insert_row for:OKL_CONDITION_MSSGS_V --
1154: ------------------------------------------
1155: PROCEDURE insert_row(
1156: p_api_version IN NUMBER,
1157: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1188: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --

1184: l_cmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1185: RETURN(l_cmgv_rec);
1186: END fill_who_columns;
1187: ----------------------------------------------
1188: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --
1189: ----------------------------------------------
1190: FUNCTION Set_Attributes (
1191: p_cmgv_rec IN cmgv_rec_type,
1192: x_cmgv_rec OUT NOCOPY cmgv_rec_type

Line 1492: -- lock_row for:OKL_CONDITION_MSSGS_V --

1488: '_PVT'
1489: );
1490: END lock_row;
1491: ----------------------------------------
1492: -- lock_row for:OKL_CONDITION_MSSGS_V --
1493: ----------------------------------------
1494: PROCEDURE lock_row(
1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1899: -- update_row for:OKL_CONDITION_MSSGS_V --

1895: '_PVT'
1896: );
1897: END update_row;
1898: ------------------------------------------
1899: -- update_row for:OKL_CONDITION_MSSGS_V --
1900: ------------------------------------------
1901: PROCEDURE update_row(
1902: p_api_version IN NUMBER,
1903: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 2055: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --

2051: END IF;
2052: RETURN(l_return_status);
2053: END populate_new_record;
2054: ----------------------------------------------
2055: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --
2056: ----------------------------------------------
2057: FUNCTION Set_Attributes (
2058: p_cmgv_rec IN cmgv_rec_type,
2059: x_cmgv_rec OUT NOCOPY cmgv_rec_type

Line 2317: -- delete_row for:OKL_CONDITION_MSSGS_V --

2313: '_PVT'
2314: );
2315: END delete_row;
2316: ------------------------------------------
2317: -- delete_row for:OKL_CONDITION_MSSGS_V --
2318: ------------------------------------------
2319: PROCEDURE delete_row(
2320: p_api_version IN NUMBER,
2321: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,