DBA Data[Home] [Help]

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(

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(
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 123: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

119: l_dbf_line_id number;
120: l_user number;
121: l_data varchar2(2000);
122: l_msg_index_out number;
123: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
124: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
125: l_organization_id number;
126: l_UOM_code varchar2(100);
127: l_order_header_id number;

Line 124: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

120: l_user number;
121: l_data varchar2(2000);
122: l_msg_index_out number;
123: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
124: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
125: l_organization_id number;
126: l_UOM_code varchar2(100);
127: l_order_header_id number;
128: l_order_type_id number;

Line 284: CSF_DEBRIEF_PUB.Create_debrief_lines(

280: P_DEBRIEF_LINE_Rec.QUANTITY := p_quantity;
281: END IF;
282:
283: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
284: CSF_DEBRIEF_PUB.Create_debrief_lines(
285: P_Api_Version_Number => 1.0,
286: P_Init_Msg_List => FND_API.G_FALSE,
287: P_Commit => FND_API.G_TRUE,
288: P_Upd_tskassgnstatus => NULL,

Line 355: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

351: l_dbf_line_id number;
352: l_user number;
353: l_data varchar2(2000);
354: l_msg_index_out number;
355: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
356: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
357: l_organization_id number;
358: l_UOM_code varchar2(100);
359: l_order_header_id number;

Line 356: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

352: l_user number;
353: l_data varchar2(2000);
354: l_msg_index_out number;
355: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
356: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
357: l_organization_id number;
358: l_UOM_code varchar2(100);
359: l_order_header_id number;
360: l_order_type_id number;

Line 416: CSF_DEBRIEF_PUB.Create_debrief_lines(

412: P_DEBRIEF_LINE_Rec.TRANSACTION_TYPE_ID := p_txnTypeId;
413: P_DEBRIEF_LINE_Rec.EXPENSE_REASON_CODE := p_justificationCode;
414:
415: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
416: CSF_DEBRIEF_PUB.Create_debrief_lines(
417: P_Api_Version_Number => 1.0,
418: P_Init_Msg_List => FND_API.G_FALSE,
419: P_Commit => FND_API.G_TRUE,
420: P_Upd_tskassgnstatus => NULL,

Line 492: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

488: l_dbf_line_id number;
489: l_user number;
490: l_data varchar2(2000);
491: l_msg_index_out number;
492: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
493: l_organization_id number;
494: l_UOM_code varchar2(100);
495: l_order_header_id number;
496: l_order_type_id number;

Line 551: CSF_DEBRIEF_PUB.Update_debrief_line(

547: P_DEBRIEF_LINE_Rec.TRANSACTION_TYPE_ID := p_txnTypeId;
548: P_DEBRIEF_LINE_Rec.EXPENSE_REASON_CODE := p_justificationCode;
549:
550:
551: CSF_DEBRIEF_PUB.Update_debrief_line(
552: P_Api_Version_Number => 1.0,
553: P_Init_Msg_List => FND_API.G_FALSE,
554: P_Commit => FND_API.G_FALSE,
555: P_Upd_tskassgnstatus => NULL,

Line 627: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

623: l_dbf_line_id number;
624: l_user number;
625: l_data varchar2(2000);
626: l_msg_index_out number;
627: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
628: l_organization_id number;
629: l_UOM_code varchar2(100);
630: l_order_header_id number;
631: l_order_type_id number;

Line 765: CSF_DEBRIEF_PUB.Update_debrief_line(

761: IF p_quantity IS NOT NULL THEN
762: P_DEBRIEF_LINE_Rec.QUANTITY := p_quantity;
763: END IF;
764:
765: CSF_DEBRIEF_PUB.Update_debrief_line(
766: P_Api_Version_Number => 1.0,
767: P_Init_Msg_List => FND_API.G_FALSE,
768: P_Commit => FND_API.G_FALSE,
769: P_Upd_tskassgnstatus => NULL,

Line 867: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;

863: l_dbf_line_id number;
864: l_user number;
865: l_data varchar2(2000);
866: l_msg_index_out number;
867: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
868: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
869: l_organization_id number;
870: l_UOM_code varchar2(100);
871: l_order_header_id number;

Line 868: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

864: l_user number;
865: l_data varchar2(2000);
866: l_msg_index_out number;
867: P_DEBRIEF_TBL CSF_DEBRIEF_PUB.DEBRIEF_LINE_Tbl_Type ;
868: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
869: l_organization_id number;
870: l_UOM_code varchar2(100);
871: l_order_header_id number;
872: l_order_type_id number;

Line 1418: CSF_DEBRIEF_PUB.Update_debrief_line(

1414:
1415:
1416: if (p_updateFlag = 1) then
1417:
1418: CSF_DEBRIEF_PUB.Update_debrief_line(
1419: P_Api_Version_Number => 1.0,
1420: P_Init_Msg_List => FND_API.G_FALSE,
1421: P_Commit => FND_API.G_TRUE,
1422: P_Upd_tskassgnstatus => NULL,

Line 1430: CSF_DEBRIEF_PUB.Create_debrief_lines(

1426: X_Msg_Count => l_msg_count ,
1427: X_Msg_Data => l_msg_data
1428: );
1429: else
1430: CSF_DEBRIEF_PUB.Create_debrief_lines(
1431: P_Api_Version_Number => 1.0,
1432: P_Init_Msg_List => FND_API.G_FALSE,
1433: P_Commit => FND_API.G_TRUE,
1434: P_Upd_tskassgnstatus => NULL,

Line 1498: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

1494: l_busProcessId number;
1495: l_user number;
1496: l_data varchar2(2000);
1497: l_msg_index_out number;
1498: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1499: l_organization_id number;
1500:
1501: l_UOM_code varchar2(100);
1502: l_order_header_id number;

Line 1769: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;

1765: l_interface_status varchar2(20);
1766: l_interface_status_meaning varchar2(20);
1767: l_data varchar2(1000);
1768: l_msg_data varchar2(1000);
1769: P_DEBRIEF_LINE_Rec CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
1770:
1771:
1772: Cursor c_internal_party_id Is
1773: select internal_party_id

Line 2411: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;

2407: , p_error_id OUT NOCOPY NUMBER
2408: , p_error OUT NOCOPY VARCHAR2
2409: )
2410: IS
2411: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
2412:
2413: l_return_status varchar2(2000);
2414: l_msg_count number;
2415: l_msg_data varchar2(2000);

Line 2458: CSF_DEBRIEF_PUB.Update_DEBRIEF(

2454: P_DEBRIEF_Rec.TRAVEL_END_TIME := p_end_date;
2455: P_DEBRIEF_Rec.TRAVEL_DISTANCE_IN_KM := p_distance;
2456: P_DEBRIEF_Rec.TASK_ASSIGNMENT_ID := p_task_assignment_id;
2457:
2458: CSF_DEBRIEF_PUB.Update_DEBRIEF(
2459: P_Api_Version_Number => 1.0,
2460: P_Init_Msg_List => FND_API.G_FALSE,
2461: P_Commit => FND_API.G_TRUE,
2462: P_DEBRIEF_Rec => P_DEBRIEF_Rec,

Line 2534: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;

2530: p_error_count OUT NOCOPY NUMBER,
2531: p_error OUT NOCOPY VARCHAR2
2532: )
2533: IS
2534: P_DEBRIEF_Rec CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
2535: l_error_msg VARCHAR2(2000);
2536: l_msg_index_out NUMBER;
2537: BEGIN
2538:

Line 2623: CSF_DEBRIEF_PUB.Update_debrief (

2619: THEN
2620: P_DEBRIEF_Rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
2621: END IF;
2622:
2623: CSF_DEBRIEF_PUB.Update_debrief (
2624: P_Api_Version_Number => 1.0,
2625: P_Init_Msg_List => FND_API.G_FALSE,
2626: P_Commit => FND_API.G_FALSE,
2627: P_DEBRIEF_Rec => P_DEBRIEF_Rec,