APPS.OKL_IVM_PVT dependencies on OKL_INVC_MSS_PRCDRS_V

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

Line 135: -- FUNCTION get_rec for: OKL_INVC_MSS_PRCDRS_V

131: BEGIN
132: RETURN(get_rec(p_ivm_rec, l_row_notfound));
133: END get_rec;
134: ---------------------------------------------------------------------------
135: -- FUNCTION get_rec for: OKL_INVC_MSS_PRCDRS_V
136: ---------------------------------------------------------------------------
137: FUNCTION get_rec (
138: p_ivmv_rec IN ivmv_rec_type,
139: x_no_data_found OUT NOCOPY BOOLEAN

Line 169: FROM Okl_Invc_Mss_Prcdrs_V

165: CREATION_DATE,
166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Invc_Mss_Prcdrs_V
170: WHERE okl_invc_mss_prcdrs_v.id = p_id;
171: l_okl_ivmv_pk okl_ivmv_pk_csr%ROWTYPE;
172: l_ivmv_rec ivmv_rec_type;
173: BEGIN

Line 170: WHERE okl_invc_mss_prcdrs_v.id = p_id;

166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Invc_Mss_Prcdrs_V
170: WHERE okl_invc_mss_prcdrs_v.id = p_id;
171: l_okl_ivmv_pk okl_ivmv_pk_csr%ROWTYPE;
172: l_ivmv_rec ivmv_rec_type;
173: BEGIN
174: x_no_data_found := TRUE;

Line 218: -- FUNCTION null_out_defaults for: OKL_INVC_MSS_PRCDRS_V --

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

Line 584: FROM okl_invc_mss_prcdrs_v

580: ) RETURN VARCHAR2 IS
581:
582: CURSOR l_ivmv_csr IS
583: SELECT 'x'
584: FROM okl_invc_mss_prcdrs_v
585: WHERE package_name = p_ivmv_rec.package_name
586: AND procedure_name = p_ivmv_rec.procedure_name
587: AND id <> nvl (p_ivmv_rec.id, -99999);
588:

Line 648: -- Validate_Attributes for:OKL_INVC_MSS_PRCDRS_V --

644: -- Post-Generation Change
645: -- By RDRAGUIL on 24-APR-2001
646: ---------------------------------------------------------------------------
647: ---------------------------------------------------
648: -- Validate_Attributes for:OKL_INVC_MSS_PRCDRS_V --
649: ---------------------------------------------------
650: FUNCTION Validate_Attributes (
651: p_ivmv_rec IN ivmv_rec_type
652: ) RETURN VARCHAR2 IS

Line 737: -- Validate_Record for:OKL_INVC_MSS_PRCDRS_V --

733: -- Post-Generation Change
734: -- By RDRAGUIL on 24-APR-2001
735: ---------------------------------------------------------------------------
736: -----------------------------------------------
737: -- Validate_Record for:OKL_INVC_MSS_PRCDRS_V --
738: -----------------------------------------------
739: FUNCTION Validate_Record (
740: p_ivmv_rec IN ivmv_rec_type
741: ) RETURN VARCHAR2 IS

Line 847: -- validate_row for:OKL_INVC_MSS_PRCDRS_V --

843: ---------------------------------------------------------------------------
844: -- PROCEDURE validate_row
845: ---------------------------------------------------------------------------
846: --------------------------------------------
847: -- validate_row for:OKL_INVC_MSS_PRCDRS_V --
848: --------------------------------------------
849: PROCEDURE validate_row(
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1145: -- insert_row for:OKL_INVC_MSS_PRCDRS_V --

1141: '_PVT'
1142: );
1143: END insert_row;
1144: ------------------------------------------
1145: -- insert_row for:OKL_INVC_MSS_PRCDRS_V --
1146: ------------------------------------------
1147: PROCEDURE insert_row(
1148: p_api_version IN NUMBER,
1149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1179: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --

1175: l_ivmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1176: RETURN(l_ivmv_rec);
1177: END fill_who_columns;
1178: ----------------------------------------------
1179: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --
1180: ----------------------------------------------
1181: FUNCTION Set_Attributes (
1182: p_ivmv_rec IN ivmv_rec_type,
1183: x_ivmv_rec OUT NOCOPY ivmv_rec_type

Line 1482: -- lock_row for:OKL_INVC_MSS_PRCDRS_V --

1478: '_PVT'
1479: );
1480: END lock_row;
1481: ----------------------------------------
1482: -- lock_row for:OKL_INVC_MSS_PRCDRS_V --
1483: ----------------------------------------
1484: PROCEDURE lock_row(
1485: p_api_version IN NUMBER,
1486: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1887: -- update_row for:OKL_INVC_MSS_PRCDRS_V --

1883: '_PVT'
1884: );
1885: END update_row;
1886: ------------------------------------------
1887: -- update_row for:OKL_INVC_MSS_PRCDRS_V --
1888: ------------------------------------------
1889: PROCEDURE update_row(
1890: p_api_version IN NUMBER,
1891: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2042: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --

2038: END IF;
2039: RETURN(l_return_status);
2040: END populate_new_record;
2041: ----------------------------------------------
2042: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --
2043: ----------------------------------------------
2044: FUNCTION Set_Attributes (
2045: p_ivmv_rec IN ivmv_rec_type,
2046: x_ivmv_rec OUT NOCOPY ivmv_rec_type

Line 2303: -- delete_row for:OKL_INVC_MSS_PRCDRS_V --

2299: '_PVT'
2300: );
2301: END delete_row;
2302: ------------------------------------------
2303: -- delete_row for:OKL_INVC_MSS_PRCDRS_V --
2304: ------------------------------------------
2305: PROCEDURE delete_row(
2306: p_api_version IN NUMBER,
2307: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,