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.CAC_SYNC_TASK dependencies on FND_API

Line 26: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record

22:
23:
24: TYPE task_rec IS RECORD (
25: syncId NUMBER -- The unique sync ID
26: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record
27: ,task_id NUMBER
28: -- number of record set starting at 0.
29: ,syncAnchor DATE -- sync anchor date
30: ,timeZoneId NUMBER := 0 -- Default time zone is GMT

Line 35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field

31: ,eventType VARCHAR2(30) --'New', 'Delete', 'Modify'
32:
33: -- Task common fields
34: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description

32:
33: -- Task common fields
34: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date

Line 37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char

33: -- Task common fields
34: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date

34: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date

Line 39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

35: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date

36: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status

Line 41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

37: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)

Line 42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date

38: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)

Line 43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

39: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date

Line 44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status

40: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)

Line 45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)

41: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name

Line 46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)

42: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num

Line 47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date

43: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num
51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

Line 48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)

44: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num
51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
52: ,task_assignment_id NUMBER

Line 49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name

45: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num
51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
52: ,task_assignment_id NUMBER
53: ,resultId NUMBER(1) -- Result Identifier:

Line 50: ,resourceId NUMBER := Fnd_Api.G_MISS_num

46: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num
51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
52: ,task_assignment_id NUMBER
53: ,resultId NUMBER(1) -- Result Identifier:
54: -- 0 Success, no message will be displayed

Line 51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

47: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
48: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
49: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
50: ,resourceId NUMBER := Fnd_Api.G_MISS_num
51: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
52: ,task_assignment_id NUMBER
53: ,resultId NUMBER(1) -- Result Identifier:
54: -- 0 Success, no message will be displayed
55: -- 1 Success, message will be displayed

Line 64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc

60: ,resultSystemMessage VARCHAR2(255) -- System message (API message code)
61: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
62:
63: -- fields added for recurring tasks
64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date

Line 65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week

61: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
62:
63: -- fields added for recurring tasks
64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number

62:
63: -- fields added for recurring tasks
64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date

63: -- fields added for recurring tasks
64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date

64: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

65: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

66: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

67: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

68: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month

Line 73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

69: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month

Line 74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

70: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.

Line 75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

71: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER

Line 76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month

72: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER
80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char

Line 77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month

73: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER
80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
81: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char);

Line 78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.

74: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
75: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER
80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
81: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char);
82:

Line 80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char

76: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER
80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
81: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char);
82:
83:
84:

Line 81: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char);

77: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
78: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
79: ,principal_id NUMBER
80: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
81: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char);
82:
83:
84:
85: TYPE exclusion_rec IS RECORD (

Line 87: ,exclusion_date DATE := Fnd_Api.G_MISS_date -- exclusion date

83:
84:
85: TYPE exclusion_rec IS RECORD (
86: syncId NUMBER -- The unique sync ID
87: ,exclusion_date DATE := Fnd_Api.G_MISS_date -- exclusion date
88: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record
89: ,task_id NUMBER
90: -- number of record set starting at 0.
91: ,syncAnchor DATE -- sync anchor date

Line 88: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record

84:
85: TYPE exclusion_rec IS RECORD (
86: syncId NUMBER -- The unique sync ID
87: ,exclusion_date DATE := Fnd_Api.G_MISS_date -- exclusion date
88: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record
89: ,task_id NUMBER
90: -- number of record set starting at 0.
91: ,syncAnchor DATE -- sync anchor date
92: ,timeZoneId NUMBER := 0 -- Default time zone is GMT

Line 95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field

91: ,syncAnchor DATE -- sync anchor date
92: ,timeZoneId NUMBER := 0 -- Default time zone is GMT
93: ,eventType VARCHAR2(30) --'New', 'Delete', 'Modify'
94: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description

92: ,timeZoneId NUMBER := 0 -- Default time zone is GMT
93: ,eventType VARCHAR2(30) --'New', 'Delete', 'Modify'
94: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date

Line 97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char

93: ,eventType VARCHAR2(30) --'New', 'Delete', 'Modify'
94: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date

94: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date

Line 99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

95: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

Line 100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date

96: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status

Line 101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

97: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)

Line 102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date

98: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)

Line 103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

99: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date

Line 104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status

100: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)

Line 105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)

101: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name

Line 106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)

102: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num

Line 107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date

103: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num
111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

Line 108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)

104: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num
111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
112: ,task_assignment_id NUMBER

Line 109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name

105: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num
111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
112: ,task_assignment_id NUMBER
113: ,resultId NUMBER(1) -- Result Identifier:

Line 110: ,resourceId NUMBER := Fnd_Api.G_MISS_num

106: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num
111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
112: ,task_assignment_id NUMBER
113: ,resultId NUMBER(1) -- Result Identifier:
114: -- 0 Success, no message will be displayed

Line 111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

107: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
108: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
109: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
110: ,resourceId NUMBER := Fnd_Api.G_MISS_num
111: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
112: ,task_assignment_id NUMBER
113: ,resultId NUMBER(1) -- Result Identifier:
114: -- 0 Success, no message will be displayed
115: -- 1 Success, message will be displayed

Line 124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc

120: ,resultSystemMessage VARCHAR2(255) -- System message (API message code)
121: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
122:
123: -- fields added for recurring tasks
124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week

121: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
122:
123: -- fields added for recurring tasks
124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date

122:
123: -- fields added for recurring tasks
124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date

123: -- fields added for recurring tasks
124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

124: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

125: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

126: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

Line 131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

127: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month

Line 132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

128: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month

Line 133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

129: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.

Line 134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

130: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER

Line 135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month

131: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER
139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char

Line 136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month

132: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER
139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
140: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char

Line 137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.

133: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
134: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER
139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
140: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char
141: );

Line 139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char

135: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER
139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
140: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char
141: );
142: -- The task_tbl is table of task_rec type
143: TYPE task_tbl IS TABLE OF task_rec

Line 140: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char

136: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
137: ,locations VARCHAR2(4000) := Fnd_Api.G_MISS_char -- locations list for the appt.
138: ,principal_id NUMBER
139: ,free_busy_type VARCHAR2(30) := Fnd_Api.G_MISS_char
140: ,dial_in VARCHAR2(100) :=Fnd_Api.G_MISS_char
141: );
142: -- The task_tbl is table of task_rec type
143: TYPE task_tbl IS TABLE OF task_rec
144: INDEX BY BINARY_INTEGER;

Line 151: ,attendee_role VARCHAR2(2000) := Fnd_Api.G_MISS_char

147: INDEX BY BINARY_INTEGER;
148:
149: TYPE attendee_rec IS RECORD (
150: task_id NUMBER
151: ,attendee_role VARCHAR2(2000) := Fnd_Api.G_MISS_char
152: ,attendee_status NUMBER := Fnd_Api.G_MISS_num
153: ,resourceId NUMBER := Fnd_Api.G_MISS_num
154: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
155: ,first_name VARCHAR2(150)

Line 152: ,attendee_status NUMBER := Fnd_Api.G_MISS_num

148:
149: TYPE attendee_rec IS RECORD (
150: task_id NUMBER
151: ,attendee_role VARCHAR2(2000) := Fnd_Api.G_MISS_char
152: ,attendee_status NUMBER := Fnd_Api.G_MISS_num
153: ,resourceId NUMBER := Fnd_Api.G_MISS_num
154: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
155: ,first_name VARCHAR2(150)
156: ,middle_name VARCHAR2(60)

Line 153: ,resourceId NUMBER := Fnd_Api.G_MISS_num

149: TYPE attendee_rec IS RECORD (
150: task_id NUMBER
151: ,attendee_role VARCHAR2(2000) := Fnd_Api.G_MISS_char
152: ,attendee_status NUMBER := Fnd_Api.G_MISS_num
153: ,resourceId NUMBER := Fnd_Api.G_MISS_num
154: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
155: ,first_name VARCHAR2(150)
156: ,middle_name VARCHAR2(60)
157: ,last_name VARCHAR2(150)

Line 154: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

150: task_id NUMBER
151: ,attendee_role VARCHAR2(2000) := Fnd_Api.G_MISS_char
152: ,attendee_status NUMBER := Fnd_Api.G_MISS_num
153: ,resourceId NUMBER := Fnd_Api.G_MISS_num
154: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
155: ,first_name VARCHAR2(150)
156: ,middle_name VARCHAR2(60)
157: ,last_name VARCHAR2(150)
158: ,primary_phone_country_code VARCHAR2(10)