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.CSFW_DEBRIEF_PUB dependencies on CSF_DEBRIEF_PUB

Line 11: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;

7: , p_error OUT NOCOPY VARCHAR2
8: , p_debrief_header_id OUT NOCOPY NUMBER
9: )
10: IS
11: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
12: x_header_id number;
13: l_return_status varchar2(2000);
14: l_msg_count number;
15: l_msg_data varchar2(2000);

Line 43: CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals(

39: P_DEBRIEF_Rec.DEBRIEF_NUMBER := to_char(l_debrief_number);
40: P_DEBRIEF_Rec.DEBRIEF_DATE := sysdate;
41: P_DEBRIEF_Rec.TASK_ASSIGNMENT_ID := p_task_assignment_id;
42:
43: CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals(
44: P_Api_Version_Number => 1.0,
45: P_Init_Msg_List => FND_API.G_FALSE,
46: P_Commit => FND_API.G_FALSE,
47: P_DEBRIEF_Rec => P_DEBRIEF_Rec,

Line 48: P_DEBRIEF_LINE_tbl => CSF_DEBRIEF_PUB.G_MISS_DEBRIEF_LINE_Tbl ,

44: P_Api_Version_Number => 1.0,
45: P_Init_Msg_List => FND_API.G_FALSE,
46: P_Commit => FND_API.G_FALSE,
47: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
48: P_DEBRIEF_LINE_tbl => CSF_DEBRIEF_PUB.G_MISS_DEBRIEF_LINE_Tbl ,
49: X_DEBRIEF_HEADER_ID => x_header_id,
50: X_Return_Status => l_return_status,
51: X_Msg_Count => l_msg_count,
52: X_Msg_Data => l_msg_data

Line 143: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

139: l_dbf_line_id number;
140: l_user number;
141: l_data varchar2(2000);
142: l_msg_index_out number;
143: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
144: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
145: l_organization_id number;
146: l_UOM_code varchar2(100);
147: l_order_header_id number;

Line 144: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

140: l_user number;
141: l_data varchar2(2000);
142: l_msg_index_out number;
143: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
144: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
145: l_organization_id number;
146: l_UOM_code varchar2(100);
147: l_order_header_id number;
148: l_order_type_id number;

Line 445: CSF_DEBRIEF_PUB.Create_debrief_lines(

441: P_DEBRIEF_LINE_Rec.QUANTITY := p_quantity;
442: END IF;
443:
444: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
445: CSF_DEBRIEF_PUB.Create_debrief_lines(
446: P_Api_Version_Number => 1.0,
447: P_Init_Msg_List => FND_API.G_FALSE,
448: P_Commit => FND_API.G_TRUE,
449: P_Upd_tskassgnstatus => NULL,

Line 533: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

529: l_dbf_line_id number;
530: l_user number;
531: l_data varchar2(2000);
532: l_msg_index_out number;
533: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
534: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
535: l_organization_id number;
536: l_UOM_code varchar2(100);
537: l_order_header_id number;

Line 534: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

530: l_user number;
531: l_data varchar2(2000);
532: l_msg_index_out number;
533: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
534: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
535: l_organization_id number;
536: l_UOM_code varchar2(100);
537: l_order_header_id number;
538: l_order_type_id number;

Line 732: CSF_DEBRIEF_PUB.Create_debrief_lines(

728: P_DEBRIEF_LINE_Rec.PROJECT_ID := l_project_id;
729: P_DEBRIEF_LINE_Rec.PROJECT_TASK_ID := l_project_task_id;
730:
731: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
732: CSF_DEBRIEF_PUB.Create_debrief_lines(
733: P_Api_Version_Number => 1.0,
734: P_Init_Msg_List => FND_API.G_FALSE,
735: P_Commit => FND_API.G_TRUE,
736: P_Upd_tskassgnstatus => NULL,

Line 823: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

819: l_dbf_line_id number;
820: l_user number;
821: l_data varchar2(2000);
822: l_msg_index_out number;
823: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
824: l_organization_id number;
825: l_UOM_code varchar2(100);
826: l_order_header_id number;
827: l_order_type_id number;

Line 1020: CSF_DEBRIEF_PUB.Update_debrief_line(

1016: P_DEBRIEF_LINE_Rec.EXPENDITURE_ORG_ID := l_expenditure_org_id;
1017: P_DEBRIEF_LINE_Rec.PROJECT_ID := l_project_id;
1018: P_DEBRIEF_LINE_Rec.PROJECT_TASK_ID := l_project_task_id;
1019:
1020: CSF_DEBRIEF_PUB.Update_debrief_line(
1021: P_Api_Version_Number => 1.0,
1022: P_Init_Msg_List => FND_API.G_FALSE,
1023: P_Commit => FND_API.G_FALSE,
1024: P_Upd_tskassgnstatus => NULL,

Line 1116: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

1112: l_dbf_line_id number;
1113: l_user number;
1114: l_data varchar2(2000);
1115: l_msg_index_out number;
1116: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1117: l_organization_id number;
1118: l_UOM_code varchar2(100);
1119: l_order_header_id number;
1120: l_order_type_id number;

Line 1394: CSF_DEBRIEF_PUB.Update_debrief_line(

1390: P_DEBRIEF_LINE_Rec.EXPENDITURE_ORG_ID := l_expenditure_org_id;
1391: P_DEBRIEF_LINE_Rec.PROJECT_ID := l_project_id;
1392: P_DEBRIEF_LINE_Rec.PROJECT_TASK_ID := l_project_task_id;
1393:
1394: CSF_DEBRIEF_PUB.Update_debrief_line(
1395: P_Api_Version_Number => 1.0,
1396: P_Init_Msg_List => FND_API.G_FALSE,
1397: P_Commit => FND_API.G_FALSE,
1398: P_Upd_tskassgnstatus => NULL,

Line 1524: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

1520: l_dbf_line_id number;
1521: l_user number;
1522: l_data varchar2(2000);
1523: l_msg_index_out number;
1524: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
1525: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1526: l_organization_id number;
1527: l_UOM_code varchar2(100);
1528: l_order_header_id number;

Line 1525: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

1521: l_user number;
1522: l_data varchar2(2000);
1523: l_msg_index_out number;
1524: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
1525: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1526: l_organization_id number;
1527: l_UOM_code varchar2(100);
1528: l_order_header_id number;
1529: l_order_type_id number;

Line 2267: CSF_DEBRIEF_PUB.Update_debrief_line(

2263:
2264: --dbms_output.put_line('Calling DEBRIEF PUB apis...');
2265: if (p_updateFlag = 1) then
2266:
2267: CSF_DEBRIEF_PUB.Update_debrief_line(
2268: P_Api_Version_Number => 1.0,
2269: P_Init_Msg_List => FND_API.G_FALSE,
2270: P_Commit => FND_API.G_TRUE,
2271: P_Upd_tskassgnstatus => NULL,

Line 2279: CSF_DEBRIEF_PUB.Create_debrief_lines(

2275: X_Msg_Count => l_msg_count ,
2276: X_Msg_Data => l_msg_data
2277: );
2278: else
2279: CSF_DEBRIEF_PUB.Create_debrief_lines(
2280: P_Api_Version_Number => 1.0,
2281: P_Init_Msg_List => FND_API.G_FALSE,
2282: P_Commit => FND_API.G_TRUE,
2283: P_Upd_tskassgnstatus => NULL,

Line 2347: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

2343: l_busProcessId number;
2344: l_user number;
2345: l_data varchar2(2000);
2346: l_msg_index_out number;
2347: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
2348: l_organization_id number;
2349:
2350: l_UOM_code varchar2(100);
2351: l_order_header_id number;

Line 2618: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

2614: l_interface_status varchar2(20);
2615: l_interface_status_meaning varchar2(20);
2616: l_data varchar2(1000);
2617: l_msg_data varchar2(1000);
2618: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
2619:
2620:
2621: Cursor c_internal_party_id Is
2622: select internal_party_id

Line 3260: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;

3256: , p_error_id OUT NOCOPY NUMBER
3257: , p_error OUT NOCOPY VARCHAR2
3258: )
3259: IS
3260: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
3261:
3262: l_return_status varchar2(2000);
3263: l_msg_count number;
3264: l_msg_data varchar2(2000);

Line 3307: CSF_DEBRIEF_PUB.Update_DEBRIEF(

3303: P_DEBRIEF_Rec.TRAVEL_END_TIME := p_end_date;
3304: P_DEBRIEF_Rec.TRAVEL_DISTANCE_IN_KM := p_distance;
3305: P_DEBRIEF_Rec.TASK_ASSIGNMENT_ID := p_task_assignment_id;
3306:
3307: CSF_DEBRIEF_PUB.Update_DEBRIEF(
3308: P_Api_Version_Number => 1.0,
3309: P_Init_Msg_List => FND_API.G_FALSE,
3310: P_Commit => FND_API.G_TRUE,
3311: P_DEBRIEF_Rec => P_DEBRIEF_Rec,

Line 3383: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;

3379: p_error_count OUT NOCOPY NUMBER,
3380: p_error OUT NOCOPY VARCHAR2
3381: )
3382: IS
3383: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
3384: l_error_msg VARCHAR2(2000);
3385: l_msg_index_out NUMBER;
3386: BEGIN
3387:

Line 3472: --DBMS_OUTPUT.PUT_LINE('Calling CSF_DEBRIEF_PUB.Update_debrief...');

3468: THEN
3469: P_DEBRIEF_Rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
3470: END IF;
3471:
3472: --DBMS_OUTPUT.PUT_LINE('Calling CSF_DEBRIEF_PUB.Update_debrief...');
3473: CSF_DEBRIEF_PUB.Update_debrief (
3474: P_Api_Version_Number => 1.0,
3475: P_Init_Msg_List => FND_API.G_FALSE,
3476: P_Commit => FND_API.G_FALSE,

Line 3473: CSF_DEBRIEF_PUB.Update_debrief (

3469: P_DEBRIEF_Rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
3470: END IF;
3471:
3472: --DBMS_OUTPUT.PUT_LINE('Calling CSF_DEBRIEF_PUB.Update_debrief...');
3473: CSF_DEBRIEF_PUB.Update_debrief (
3474: P_Api_Version_Number => 1.0,
3475: P_Init_Msg_List => FND_API.G_FALSE,
3476: P_Commit => FND_API.G_FALSE,
3477: P_DEBRIEF_Rec => P_DEBRIEF_Rec,

Line 3482: --DBMS_OUTPUT.PUT_LINE('Done CSF_DEBRIEF_PUB.');

3478: X_Return_Status => p_return_status,
3479: X_Msg_Count => p_error_count,
3480: X_Msg_Data => l_error_msg
3481: );
3482: --DBMS_OUTPUT.PUT_LINE('Done CSF_DEBRIEF_PUB.');
3483: --DBMS_OUTPUT.PUT_LINE('l_error_msg: '||l_error_msg);
3484: --DBMS_OUTPUT.PUT_LINE('p_return_status: '||p_return_status);
3485:
3486: IF p_return_status = FND_API.G_RET_STS_SUCCESS