DBA Data[Home] [Help]

APPS.IEX_REP_PVT dependencies on IEX_REPOS_OBJECTS_V

Line 98: -- FUNCTION get_rec for: IEX_REPOS_OBJECTS_V

94: null;
95: END api_copy;
96:
97: ---------------------------------------------------------------------------
98: -- FUNCTION get_rec for: IEX_REPOS_OBJECTS_V
99: ---------------------------------------------------------------------------
100: FUNCTION get_rec (
101: p_repv_rec IN repv_rec_type,
102: x_no_data_found OUT NOCOPY BOOLEAN

Line 141: FROM Iex_Repos_Objects_V

137: LAST_UPDATED_BY,
138: LAST_UPDATE_DATE,
139: LAST_UPDATE_LOGIN,
140: SECURITY_GROUP_ID
141: FROM Iex_Repos_Objects_V
142: WHERE iex_repos_objects_v.repos_object_id = p_repos_object_id;
143: l_iex_repv_pk iex_repv_pk_csr%ROWTYPE;
144: l_repv_rec repv_rec_type;
145: BEGIN

Line 142: WHERE iex_repos_objects_v.repos_object_id = p_repos_object_id;

138: LAST_UPDATE_DATE,
139: LAST_UPDATE_LOGIN,
140: SECURITY_GROUP_ID
141: FROM Iex_Repos_Objects_V
142: WHERE iex_repos_objects_v.repos_object_id = p_repos_object_id;
143: l_iex_repv_pk iex_repv_pk_csr%ROWTYPE;
144: l_repv_rec repv_rec_type;
145: BEGIN
146: x_no_data_found := TRUE;

Line 338: -- FUNCTION null_out_defaults for: IEX_REPOS_OBJECTS_V

334: BEGIN
335: RETURN(get_rec(p_rep_rec, l_row_not_found));
336: END get_rec;
337: ---------------------------------------------------------------------------
338: -- FUNCTION null_out_defaults for: IEX_REPOS_OBJECTS_V
339: ---------------------------------------------------------------------------
340: FUNCTION null_out_defaults (
341: p_repv_rec IN repv_rec_type
342: ) RETURN repv_rec_type AS

Line 509: p_token2_value => 'IEX_REPOS_OBJECTS_V',

505: p_msg_name => G_NO_PARENT_RECORD,
506: p_token1 => G_COL_NAME_TOKEN,
507: p_token1_value => 'repossession_id',
508: p_token2 => G_CHILD_TABLE_TOKEN,
509: p_token2_value => 'IEX_REPOS_OBJECTS_V',
510: p_token3 => G_PARENT_TABLE_TOKEN,
511: p_token3_value => 'IEX_REPOSSESSIONS');
512: l_return_status := OKL_API.G_RET_STS_ERROR;
513: --dbms_output.put_line('Status after setting message : ' || l_return_status);

Line 564: p_token2_value => 'IEX_REPOS_OBJECTS_V',

560: p_msg_name => G_NO_PARENT_RECORD,
561: p_token1 => G_COL_NAME_TOKEN,
562: p_token1_value => 'asset_id',
563: p_token2 => G_CHILD_TABLE_TOKEN,
564: p_token2_value => 'IEX_REPOS_OBJECTS_V',
565: p_token3 => G_PARENT_TABLE_TOKEN,
566: p_token3_value => 'OKX_ASSET_LINES_V');
567: l_return_status := OKL_API.G_RET_STS_ERROR;
568: END IF;

Line 614: p_token2_value => 'IEX_REPOS_OBJECTS_V',

610: p_msg_name => G_NO_PARENT_RECORD,
611: p_token1 => G_COL_NAME_TOKEN,
612: p_token1_value => 'rna_id',
613: p_token2 => G_CHILD_TABLE_TOKEN,
614: p_token2_value => 'IEX_REPOS_OBJECTS_V',
615: p_token3 => G_PARENT_TABLE_TOKEN,
616: p_token3_value => 'PO_VENDORS');
617: l_return_status := OKL_API.G_RET_STS_ERROR;
618: END IF;

Line 706: p_token2_value => 'IEX_REPOS_OBJECTS_V',

702: p_msg_name => G_NO_PARENT_RECORD,
703: p_token1 => G_COL_NAME_TOKEN,
704: p_token1_value => 'art_id',
705: p_token2 => G_CHILD_TABLE_TOKEN,
706: p_token2_value => 'IEX_REPOS_OBJECTS_V',
707: p_token3 => G_PARENT_TABLE_TOKEN,
708: p_token3_value => 'OKL_ASSET_RETURNS_B');
709: l_return_status := OKL_API.G_RET_STS_ERROR;
710: END IF;

Line 755: -- Validate_Attributes for:IEX_REPOS_OBJECTS_V --

751: ---------------------------------------------------------------------------
752: -- FUNCTION Validate_Attributes
753: ---------------------------------------------------------------------------
754: -------------------------------------------------
755: -- Validate_Attributes for:IEX_REPOS_OBJECTS_V --
756: -------------------------------------------------
757: FUNCTION Validate_Attributes (
758: p_repv_rec IN repv_rec_type
759: ) RETURN VARCHAR2 AS

Line 876: -- Validate Record for:IEX_REPOS_OBJECTS_V --

872: ---------------------------------------------------------------------------
873: -- PROCEDURE Validate_Record
874: ---------------------------------------------------------------------------
875: ---------------------------------------------
876: -- Validate Record for:IEX_REPOS_OBJECTS_V --
877: ---------------------------------------------
878: FUNCTION Validate_Record (
879: p_repv_rec IN repv_rec_type,
880: p_db_repv_rec IN repv_rec_type

Line 984: -- validate_row for:IEX_REPOS_OBJECTS_V --

980: ---------------------------------------------------------------------------
981: -- PROCEDURE validate_row
982: ---------------------------------------------------------------------------
983: ------------------------------------------
984: -- validate_row for:IEX_REPOS_OBJECTS_V --
985: ------------------------------------------
986: PROCEDURE validate_row(
987: p_api_version IN NUMBER,
988: p_init_msg_list IN VARCHAR2,

Line 1061: -- PL/SQL TBL validate_row for:IEX_REPOS_OBJECTS_V --

1057: '_PVT'
1058: );
1059: END validate_row;
1060: -----------------------------------------------------
1061: -- PL/SQL TBL validate_row for:IEX_REPOS_OBJECTS_V --
1062: -----------------------------------------------------
1063: PROCEDURE validate_row(
1064: p_api_version IN NUMBER,
1065: p_init_msg_list IN VARCHAR2,

Line 1157: -- PL/SQL TBL validate_row for:IEX_REPOS_OBJECTS_V --

1153: );
1154: END validate_row;
1155:
1156: -----------------------------------------------------
1157: -- PL/SQL TBL validate_row for:IEX_REPOS_OBJECTS_V --
1158: -----------------------------------------------------
1159: PROCEDURE validate_row(
1160: p_api_version IN NUMBER,
1161: p_init_msg_list IN VARCHAR2,

Line 1376: -- insert_row for :IEX_REPOS_OBJECTS_V --

1372: '_PVT'
1373: );
1374: END insert_row;
1375: -----------------------------------------
1376: -- insert_row for :IEX_REPOS_OBJECTS_V --
1377: -----------------------------------------
1378: PROCEDURE insert_row(
1379: p_api_version IN NUMBER,
1380: p_init_msg_list IN VARCHAR2,

Line 1410: -- Set_Attributes for:IEX_REPOS_OBJECTS_V --

1406: l_repv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1407: RETURN(l_repv_rec);
1408: END fill_who_columns;
1409: --------------------------------------------
1410: -- Set_Attributes for:IEX_REPOS_OBJECTS_V --
1411: --------------------------------------------
1412: FUNCTION Set_Attributes (
1413: p_repv_rec IN repv_rec_type,
1414: x_repv_rec OUT NOCOPY repv_rec_type

Line 1793: -- lock_row for: IEX_REPOS_OBJECTS_V --

1789: '_PVT'
1790: );
1791: END lock_row;
1792: ---------------------------------------
1793: -- lock_row for: IEX_REPOS_OBJECTS_V --
1794: ---------------------------------------
1795: PROCEDURE lock_row(
1796: p_api_version IN NUMBER,
1797: p_init_msg_list IN VARCHAR2,

Line 2314: -- update_row for:IEX_REPOS_OBJECTS_V --

2310: '_PVT'
2311: );
2312: END update_row;
2313: ----------------------------------------
2314: -- update_row for:IEX_REPOS_OBJECTS_V --
2315: ----------------------------------------
2316: PROCEDURE update_row(
2317: p_api_version IN NUMBER,
2318: p_init_msg_list IN VARCHAR2,

Line 2502: -- Set_Attributes for:IEX_REPOS_OBJECTS_V --

2498: END IF;
2499: RETURN(l_return_status);
2500: END populate_new_record;
2501: --------------------------------------------
2502: -- Set_Attributes for:IEX_REPOS_OBJECTS_V --
2503: --------------------------------------------
2504: FUNCTION Set_Attributes (
2505: p_repv_rec IN repv_rec_type,
2506: x_repv_rec OUT NOCOPY repv_rec_type

Line 2857: -- delete_row for:IEX_REPOS_OBJECTS_V --

2853: '_PVT'
2854: );
2855: END delete_row;
2856: ----------------------------------------
2857: -- delete_row for:IEX_REPOS_OBJECTS_V --
2858: ----------------------------------------
2859: PROCEDURE delete_row(
2860: p_api_version IN NUMBER,
2861: p_init_msg_list IN VARCHAR2,

Line 2939: -- PL/SQL TBL delete_row for:IEX_REPOS_OBJECTS_V --

2935: '_PVT'
2936: );
2937: END delete_row;
2938: ---------------------------------------------------
2939: -- PL/SQL TBL delete_row for:IEX_REPOS_OBJECTS_V --
2940: ---------------------------------------------------
2941: PROCEDURE delete_row(
2942: p_api_version IN NUMBER,
2943: p_init_msg_list IN VARCHAR2,

Line 3035: -- PL/SQL TBL delete_row for:IEX_REPOS_OBJECTS_V --

3031: );
3032: END delete_row;
3033:
3034: ---------------------------------------------------
3035: -- PL/SQL TBL delete_row for:IEX_REPOS_OBJECTS_V --
3036: ---------------------------------------------------
3037: PROCEDURE delete_row(
3038: p_api_version IN NUMBER,
3039: p_init_msg_list IN VARCHAR2,