DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB_W dependencies on JTF_DATE_TABLE

Line 31: , a7 JTF_DATE_TABLE

27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_VARCHAR2_TABLE_100
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_DATE_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE

Line 32: , a8 JTF_DATE_TABLE

28: , a4 JTF_VARCHAR2_TABLE_100
29: , a5 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_DATE_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE

Line 41: , a7 out nocopy JTF_DATE_TABLE

37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE

Line 42: , a8 out nocopy JTF_DATE_TABLE

38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE
46: , a1 JTF_VARCHAR2_TABLE_200

Line 84: , a6 JTF_DATE_TABLE

80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_200
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_DATE_TABLE
85: , a7 JTF_VARCHAR2_TABLE_1000
86: , a8 JTF_VARCHAR2_TABLE_100
87: );
88: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 94: , a6 out nocopy JTF_DATE_TABLE

90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_200
92: , a4 out nocopy JTF_VARCHAR2_TABLE_200
93: , a5 out nocopy JTF_NUMBER_TABLE
94: , a6 out nocopy JTF_DATE_TABLE
95: , a7 out nocopy JTF_VARCHAR2_TABLE_1000
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98:

Line 551: , p15_a7 JTF_DATE_TABLE

547: , p15_a3 JTF_VARCHAR2_TABLE_100
548: , p15_a4 JTF_VARCHAR2_TABLE_100
549: , p15_a5 JTF_VARCHAR2_TABLE_100
550: , p15_a6 JTF_VARCHAR2_TABLE_100
551: , p15_a7 JTF_DATE_TABLE
552: , p15_a8 JTF_DATE_TABLE
553: , p_auto_assign VARCHAR2
554: , p_auto_generate_tasks VARCHAR2
555: , p18_a0 out nocopy NUMBER

Line 552: , p15_a8 JTF_DATE_TABLE

548: , p15_a4 JTF_VARCHAR2_TABLE_100
549: , p15_a5 JTF_VARCHAR2_TABLE_100
550: , p15_a6 JTF_VARCHAR2_TABLE_100
551: , p15_a7 JTF_DATE_TABLE
552: , p15_a8 JTF_DATE_TABLE
553: , p_auto_assign VARCHAR2
554: , p_auto_generate_tasks VARCHAR2
555: , p18_a0 out nocopy NUMBER
556: , p18_a1 out nocopy VARCHAR2

Line 810: , p15_a7 JTF_DATE_TABLE

806: , p15_a3 JTF_VARCHAR2_TABLE_100
807: , p15_a4 JTF_VARCHAR2_TABLE_100
808: , p15_a5 JTF_VARCHAR2_TABLE_100
809: , p15_a6 JTF_VARCHAR2_TABLE_100
810: , p15_a7 JTF_DATE_TABLE
811: , p15_a8 JTF_DATE_TABLE
812: , p_auto_assign VARCHAR2
813: , p_default_contract_sla_ind VARCHAR2
814: , x_request_id out nocopy NUMBER

Line 811: , p15_a8 JTF_DATE_TABLE

807: , p15_a4 JTF_VARCHAR2_TABLE_100
808: , p15_a5 JTF_VARCHAR2_TABLE_100
809: , p15_a6 JTF_VARCHAR2_TABLE_100
810: , p15_a7 JTF_DATE_TABLE
811: , p15_a8 JTF_DATE_TABLE
812: , p_auto_assign VARCHAR2
813: , p_default_contract_sla_ind VARCHAR2
814: , x_request_id out nocopy NUMBER
815: , x_request_number out nocopy VARCHAR2

Line 1061: , p17_a7 JTF_DATE_TABLE

1057: , p17_a3 JTF_VARCHAR2_TABLE_100
1058: , p17_a4 JTF_VARCHAR2_TABLE_100
1059: , p17_a5 JTF_VARCHAR2_TABLE_100
1060: , p17_a6 JTF_VARCHAR2_TABLE_100
1061: , p17_a7 JTF_DATE_TABLE
1062: , p17_a8 JTF_DATE_TABLE
1063: , p_called_by_workflow VARCHAR2
1064: , p_workflow_process_id NUMBER
1065: , p_auto_assign VARCHAR2

Line 1062: , p17_a8 JTF_DATE_TABLE

1058: , p17_a4 JTF_VARCHAR2_TABLE_100
1059: , p17_a5 JTF_VARCHAR2_TABLE_100
1060: , p17_a6 JTF_VARCHAR2_TABLE_100
1061: , p17_a7 JTF_DATE_TABLE
1062: , p17_a8 JTF_DATE_TABLE
1063: , p_called_by_workflow VARCHAR2
1064: , p_workflow_process_id NUMBER
1065: , p_auto_assign VARCHAR2
1066: , p_validate_sr_closure VARCHAR2

Line 1318: , p17_a7 JTF_DATE_TABLE

1314: , p17_a3 JTF_VARCHAR2_TABLE_100
1315: , p17_a4 JTF_VARCHAR2_TABLE_100
1316: , p17_a5 JTF_VARCHAR2_TABLE_100
1317: , p17_a6 JTF_VARCHAR2_TABLE_100
1318: , p17_a7 JTF_DATE_TABLE
1319: , p17_a8 JTF_DATE_TABLE
1320: , p_called_by_workflow VARCHAR2
1321: , p_workflow_process_id NUMBER
1322: , p_default_contract_sla_ind VARCHAR2

Line 1319: , p17_a8 JTF_DATE_TABLE

1315: , p17_a4 JTF_VARCHAR2_TABLE_100
1316: , p17_a5 JTF_VARCHAR2_TABLE_100
1317: , p17_a6 JTF_VARCHAR2_TABLE_100
1318: , p17_a7 JTF_DATE_TABLE
1319: , p17_a8 JTF_DATE_TABLE
1320: , p_called_by_workflow VARCHAR2
1321: , p_workflow_process_id NUMBER
1322: , p_default_contract_sla_ind VARCHAR2
1323: , x_workflow_process_id out nocopy NUMBER

Line 1588: , p15_a7 JTF_DATE_TABLE

1584: , p15_a3 JTF_VARCHAR2_TABLE_100
1585: , p15_a4 JTF_VARCHAR2_TABLE_100
1586: , p15_a5 JTF_VARCHAR2_TABLE_100
1587: , p15_a6 JTF_VARCHAR2_TABLE_100
1588: , p15_a7 JTF_DATE_TABLE
1589: , p15_a8 JTF_DATE_TABLE
1590: , p_default_contract_sla_ind VARCHAR2
1591: , x_request_id out nocopy NUMBER
1592: , x_request_number out nocopy VARCHAR2

Line 1589: , p15_a8 JTF_DATE_TABLE

1585: , p15_a4 JTF_VARCHAR2_TABLE_100
1586: , p15_a5 JTF_VARCHAR2_TABLE_100
1587: , p15_a6 JTF_VARCHAR2_TABLE_100
1588: , p15_a7 JTF_DATE_TABLE
1589: , p15_a8 JTF_DATE_TABLE
1590: , p_default_contract_sla_ind VARCHAR2
1591: , x_request_id out nocopy NUMBER
1592: , x_request_number out nocopy VARCHAR2
1593: , x_interaction_id out nocopy NUMBER

Line 1621: , p5_a6 JTF_DATE_TABLE

1617: , p5_a2 JTF_VARCHAR2_TABLE_200
1618: , p5_a3 JTF_VARCHAR2_TABLE_200
1619: , p5_a4 JTF_VARCHAR2_TABLE_200
1620: , p5_a5 JTF_NUMBER_TABLE
1621: , p5_a6 JTF_DATE_TABLE
1622: , p5_a7 JTF_VARCHAR2_TABLE_1000
1623: , p5_a8 JTF_VARCHAR2_TABLE_100
1624: , p_modified_by NUMBER
1625: , p_modified_on date