DBA Data[Home] [Help]

APPS.OKL_PYD_PVT dependencies on OKL_PARTY_PAYMENT_DTLS_V

Line 101: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_DTLS_V

97: null;
98: END api_copy;
99:
100: ---------------------------------------------------------------------------
101: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_DTLS_V
102: ---------------------------------------------------------------------------
103: FUNCTION get_rec (
104: p_ppydv_rec IN ppydv_rec_type,
105: x_no_data_found OUT NOCOPY BOOLEAN

Line 152: FROM Okl_Party_Payment_Dtls_V

148: LAST_UPDATED_BY,
149: LAST_UPDATE_DATE,
150: LAST_UPDATE_LOGIN,
151: ORIG_CONTRACT_LINE_ID
152: FROM Okl_Party_Payment_Dtls_V
153: WHERE okl_party_payment_dtls_v.id = p_id;
154: l_okl_party_payment_dtls_v_pk okl_party_payment_d1%ROWTYPE;
155: l_ppydv_rec ppydv_rec_type;
156: BEGIN

Line 153: WHERE okl_party_payment_dtls_v.id = p_id;

149: LAST_UPDATE_DATE,
150: LAST_UPDATE_LOGIN,
151: ORIG_CONTRACT_LINE_ID
152: FROM Okl_Party_Payment_Dtls_V
153: WHERE okl_party_payment_dtls_v.id = p_id;
154: l_okl_party_payment_dtls_v_pk okl_party_payment_d1%ROWTYPE;
155: l_ppydv_rec ppydv_rec_type;
156: BEGIN
157: x_no_data_found := TRUE;

Line 154: l_okl_party_payment_dtls_v_pk okl_party_payment_d1%ROWTYPE;

150: LAST_UPDATE_LOGIN,
151: ORIG_CONTRACT_LINE_ID
152: FROM Okl_Party_Payment_Dtls_V
153: WHERE okl_party_payment_dtls_v.id = p_id;
154: l_okl_party_payment_dtls_v_pk okl_party_payment_d1%ROWTYPE;
155: l_ppydv_rec ppydv_rec_type;
156: BEGIN
157: x_no_data_found := TRUE;
158: -- Get current database values

Line 375: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_DTLS_V

371: BEGIN
372: RETURN(get_rec(p_ppyd_rec, l_row_not_found));
373: END get_rec;
374: ---------------------------------------------------------------------------
375: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_DTLS_V
376: ---------------------------------------------------------------------------
377: FUNCTION null_out_defaults (
378: p_ppydv_rec IN ppydv_rec_type
379: ) RETURN ppydv_rec_type IS

Line 1122: -- Validate_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --

1118: -- FUNCTION Validate_Attributes
1119: ---------------------------------------------------------------------------
1120:
1121: ------------------------------------------------------
1122: -- Validate_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --
1123: ------------------------------------------------------
1124: FUNCTION Validate_Attributes (
1125: p_ppydv_rec IN ppydv_rec_type
1126: ) RETURN VARCHAR2 IS

Line 1268: -- Validate Record for:OKL_PARTY_PAYMENT_DTLS_V --

1264: ---------------------------------------------------------------------------
1265: -- PROCEDURE Validate_Record
1266: ---------------------------------------------------------------------------
1267: --------------------------------------------------
1268: -- Validate Record for:OKL_PARTY_PAYMENT_DTLS_V --
1269: --------------------------------------------------
1270: FUNCTION Validate_Record (
1271: p_ppydv_rec IN ppydv_rec_type,
1272: p_db_ppydv_rec IN ppydv_rec_type

Line 1448: -- validate_row for:OKL_PARTY_PAYMENT_DTLS_V --

1444: ---------------------------------------------------------------------------
1445: -- PROCEDURE validate_row
1446: ---------------------------------------------------------------------------
1447: -----------------------------------------------
1448: -- validate_row for:OKL_PARTY_PAYMENT_DTLS_V --
1449: -----------------------------------------------
1450: PROCEDURE validate_row(
1451: p_api_version IN NUMBER,
1452: p_init_msg_list IN VARCHAR2,

Line 1525: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_DTLS_V --

1521: '_PVT'
1522: );
1523: END validate_row;
1524: ----------------------------------------------------------
1525: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_DTLS_V --
1526: ----------------------------------------------------------
1527: PROCEDURE validate_row(
1528: p_api_version IN NUMBER,
1529: p_init_msg_list IN VARCHAR2,

Line 1621: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_DTLS_V --

1617: );
1618: END validate_row;
1619:
1620: ----------------------------------------------------------
1621: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_DTLS_V --
1622: ----------------------------------------------------------
1623: PROCEDURE validate_row(
1624: p_api_version IN NUMBER,
1625: p_init_msg_list IN VARCHAR2,

Line 1858: -- insert_row for :OKL_PARTY_PAYMENT_DTLS_V --

1854: '_PVT'
1855: );
1856: END insert_row;
1857: ----------------------------------------------
1858: -- insert_row for :OKL_PARTY_PAYMENT_DTLS_V --
1859: ----------------------------------------------
1860: PROCEDURE insert_row(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2,

Line 1893: -- Set_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --

1889: l_ppydv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1890: RETURN(l_ppydv_rec);
1891: END fill_who_columns;
1892: -------------------------------------------------
1893: -- Set_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --
1894: -------------------------------------------------
1895: FUNCTION Set_Attributes (
1896: p_ppydv_rec IN ppydv_rec_type,
1897: x_ppydv_rec OUT NOCOPY ppydv_rec_type

Line 2293: -- lock_row for: OKL_PARTY_PAYMENT_DTLS_V --

2289: '_PVT'
2290: );
2291: END lock_row;
2292: --------------------------------------------
2293: -- lock_row for: OKL_PARTY_PAYMENT_DTLS_V --
2294: --------------------------------------------
2295: PROCEDURE lock_row(
2296: p_api_version IN NUMBER,
2297: p_init_msg_list IN VARCHAR2,

Line 2862: -- update_row for:OKL_PARTY_PAYMENT_DTLS_V --

2858: '_PVT'
2859: );
2860: END update_row;
2861: ---------------------------------------------
2862: -- update_row for:OKL_PARTY_PAYMENT_DTLS_V --
2863: ---------------------------------------------
2864: PROCEDURE update_row(
2865: p_api_version IN NUMBER,
2866: p_init_msg_list IN VARCHAR2,

Line 3090: -- Set_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --

3086: END IF;
3087: RETURN(l_return_status);
3088: END populate_new_record;
3089: -------------------------------------------------
3090: -- Set_Attributes for:OKL_PARTY_PAYMENT_DTLS_V --
3091: -------------------------------------------------
3092: FUNCTION Set_Attributes (
3093: p_ppydv_rec IN ppydv_rec_type,
3094: x_ppydv_rec OUT NOCOPY ppydv_rec_type

Line 3465: -- delete_row for:OKL_PARTY_PAYMENT_DTLS_V --

3461: '_PVT'
3462: );
3463: END delete_row;
3464: ---------------------------------------------
3465: -- delete_row for:OKL_PARTY_PAYMENT_DTLS_V --
3466: ---------------------------------------------
3467: PROCEDURE delete_row(
3468: p_api_version IN NUMBER,
3469: p_init_msg_list IN VARCHAR2,

Line 3482: SELECT cpl_id FROM okl_party_payment_dtls_v

3478: l_ppydv_rec ppydv_rec_type := p_ppydv_rec;
3479: l_ppyd_rec ppyd_rec_type;
3480:
3481: CURSOR l_get_cpl_id_csr(p_id IN NUMBER) IS
3482: SELECT cpl_id FROM okl_party_payment_dtls_v
3483: WHERE id = p_id;
3484: l_cpl_id NUMBER;
3485: BEGIN
3486: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3573: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_DTLS_V --

3569: '_PVT'
3570: );
3571: END delete_row;
3572: --------------------------------------------------------
3573: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_DTLS_V --
3574: --------------------------------------------------------
3575: PROCEDURE delete_row(
3576: p_api_version IN NUMBER,
3577: p_init_msg_list IN VARCHAR2,

Line 3669: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_DTLS_V --

3665: );
3666: END delete_row;
3667:
3668: --------------------------------------------------------
3669: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_DTLS_V --
3670: --------------------------------------------------------
3671: PROCEDURE delete_row(
3672: p_api_version IN NUMBER,
3673: p_init_msg_list IN VARCHAR2,