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

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

30:
31:
32: TYPE task_rec IS RECORD (
33: syncId NUMBER -- The unique sync ID
34: ,recordIndex NUMBER := Fnd_Api.G_MISS_num -- Index equal to the relative record
35: ,task_id NUMBER
36: -- number of record set starting at 0.
37: ,syncAnchor DATE -- sync anchor date
38: ,timeZoneId NUMBER := 0 -- Default time zone is GMT

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

39: ,eventType VARCHAR2(30) --'New', 'Delete', 'Modify'
40:
41: -- Task common fields
42: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
43: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

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

40:
41: -- Task common fields
42: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
43: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date

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

41: -- Task common fields
42: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
43: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

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

42: ,objectCode VARCHAR2(30) -- Type: 'TASK' or 'APPOINTMENT'
43: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date

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

43: ,subject VARCHAR2(2000) := Fnd_Api.G_MISS_char -- Subject/name field
44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date

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

44: ,description VARCHAR2(4000) := Fnd_Api.G_MISS_char -- Description
45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status

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

45: ,dateSelected VARCHAR2(1) := Fnd_Api.G_MISS_char
46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)

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

46: ,plannedStartDate DATE := Fnd_Api.G_MISS_date -- Start date
47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)

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

47: ,plannedEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date

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

48: ,scheduledStartDate DATE := Fnd_Api.G_MISS_date -- Start date
49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)

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

49: ,scheduledEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name

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

50: ,actualStartDate DATE := Fnd_Api.G_MISS_date -- Start date
51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num

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

51: ,actualEndDate DATE := Fnd_Api.G_MISS_date -- End/Completed date
52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num
59: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char

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

52: ,statusId NUMBER := Fnd_Api.G_MISS_num -- Task status
53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num
59: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
60: ,task_assignment_id NUMBER

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

53: ,priorityId NUMBER := Fnd_Api.G_MISS_num -- Task priority (0-99)
54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num
59: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
60: ,task_assignment_id NUMBER
61: ,resultId NUMBER(1) -- Result Identifier:

Line 58: ,resourceId NUMBER := Fnd_Api.G_MISS_num

54: ,alarmFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Task alarm flag (Y/N)
55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num
59: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
60: ,task_assignment_id NUMBER
61: ,resultId NUMBER(1) -- Result Identifier:
62: -- 0 Success, no message will be displayed

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

55: ,alarmDate DATE := Fnd_Api.G_MISS_date -- Alarm trigger date
56: ,privateFlag VARCHAR2(1) := Fnd_Api.G_MISS_char -- Private flag (Y/N)
57: ,category VARCHAR2(255) := Fnd_Api.G_MISS_char -- Task category name
58: ,resourceId NUMBER := Fnd_Api.G_MISS_num
59: ,resourceType VARCHAR2(2000) := Fnd_Api.G_MISS_char
60: ,task_assignment_id NUMBER
61: ,resultId NUMBER(1) -- Result Identifier:
62: -- 0 Success, no message will be displayed
63: -- 1 Success, message will be displayed

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

68: ,resultSystemMessage VARCHAR2(255) -- System message (API message code)
69: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
70:
71: -- fields added for recurring tasks
72: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date

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

69: ,resultUserMessage VARCHAR2(2000) -- Valid and Meaningful message to the usr
70:
71: -- fields added for recurring tasks
72: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

70:
71: -- fields added for recurring tasks
72: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

71: -- fields added for recurring tasks
72: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

72: ,unit_of_measure VARCHAR2(30) := Fnd_Api.G_MISS_char -- unit of measure MON , DAY , WEEK etc
73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

73: ,occurs_every NUMBER := Fnd_Api.G_MISS_num --occurs every month/day/week
74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

74: --,occurs_number NUMBER := Fnd_Api.G_MISS_num --occurs number
75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

75: ,start_date DATE := Fnd_Api.G_MISS_date -- start date
76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)

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

76: ,end_date DATE := Fnd_Api.G_MISS_date -- end date
77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month

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

77: ,sunday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month

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

78: ,monday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
86: );

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

79: ,tuesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
86: );
87: TYPE exclusion_rec IS RECORD (

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

80: ,wednesday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
86: );
87: TYPE exclusion_rec IS RECORD (
88: syncId NUMBER -- The unique sync ID

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

81: ,thursday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
82: ,friday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
83: ,saturday VARCHAR2(1) := Fnd_Api.G_MISS_char -- flag (Y/N)
84: ,date_of_month NUMBER := Fnd_Api.G_MISS_num --date of month
85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
86: );
87: TYPE exclusion_rec IS RECORD (
88: syncId NUMBER -- The unique sync ID
89: ,exclusion_date DATE := Fnd_Api.G_MISS_date -- exclusion date

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

85: ,occurs_which NUMBER := Fnd_Api.G_MISS_num --date of month
86: );
87: TYPE exclusion_rec IS RECORD (
88: syncId NUMBER -- The unique sync ID
89: ,exclusion_date DATE := Fnd_Api.G_MISS_date -- exclusion date
90: );
91: -- The task_tbl is table of task_rec type
92: TYPE task_tbl IS TABLE OF task_rec
93: INDEX BY BINARY_INTEGER;