APPS.OKL_IMA_PVT dependencies on OKL_INV_MSSG_ATT_V

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INV_MSSG_ATT_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_INV_MSSG_ATT_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 133: -- FUNCTION get_rec for: OKL_INV_MSSG_ATT_V

129: BEGIN
130: RETURN(get_rec(p_ima_rec, l_row_notfound));
131: END get_rec;
132: ---------------------------------------------------------------------------
133: -- FUNCTION get_rec for: OKL_INV_MSSG_ATT_V
134: ---------------------------------------------------------------------------
135: FUNCTION get_rec (
136: p_imav_rec IN imav_rec_type,
137: x_no_data_found OUT NOCOPY BOOLEAN

Line 166: FROM Okl_Inv_Mssg_Att_V

162: CREATION_DATE,
163: LAST_UPDATED_BY,
164: LAST_UPDATE_DATE,
165: LAST_UPDATE_LOGIN
166: FROM Okl_Inv_Mssg_Att_V
167: WHERE okl_inv_mssg_att_v.id = p_id;
168: l_okl_imav_pk okl_imav_pk_csr%ROWTYPE;
169: l_imav_rec imav_rec_type;
170: BEGIN

Line 167: WHERE okl_inv_mssg_att_v.id = p_id;

163: LAST_UPDATED_BY,
164: LAST_UPDATE_DATE,
165: LAST_UPDATE_LOGIN
166: FROM Okl_Inv_Mssg_Att_V
167: WHERE okl_inv_mssg_att_v.id = p_id;
168: l_okl_imav_pk okl_imav_pk_csr%ROWTYPE;
169: l_imav_rec imav_rec_type;
170: BEGIN
171: x_no_data_found := TRUE;

Line 214: -- FUNCTION null_out_defaults for: OKL_INV_MSSG_ATT_V --

210: RETURN(get_rec(p_imav_rec, l_row_notfound));
211: END get_rec;
212:
213: --------------------------------------------------------
214: -- FUNCTION null_out_defaults for: OKL_INV_MSSG_ATT_V --
215: --------------------------------------------------------
216: FUNCTION null_out_defaults (
217: p_imav_rec IN imav_rec_type
218: ) RETURN imav_rec_type IS

Line 592: FROM okl_inv_mssg_att_v

588: ) RETURN VARCHAR2 IS
589:
590: CURSOR l_imav_csr IS
591: SELECT 'x'
592: FROM okl_inv_mssg_att_v
593: WHERE ims_id = p_imav_rec.ims_id
594: AND cnr_id = p_imav_rec.cnr_id
595: AND id <> nvl (p_imav_rec.id, -99999);
596:

Line 656: -- Validate_Attributes for:OKL_INV_MSSG_ATT_V --

652: -- Post-Generation Change
653: -- By RDRAGUIL on 24-APR-2001
654: ---------------------------------------------------------------------------
655: ---------------------------------------------------
656: -- Validate_Attributes for:OKL_INV_MSSG_ATT_V --
657: ---------------------------------------------------
658: FUNCTION Validate_Attributes (
659: p_imav_rec IN imav_rec_type
660: ) RETURN VARCHAR2 IS

Line 735: -- Validate_Record for:OKL_INV_MSSG_ATT_V --

731: -- Post-Generation Change
732: -- By RDRAGUIL on 24-APR-2001
733: ---------------------------------------------------------------------------
734: -----------------------------------------------
735: -- Validate_Record for:OKL_INV_MSSG_ATT_V --
736: -----------------------------------------------
737: FUNCTION Validate_Record (
738: p_imav_rec IN imav_rec_type
739: ) RETURN VARCHAR2 IS

Line 843: -- validate_row for:OKL_INV_MSSG_ATT_V --

839: ---------------------------------------------------------------------------
840: -- PROCEDURE validate_row
841: ---------------------------------------------------------------------------
842: -----------------------------------------
843: -- validate_row for:OKL_INV_MSSG_ATT_V --
844: -----------------------------------------
845: PROCEDURE validate_row(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1139: -- insert_row for:OKL_INV_MSSG_ATT_V --

1135: '_PVT'
1136: );
1137: END insert_row;
1138: ---------------------------------------
1139: -- insert_row for:OKL_INV_MSSG_ATT_V --
1140: ---------------------------------------
1141: PROCEDURE insert_row(
1142: p_api_version IN NUMBER,
1143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1173: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --

1169: l_imav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1170: RETURN(l_imav_rec);
1171: END fill_who_columns;
1172: -------------------------------------------
1173: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --
1174: -------------------------------------------
1175: FUNCTION Set_Attributes (
1176: p_imav_rec IN imav_rec_type,
1177: x_imav_rec OUT NOCOPY imav_rec_type

Line 1476: -- lock_row for:OKL_INV_MSSG_ATT_V --

1472: '_PVT'
1473: );
1474: END lock_row;
1475: -------------------------------------
1476: -- lock_row for:OKL_INV_MSSG_ATT_V --
1477: -------------------------------------
1478: PROCEDURE lock_row(
1479: p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1876: -- update_row for:OKL_INV_MSSG_ATT_V --

1872: '_PVT'
1873: );
1874: END update_row;
1875: ---------------------------------------
1876: -- update_row for:OKL_INV_MSSG_ATT_V --
1877: ---------------------------------------
1878: PROCEDURE update_row(
1879: p_api_version IN NUMBER,
1880: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2027: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --

2023: END IF;
2024: RETURN(l_return_status);
2025: END populate_new_record;
2026: -------------------------------------------
2027: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --
2028: -------------------------------------------
2029: FUNCTION Set_Attributes (
2030: p_imav_rec IN imav_rec_type,
2031: x_imav_rec OUT NOCOPY imav_rec_type

Line 2288: -- delete_row for:OKL_INV_MSSG_ATT_V --

2284: '_PVT'
2285: );
2286: END delete_row;
2287: ---------------------------------------
2288: -- delete_row for:OKL_INV_MSSG_ATT_V --
2289: ---------------------------------------
2290: PROCEDURE delete_row(
2291: p_api_version IN NUMBER,
2292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,