DBA Data[Home] [Help]

APPS.OKL_LDB_PVT dependencies on OKL_PARTY_PAYMENT_HDR_V

Line 94: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_PARTY_PAYMENT_HDR_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_pphv_rec IN pphv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_pphv_rec IN pphv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN pphv_rec_type IS
100: CURSOR okl_party_payment_hdr_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: OBJECT_VERSION_NUMBER,
104: DNZ_CHR_ID,

Line 119: FROM Okl_Party_Payment_Hdr_V

115: CREATION_DATE,
116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN

Line 120: WHERE okl_party_payment_hdr_v.id = p_id;

116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;

Line 121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;

117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Okl_Party_Payment_Hdr_V
120: WHERE okl_party_payment_hdr_v.id = p_id;
121: l_okl_party_payment_hdr_v_pk okl_party_payment_hdr_v_pk_csr%ROWTYPE;
122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values

Line 126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);

122: l_pphv_rec pphv_rec_type;
123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values
126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
127: FETCH okl_party_payment_hdr_v_pk_csr INTO
128: l_pphv_rec.id,
129: l_pphv_rec.object_version_number,
130: l_pphv_rec.dnz_chr_id,

Line 127: FETCH okl_party_payment_hdr_v_pk_csr INTO

123: BEGIN
124: x_no_data_found := TRUE;
125: -- Get current database values
126: OPEN okl_party_payment_hdr_v_pk_csr (p_pphv_rec.id);
127: FETCH okl_party_payment_hdr_v_pk_csr INTO
128: l_pphv_rec.id,
129: l_pphv_rec.object_version_number,
130: l_pphv_rec.dnz_chr_id,
131: l_pphv_rec.cle_id,

Line 145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;

141: l_pphv_rec.creation_date,
142: l_pphv_rec.last_updated_by,
143: l_pphv_rec.last_update_date,
144: l_pphv_rec.last_update_login;
145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
146: CLOSE okl_party_payment_hdr_v_pk_csr;
147: RETURN(l_pphv_rec);
148: END get_rec;
149:

Line 146: CLOSE okl_party_payment_hdr_v_pk_csr;

142: l_pphv_rec.last_updated_by,
143: l_pphv_rec.last_update_date,
144: l_pphv_rec.last_update_login;
145: x_no_data_found := okl_party_payment_hdr_v_pk_csr%NOTFOUND;
146: CLOSE okl_party_payment_hdr_v_pk_csr;
147: RETURN(l_pphv_rec);
148: END get_rec;
149:
150: ------------------------------------------------------------------

Line 264: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_HDR_V

260: BEGIN
261: RETURN(get_rec(p_pph_rec, l_row_not_found));
262: END get_rec;
263: ---------------------------------------------------------------------------
264: -- FUNCTION null_out_defaults for: OKL_PARTY_PAYMENT_HDR_V
265: ---------------------------------------------------------------------------
266: FUNCTION null_out_defaults (
267: p_pphv_rec IN pphv_rec_type
268: ) RETURN pphv_rec_type IS

Line 519: -- Validate_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

515: ---------------------------------------------------------------------------
516: -- FUNCTION Validate_Attributes
517: ---------------------------------------------------------------------------
518: -----------------------------------------------------
519: -- Validate_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
520: -----------------------------------------------------
521: FUNCTION Validate_Attributes (
522: p_pphv_rec IN pphv_rec_type
523: ) RETURN VARCHAR2 IS

Line 584: -- Validate Record for:OKL_PARTY_PAYMENT_HDR_V --

580: ---------------------------------------------------------------------------
581: -- PROCEDURE Validate_Record
582: ---------------------------------------------------------------------------
583: -------------------------------------------------
584: -- Validate Record for:OKL_PARTY_PAYMENT_HDR_V --
585: -------------------------------------------------
586: FUNCTION Validate_Record (
587: p_pphv_rec IN pphv_rec_type,
588: p_db_pphv_rec IN pphv_rec_type

Line 659: -- validate_row for:OKL_PARTY_PAYMENT_HDR_V --

655: ---------------------------------------------------------------------------
656: -- PROCEDURE validate_row
657: ---------------------------------------------------------------------------
658: ----------------------------------------------
659: -- validate_row for:OKL_PARTY_PAYMENT_HDR_V --
660: ----------------------------------------------
661: PROCEDURE validate_row(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 736: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --

732: '_PVT'
733: );
734: END validate_row;
735: ---------------------------------------------------------
736: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --
737: ---------------------------------------------------------
738: PROCEDURE validate_row(
739: p_api_version IN NUMBER,
740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 832: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --

828: );
829: END validate_row;
830:
831: ---------------------------------------------------------
832: -- PL/SQL TBL validate_row for:OKL_PARTY_PAYMENT_HDR_V --
833: ---------------------------------------------------------
834: PROCEDURE validate_row(
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1023: -- insert_row for :OKL_PARTY_PAYMENT_HDR_V --

1019: '_PVT'
1020: );
1021: END insert_row;
1022: ---------------------------------------------
1023: -- insert_row for :OKL_PARTY_PAYMENT_HDR_V --
1024: ---------------------------------------------
1025: PROCEDURE insert_row(
1026: p_api_version IN NUMBER,
1027: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1057: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

1053: l_pphv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1054: RETURN(l_pphv_rec);
1055: END fill_who_columns;
1056: ------------------------------------------------
1057: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
1058: ------------------------------------------------
1059: FUNCTION Set_Attributes (
1060: p_pphv_rec IN pphv_rec_type,
1061: x_pphv_rec OUT NOCOPY pphv_rec_type

Line 1440: -- lock_row for: OKL_PARTY_PAYMENT_HDR_V --

1436: '_PVT'
1437: );
1438: END lock_row;
1439: -------------------------------------------
1440: -- lock_row for: OKL_PARTY_PAYMENT_HDR_V --
1441: -------------------------------------------
1442: PROCEDURE lock_row(
1443: p_api_version IN NUMBER,
1444: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1873: -- update_row for:OKL_PARTY_PAYMENT_HDR_V --

1869: '_PVT'
1870: );
1871: END update_row;
1872: --------------------------------------------
1873: -- update_row for:OKL_PARTY_PAYMENT_HDR_V --
1874: --------------------------------------------
1875: PROCEDURE update_row(
1876: p_api_version IN NUMBER,
1877: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1993: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --

1989: END IF;
1990: RETURN(l_return_status);
1991: END populate_new_record;
1992: ------------------------------------------------
1993: -- Set_Attributes for:OKL_PARTY_PAYMENT_HDR_V --
1994: ------------------------------------------------
1995: FUNCTION Set_Attributes (
1996: p_pphv_rec IN pphv_rec_type,
1997: x_pphv_rec OUT NOCOPY pphv_rec_type

Line 2349: -- delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2345: '_PVT'
2346: );
2347: END delete_row;
2348: --------------------------------------------
2349: -- delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2350: --------------------------------------------
2351: PROCEDURE delete_row(
2352: p_api_version IN NUMBER,
2353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2431: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2427: '_PVT'
2428: );
2429: END delete_row;
2430: -------------------------------------------------------
2431: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2432: -------------------------------------------------------
2433: PROCEDURE delete_row(
2434: p_api_version IN NUMBER,
2435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2527: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --

2523: );
2524: END delete_row;
2525:
2526: -------------------------------------------------------
2527: -- PL/SQL TBL delete_row for:OKL_PARTY_PAYMENT_HDR_V --
2528: -------------------------------------------------------
2529: PROCEDURE delete_row(
2530: p_api_version IN NUMBER,
2531: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,