DBA Data[Home] [Help]

APPS.OKL_SXP_PVT dependencies on OKL_SIF_TRX_PARMS_V

Line 94: -- FUNCTION get_rec for: OKL_SIF_TRX_PARMS_V

90: BEGIN
91: RETURN(get_rec(p_sxp_rec, l_row_notfound));
92: END get_rec;
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_SIF_TRX_PARMS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_sxpv_rec IN sxpv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 116: FROM OKL_SIF_TRX_PARMS_V

112: LAST_UPDATED_BY,
113: CREATION_DATE,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM OKL_SIF_TRX_PARMS_V
117: WHERE OKL_SIF_TRX_PARMS_V.id = p_id;
118: l_sxpv_pk sxpv_pk_csr%ROWTYPE;
119: l_sxpv_rec sxpv_rec_type;
120: BEGIN

Line 117: WHERE OKL_SIF_TRX_PARMS_V.id = p_id;

113: CREATION_DATE,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM OKL_SIF_TRX_PARMS_V
117: WHERE OKL_SIF_TRX_PARMS_V.id = p_id;
118: l_sxpv_pk sxpv_pk_csr%ROWTYPE;
119: l_sxpv_rec sxpv_rec_type;
120: BEGIN
121: x_no_data_found := TRUE;

Line 154: -- FUNCTION null_out_defaults for: OKL_SIF_TRX_PARMS_V --

150: RETURN(get_rec(p_sxpv_rec, l_row_notfound));
151: END get_rec;
152:
153: ---------------------------------------------------------
154: -- FUNCTION null_out_defaults for: OKL_SIF_TRX_PARMS_V --
155: ---------------------------------------------------------
156: FUNCTION null_out_defaults (
157: p_sxpv_rec IN sxpv_rec_type
158: ) RETURN sxpv_rec_type IS

Line 214: -- Validate_Attributes for:OKL_SIF_TRX_PARMS_V --

210: ---------------------------------------------------------------------------
211: -- PROCEDURE Validate_Attributes
212: ---------------------------------------------------------------------------
213: -------------------------------------------------
214: -- Validate_Attributes for:OKL_SIF_TRX_PARMS_V --
215: -------------------------------------------------
216: FUNCTION Validate_Attributes (
217: p_sxpv_rec IN sxpv_rec_type
218: ) RETURN VARCHAR2 IS

Line 850: -- Validate_Record for:OKL_SIF_TRX_PARMS_V --

846: ---------------------------------------------------------------------------
847: -- PROCEDURE Validate_Record
848: ---------------------------------------------------------------------------
849: ---------------------------------------------
850: -- Validate_Record for:OKL_SIF_TRX_PARMS_V --
851: ---------------------------------------------
852: FUNCTION Validate_Record (
853: p_sxpv_rec IN sxpv_rec_type
854: ) RETURN VARCHAR2 IS

Line 908: -- validate_row for:OKL_SIF_TRX_PARMS_V --

904: ---------------------------------------------------------------------------
905: -- PROCEDURE validate_row
906: ---------------------------------------------------------------------------
907: ------------------------------------------
908: -- validate_row for:OKL_SIF_TRX_PARMS_V --
909: ------------------------------------------
910: PROCEDURE validate_row(
911: p_api_version IN NUMBER,
912: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1183: -- insert_row for:OKL_SIF_TRX_PARMS_V --

1179: '_PVT'
1180: );
1181: END insert_row;
1182: ----------------------------------------
1183: -- insert_row for:OKL_SIF_TRX_PARMS_V --
1184: ----------------------------------------
1185: PROCEDURE insert_row(
1186: p_api_version IN NUMBER,
1187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1217: -- Set_Attributes for:OKL_SIF_TRX_PARMS_V --

1213: l_sxpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1214: RETURN(l_sxpv_rec);
1215: END fill_who_columns;
1216: --------------------------------------------
1217: -- Set_Attributes for:OKL_SIF_TRX_PARMS_V --
1218: --------------------------------------------
1219: FUNCTION Set_Attributes (
1220: p_sxpv_rec IN sxpv_rec_type,
1221: x_sxpv_rec OUT NOCOPY sxpv_rec_type

Line 1530: -- lock_row for:OKL_SIF_TRX_PARMS_V --

1526: '_PVT'
1527: );
1528: END lock_row;
1529: --------------------------------------
1530: -- lock_row for:OKL_SIF_TRX_PARMS_V --
1531: --------------------------------------
1532: PROCEDURE lock_row(
1533: p_api_version IN NUMBER,
1534: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1879: -- update_row for:OKL_SIF_TRX_PARMS_V --

1875: '_PVT'
1876: );
1877: END update_row;
1878: ----------------------------------------
1879: -- update_row for:OKL_SIF_TRX_PARMS_V --
1880: ----------------------------------------
1881: PROCEDURE update_row(
1882: p_api_version IN NUMBER,
1883: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1989: -- Set_Attributes for:OKL_SIF_TRX_PARMS_V --

1985: END IF;
1986: RETURN(l_return_status);
1987: END populate_new_record;
1988: --------------------------------------------
1989: -- Set_Attributes for:OKL_SIF_TRX_PARMS_V --
1990: --------------------------------------------
1991: FUNCTION Set_Attributes (
1992: p_sxpv_rec IN sxpv_rec_type,
1993: x_sxpv_rec OUT NOCOPY sxpv_rec_type

Line 2256: -- delete_row for:OKL_SIF_TRX_PARMS_V --

2252: '_PVT'
2253: );
2254: END delete_row;
2255: ----------------------------------------
2256: -- delete_row for:OKL_SIF_TRX_PARMS_V --
2257: ----------------------------------------
2258: PROCEDURE delete_row(
2259: p_api_version IN NUMBER,
2260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,