eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CI_DIR_COST_PVT dependencies on PA_CI_DIRECT_COST_DETAILS

Line 87: -- FUNCTION get_rec for: PA_CI_DIRECT_COST_DETAILS

83: null;
84: END api_copy;
85:
86: ---------------------------------------------------------------------------
87: -- FUNCTION get_rec for: PA_CI_DIRECT_COST_DETAILS
88: ---------------------------------------------------------------------------
89: FUNCTION get_rec (
90: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
91: x_no_data_found OUT NOCOPY BOOLEAN

Line 119: FROM Pa_Ci_Direct_Cost_Details

115: CREATION_DATE,
116: LAST_UPDATE_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Pa_Ci_Direct_Cost_Details
120: WHERE pa_ci_direct_cost_details.dc_line_id = p_dc_line_id;
121: l_pa_ci_direct_cost_details_pk pa_ci_direct_cost_d6%ROWTYPE;
122: l_pa_ci_direct_cost8 PaCiDirectCostDetailsRecType;
123: BEGIN

Line 120: WHERE pa_ci_direct_cost_details.dc_line_id = p_dc_line_id;

116: LAST_UPDATE_BY,
117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Pa_Ci_Direct_Cost_Details
120: WHERE pa_ci_direct_cost_details.dc_line_id = p_dc_line_id;
121: l_pa_ci_direct_cost_details_pk pa_ci_direct_cost_d6%ROWTYPE;
122: l_pa_ci_direct_cost8 PaCiDirectCostDetailsRecType;
123: BEGIN
124: x_no_data_found := TRUE;

Line 121: l_pa_ci_direct_cost_details_pk pa_ci_direct_cost_d6%ROWTYPE;

117: LAST_UPDATE_DATE,
118: LAST_UPDATE_LOGIN
119: FROM Pa_Ci_Direct_Cost_Details
120: WHERE pa_ci_direct_cost_details.dc_line_id = p_dc_line_id;
121: l_pa_ci_direct_cost_details_pk pa_ci_direct_cost_d6%ROWTYPE;
122: l_pa_ci_direct_cost8 PaCiDirectCostDetailsRecType;
123: BEGIN
124: x_no_data_found := TRUE;
125:

Line 189: -- FUNCTION null_out_defaults for: PA_CI_DIRECT_COST_DETAILS

185: BEGIN
186: RETURN(get_rec(p_pa_ci_direct_cost1, l_row_not_found));
187: END get_rec;
188: ---------------------------------------------------------------------------
189: -- FUNCTION null_out_defaults for: PA_CI_DIRECT_COST_DETAILS
190: ---------------------------------------------------------------------------
191: FUNCTION null_out_defaults (
192: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType
193: ) RETURN PaCiDirectCostDetailsRecType IS

Line 463: -- Validate_Attributes for:PA_CI_DIRECT_COST_DETAILS --

459: ---------------------------------------------------------------------------
460: -- FUNCTION Validate_Attributes
461: ---------------------------------------------------------------------------
462: -------------------------------------------------------
463: -- Validate_Attributes for:PA_CI_DIRECT_COST_DETAILS --
464: -------------------------------------------------------
465: FUNCTION Validate_Attributes (
466: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType
467: ) RETURN VARCHAR2 IS

Line 555: -- Validate Record for:PA_CI_DIRECT_COST_DETAILS --

551: ---------------------------------------------------------------------------
552: -- PROCEDURE Validate_Record
553: ---------------------------------------------------------------------------
554: ---------------------------------------------------
555: -- Validate Record for:PA_CI_DIRECT_COST_DETAILS --
556: ---------------------------------------------------
557: FUNCTION Validate_Record (
558: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
559: p_db_pa_ci_direct_cos106 IN PaCiDirectCostDetailsRecType

Line 614: -- validate_row for:PA_CI_DIRECT_COST_DETAILS --

610: ---------------------------------------------------------------------------
611: -- PROCEDURE validate_row
612: ---------------------------------------------------------------------------
613: ------------------------------------------------
614: -- validate_row for:PA_CI_DIRECT_COST_DETAILS --
615: ------------------------------------------------
616: PROCEDURE validate_row(
617: p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 689: -- PL/SQL TBL validate_row for:PA_CI_DIRECT_COST_DETAILS --

685: '_PVT'
686: );
687: END validate_row;
688: -----------------------------------------------------------
689: -- PL/SQL TBL validate_row for:PA_CI_DIRECT_COST_DETAILS --
690: -----------------------------------------------------------
691: PROCEDURE validate_row(
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 785: -- PL/SQL TBL validate_row for:PA_CI_DIRECT_COST_DETAILS --

781: );
782: END validate_row;
783:
784: -----------------------------------------------------------
785: -- PL/SQL TBL validate_row for:PA_CI_DIRECT_COST_DETAILS --
786: -----------------------------------------------------------
787: PROCEDURE validate_row(
788: p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 875: -- insert_row for:PA_CI_DIRECT_COST_DETAILS --

871: ---------------------------------------------------------------------------
872: -- PROCEDURE insert_row
873: ---------------------------------------------------------------------------
874: ----------------------------------------------
875: -- insert_row for:PA_CI_DIRECT_COST_DETAILS --
876: ----------------------------------------------
877: PROCEDURE insert_row(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 892: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --

888: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
889: l_pa_ci_direct_cost8 PaCiDirectCostDetailsRecType := p_pa_ci_direct_cost1;
890: LDefPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;
891: --------------------------------------------------
892: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --
893: --------------------------------------------------
894: FUNCTION Set_Attributes (
895: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
896: XPaCiDirectCostDetailsRec OUT NOCOPY PaCiDirectCostDetailsRecType

Line 923: INSERT INTO PA_CI_DIRECT_COST_DETAILS(

919: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
920: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
921: RAISE PA_API.G_EXCEPTION_ERROR;
922: END IF;
923: INSERT INTO PA_CI_DIRECT_COST_DETAILS(
924: dc_line_id,
925: ci_id,
926: project_id,
927: task_id,

Line 1014: -- insert_row for:PA_CI_DIRECT_COST_DETAILS --

1010: ---------------------------------------------------------------------------
1011: -- PROCEDURE insert_row
1012: ---------------------------------------------------------------------------
1013: ----------------------------------------------
1014: -- insert_row for:PA_CI_DIRECT_COST_DETAILS --
1015: ----------------------------------------------
1016: PROCEDURE insert_row(
1017: p_api_version IN NUMBER,
1018: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1099: -- lock_row for:PA_CI_DIRECT_COST_DETAILS --

1095: ---------------------------------------------------------------------------
1096: -- PROCEDURE lock_row
1097: ---------------------------------------------------------------------------
1098: --------------------------------------------
1099: -- lock_row for:PA_CI_DIRECT_COST_DETAILS --
1100: --------------------------------------------
1101: PROCEDURE lock_row(
1102: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
1103: x_return_status OUT NOCOPY VARCHAR2,

Line 1112: FROM PA_CI_DIRECT_COST_DETAILS

1108: E_Resource_Busy EXCEPTION;
1109: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1110: CURSOR lock_csr (p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType) IS
1111: SELECT *
1112: FROM PA_CI_DIRECT_COST_DETAILS
1113: WHERE DC_LINE_ID = p_pa_ci_direct_cost1.dc_line_id
1114: FOR UPDATE NOWAIT;
1115:
1116: l_api_version CONSTANT NUMBER := 1;

Line 1213: -- lock_row for: PA_CI_DIRECT_COST_DETAILS --

1209: '_PVT'
1210: );
1211: END lock_row;
1212: ---------------------------------------------
1213: -- lock_row for: PA_CI_DIRECT_COST_DETAILS --
1214: ---------------------------------------------
1215: PROCEDURE lock_row(
1216: p_api_version IN NUMBER,
1217: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1294: -- PL/SQL TBL lock_row for:PA_CI_DIRECT_COST_DETAILS_TBL --

1290: '_PVT'
1291: );
1292: END lock_row;
1293: -----------------------------------------------------------
1294: -- PL/SQL TBL lock_row for:PA_CI_DIRECT_COST_DETAILS_TBL --
1295: -----------------------------------------------------------
1296: PROCEDURE lock_row(
1297: p_api_version IN NUMBER,
1298: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1389: -- PL/SQL TBL lock_row for:PA_CI_DIRECT_COST_DETAILS_TBL --

1385: '_PVT'
1386: );
1387: END lock_row;
1388: -----------------------------------------------------------
1389: -- PL/SQL TBL lock_row for:PA_CI_DIRECT_COST_DETAILS_TBL --
1390: -----------------------------------------------------------
1391: PROCEDURE lock_row(
1392: p_api_version IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1453: -- update_row for:PA_CI_DIRECT_COST_DETAILS --

1449: ---------------------------------------------------------------------------
1450: -- PROCEDURE update_row
1451: ---------------------------------------------------------------------------
1452: ----------------------------------------------
1453: -- update_row for:PA_CI_DIRECT_COST_DETAILS --
1454: ----------------------------------------------
1455:
1456: PROCEDURE update_row(
1457: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1585: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --

1581: END IF;
1582: RETURN(l_return_status);
1583: END populate_new_record;
1584: --------------------------------------------------
1585: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --
1586: --------------------------------------------------
1587: FUNCTION Set_Attributes (
1588: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
1589: XPaCiDirectCostDetailsRec OUT NOCOPY PaCiDirectCostDetailsRecType

Line 1624: UPDATE PA_CI_DIRECT_COST_DETAILS

1620: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
1621: RAISE PA_API.G_EXCEPTION_ERROR;
1622: END IF;
1623:
1624: UPDATE PA_CI_DIRECT_COST_DETAILS
1625: SET CI_ID = LDefPaCiDirectCostDetailsRec.ci_id,
1626: PROJECT_ID = LDefPaCiDirectCostDetailsRec.project_id,
1627: TASK_ID = LDefPaCiDirectCostDetailsRec.task_id,
1628: EXPENDITURE_TYPE = LDefPaCiDirectCostDetailsRec.expenditure_type,

Line 1687: -- update_row for:PA_CI_DIRECT_COST_DETAILS --

1683: );
1684: END update_row;
1685:
1686: ----------------------------------------------
1687: -- update_row for:PA_CI_DIRECT_COST_DETAILS --
1688: ----------------------------------------------
1689: PROCEDURE update_row(
1690: p_api_version IN NUMBER,
1691: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 1836: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --

1832: END IF;
1833: RETURN(l_return_status);
1834: END populate_new_record;
1835: --------------------------------------------------
1836: -- Set_Attributes for:PA_CI_DIRECT_COST_DETAILS --
1837: --------------------------------------------------
1838: FUNCTION Set_Attributes (
1839: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
1840: XPaCiDirectCostDetailsRec OUT NOCOPY PaCiDirectCostDetailsRecType

Line 1969: -- PL/SQL TBL update_row for:pa_ci_direct_cost_details_tbl --

1965: '_PVT'
1966: );
1967: END update_row;
1968: -------------------------------------------------------------
1969: -- PL/SQL TBL update_row for:pa_ci_direct_cost_details_tbl --
1970: -------------------------------------------------------------
1971: PROCEDURE update_row(
1972: p_api_version IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 2067: -- PL/SQL TBL update_row for:PA_CI_DIRECT_COST_DETAILS_TBL --

2063: );
2064: END update_row;
2065:
2066: -------------------------------------------------------------
2067: -- PL/SQL TBL update_row for:PA_CI_DIRECT_COST_DETAILS_TBL --
2068: -------------------------------------------------------------
2069: PROCEDURE update_row(
2070: p_api_version IN NUMBER,
2071: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 2134: -- delete_row for:PA_CI_DIRECT_COST_DETAILS --

2130: ---------------------------------------------------------------------------
2131: -- PROCEDURE delete_row
2132: ---------------------------------------------------------------------------
2133: ----------------------------------------------
2134: -- delete_row for:PA_CI_DIRECT_COST_DETAILS --
2135: ----------------------------------------------
2136: PROCEDURE delete_row(
2137: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
2138: x_return_status OUT NOCOPY VARCHAR2,

Line 2159: DELETE FROM PA_CI_DIRECT_COST_DETAILS

2155: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
2156: RAISE PA_API.G_EXCEPTION_ERROR;
2157: END IF;
2158:
2159: DELETE FROM PA_CI_DIRECT_COST_DETAILS
2160: WHERE DC_LINE_ID = p_pa_ci_direct_cost1.dc_line_id;
2161:
2162: x_return_status := l_return_status;
2163: PA_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2197: -- delete_row for:PA_CI_DIRECT_COST_DETAILS --

2193: '_PVT'
2194: );
2195: END delete_row;
2196: ----------------------------------------------
2197: -- delete_row for:PA_CI_DIRECT_COST_DETAILS --
2198: ----------------------------------------------
2199: PROCEDURE delete_row(
2200: p_api_version IN NUMBER,
2201: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 2278: -- PL/SQL TBL delete_row for:PA_CI_DIRECT_COST_DETAILS --

2274: '_PVT'
2275: );
2276: END delete_row;
2277: ---------------------------------------------------------
2278: -- PL/SQL TBL delete_row for:PA_CI_DIRECT_COST_DETAILS --
2279: ---------------------------------------------------------
2280: PROCEDURE delete_row(
2281: p_api_version IN NUMBER,
2282: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

Line 2374: -- PL/SQL TBL delete_row for:PA_CI_DIRECT_COST_DETAILS --

2370: );
2371: END delete_row;
2372:
2373: ---------------------------------------------------------
2374: -- PL/SQL TBL delete_row for:PA_CI_DIRECT_COST_DETAILS --
2375: ---------------------------------------------------------
2376: PROCEDURE delete_row(
2377: p_api_version IN NUMBER,
2378: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,