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

Line 53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,

49: -- -------------------------------------------------------
50:
51: TYPE SALES_LEAD_Rec_Type IS RECORD
52: (
53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

50:
51: TYPE SALES_LEAD_Rec_Type IS RECORD
52: (
53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

51: TYPE SALES_LEAD_Rec_Type IS RECORD
52: (
53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 56: CREATION_DATE DATE := FND_API.G_MISS_DATE,

52: (
53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

53: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

54: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

55: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

56: CREATION_DATE DATE := FND_API.G_MISS_DATE,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

58: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

Line 63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

59: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

60: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

Line 65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,

61: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

62: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,

63: LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

64: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,

Line 69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,

65: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

66: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

67: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,

68: INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,

Line 73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,

69: ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

70: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,

71: CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,

72: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

73: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,

74: DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,

75: CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

76: LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

77: LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,

Line 93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

Line 95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,

Line 96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,

92: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,

93: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

94: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,

95: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,

Line 100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

96: ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,

Line 101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

97: ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

98: ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,

99: ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,

100: BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

101: ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

102: VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,

Line 107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

103: TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

Line 108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

Line 109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

105: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,

106: URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

107: IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

108: REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

109: DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

110: OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

111: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

112: INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

113: INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

114: PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

Line 119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

115: PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:

Line 120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

116: PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:
124: -- new columns added for bug 2098158

Line 121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

117: PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:
124: -- new columns added for bug 2098158
125: PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

Line 122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

118: QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:
124: -- new columns added for bug 2098158
125: PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
126: PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,

Line 125: PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,

121: AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:
124: -- new columns added for bug 2098158
125: PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
126: PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,
127:
128: -- new columns added for CAPRI lead referral
129:

Line 126: PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,

122: PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123:
124: -- new columns added for bug 2098158
125: PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
126: PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,
127:
128: -- new columns added for CAPRI lead referral
129:
130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,

Line 130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,

126: PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,
127:
128: -- new columns added for CAPRI lead referral
129:
130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

127:
128: -- new columns added for CAPRI lead referral
129:
130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

128: -- new columns added for CAPRI lead referral
129:
130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,

Line 133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,

129:
130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,

Line 134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

130: REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075

Line 135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,

131: REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,

Line 136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,

132: REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,
140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,

133: REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,
140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 139: LEAD_DATE DATE := FND_API.G_MISS_DATE,

135: REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,
140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142:
143:

Line 140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,

136: REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,
140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142:
143:
144: -- 11.5.9

Line 141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,

137: REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138: -- bug No.2341515, 2368075
139: LEAD_DATE DATE := FND_API.G_MISS_DATE,
140: SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,
141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142:
143:
144: -- 11.5.9
145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,

Line 145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,

141: COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142:
143:
144: -- 11.5.9
145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM

Line 146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,

142:
143:
144: -- 11.5.9
145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor

Line 147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,

143:
144: -- 11.5.9
145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor
151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM

Line 148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,

144: -- 11.5.9
145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor
151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM

Line 149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM

145: TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor
151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153: -- ER 3322617, extend length from 30 to 240 for the following two

Line 151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM

147: LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor
151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153: -- ER 3322617, extend length from 30 to 240 for the following two
154: -- columns
155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM

148: LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149: CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150: -- 11.5.10 new columns ckapoor
151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153: -- ER 3322617, extend length from 30 to 240 for the following two
154: -- columns
155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR

151: , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153: -- ER 3322617, extend length from 30 to 240 for the following two
154: -- columns
155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
157:
158: , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM
159: , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM

Line 156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR

152: , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153: -- ER 3322617, extend length from 30 to 240 for the following two
154: -- columns
155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
157:
158: , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM
159: , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM
160: );

Line 158: , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM

154: -- columns
155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
157:
158: , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM
159: , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: G_MISS_SALES_LEAD_REC SALES_LEAD_Rec_Type;

Line 159: , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM

155: , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
157:
158: , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM
159: , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: G_MISS_SALES_LEAD_REC SALES_LEAD_Rec_Type;
163:

Line 176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,

172: -- -------------------------------------------------------
173:
174: TYPE SALES_LEAD_LINE_Rec_Type IS RECORD
175: (
176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

173:
174: TYPE SALES_LEAD_LINE_Rec_Type IS RECORD
175: (
176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

174: TYPE SALES_LEAD_LINE_Rec_Type IS RECORD
175: (
176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 179: CREATION_DATE DATE := FND_API.G_MISS_DATE,

175: (
176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

176: SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

177: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

178: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,

Line 183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

179: CREATION_DATE DATE := FND_API.G_MISS_DATE,
180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

180: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188:

Line 185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

181: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188:
189: -- 11.5.10 Rivendell product category changes

Line 186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,

182: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188:
189: -- 11.5.10 Rivendell product category changes
190:

Line 187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

183: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188:
189: -- 11.5.10 Rivendell product category changes
190:
191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

Line 191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

187: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188:
189: -- 11.5.10 Rivendell product category changes
190:
191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194:
195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,

Line 192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,

188:
189: -- 11.5.10 Rivendell product category changes
190:
191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194:
195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,

Line 193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,

189: -- 11.5.10 Rivendell product category changes
190:
191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194:
195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197:

Line 195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,

191: --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194:
195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197:
198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,

192: --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193: --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194:
195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197:
198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

195: CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197:
198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,

Line 200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

196: CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197:
198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,

Line 201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

197:
198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 202: QUANTITY NUMBER := FND_API.G_MISS_NUM,

198:
199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,

199: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,

200: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

201: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

202: QUANTITY NUMBER := FND_API.G_MISS_NUM,
203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

203: BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

204: SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

205: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM

Line 218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM
222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM

Line 219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM
222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
223: );

Line 220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM
222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
223: );
224:

Line 221: OFFER_ID NUMBER := FND_API.G_MISS_NUM

217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM
222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
223: );
224:
225: G_MISS_SALES_LEAD_LINE_REC SALES_LEAD_LINE_Rec_Type;

Line 222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM

218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OFFER_ID NUMBER := FND_API.G_MISS_NUM
222: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
223: );
224:
225: G_MISS_SALES_LEAD_LINE_REC SALES_LEAD_LINE_Rec_Type;
226:

Line 251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

247: -- -------------------------------------------------------
248:
249: TYPE SALES_LEAD_CONTACT_Rec_Type IS RECORD
250: (
251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,

248:
249: TYPE SALES_LEAD_CONTACT_Rec_Type IS RECORD
250: (
251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

249: TYPE SALES_LEAD_CONTACT_Rec_Type IS RECORD
250: (
251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

250: (
251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

251: LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 256: CREATION_DATE DATE := FND_API.G_MISS_DATE,

252: SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

253: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

254: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

255: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

256: CREATION_DATE DATE := FND_API.G_MISS_DATE,
257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

257: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,

Line 262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

258: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

Line 263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

259: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,

Line 264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,

260: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,

261: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,

262: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,

263: ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

264: RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

265: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

266: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

267: PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

268: CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

269: PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

270: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

271: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

272: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

273: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

274: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

275: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

276: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

277: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

278: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

Line 283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

279: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM

Line 284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

280: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM
288: );

Line 285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

281: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM
288: );
289:

Line 286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

282: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM
288: );
289:
290: G_MISS_SALES_LEAD_CONTACT_REC SALES_LEAD_CONTACT_Rec_Type;

Line 287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM

283: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM
288: );
289:
290: G_MISS_SALES_LEAD_CONTACT_REC SALES_LEAD_CONTACT_Rec_Type;
291:

Line 345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

341: -- API Name: Create_sales_leads
342: --
343: PROCEDURE Create_sales_lead(
344: P_Api_Version_Number IN NUMBER,
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

342: --
343: PROCEDURE Create_sales_lead(
344: P_Api_Version_Number IN NUMBER,
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

343: PROCEDURE Create_sales_lead(
344: P_Api_Version_Number IN NUMBER,
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

344: P_Api_Version_Number IN NUMBER,
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
353: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,

Line 350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

346: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
353: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
354: P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type

Line 351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

347: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
353: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
354: P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type
355: DEFAULT G_MISS_SALES_LEAD_LINE_tbl,

Line 392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

388: * @rep:displayname Update Sales Lead
389: */
390: PROCEDURE Update_sales_lead(
391: P_Api_Version_Number IN NUMBER,
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

389: */
390: PROCEDURE Update_sales_lead(
391: P_Api_Version_Number IN NUMBER,
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

390: PROCEDURE Update_sales_lead(
391: P_Api_Version_Number IN NUMBER,
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

391: P_Api_Version_Number IN NUMBER,
392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
400: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type

Line 397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

393: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
400: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type
401: DEFAULT G_MISS_SALES_LEAD_REC,

Line 398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

394: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
400: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type
401: DEFAULT G_MISS_SALES_LEAD_REC,
402: X_Return_Status OUT NOCOPY VARCHAR2,

Line 413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

409: -- API Name: Delete_sales_leads
410: --
411: PROCEDURE Delete_sales_lead(
412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

410: --
411: PROCEDURE Delete_sales_lead(
412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

411: PROCEDURE Delete_sales_lead(
412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
421: P_SALES_LEAD_ID IN NUMBER,

Line 418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
421: P_SALES_LEAD_ID IN NUMBER,
422: X_Return_Status OUT NOCOPY VARCHAR2,

Line 419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

415: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
421: P_SALES_LEAD_ID IN NUMBER,
422: X_Return_Status OUT NOCOPY VARCHAR2,
423: X_Msg_Count OUT NOCOPY NUMBER,

Line 458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

454: * @rep:displayname Create Sales Lead Lines
455: */
456: PROCEDURE Create_sales_lead_lines(
457: P_Api_Version_Number IN NUMBER,
458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

455: */
456: PROCEDURE Create_sales_lead_lines(
457: P_Api_Version_Number IN NUMBER,
458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

456: PROCEDURE Create_sales_lead_lines(
457: P_Api_Version_Number IN NUMBER,
458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

457: P_Api_Version_Number IN NUMBER,
458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

458: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
466: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type

Line 463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

459: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
466: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type
467: := G_MISS_SALES_LEAD_LINE_Tbl,

Line 464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
466: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type
467: := G_MISS_SALES_LEAD_LINE_Tbl,
468: P_SALES_LEAD_ID IN NUMBER,

Line 503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

499: * @rep:displayname Update Sales Lead Lines
500: */
501: PROCEDURE Update_sales_lead_lines(
502: P_Api_Version_Number IN NUMBER,
503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

500: */
501: PROCEDURE Update_sales_lead_lines(
502: P_Api_Version_Number IN NUMBER,
503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

501: PROCEDURE Update_sales_lead_lines(
502: P_Api_Version_Number IN NUMBER,
503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

502: P_Api_Version_Number IN NUMBER,
503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
511: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,

Line 508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

504: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
511: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
512: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,

Line 509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
511: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
512: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
513: X_Return_Status OUT NOCOPY VARCHAR2,

Line 546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

542: * @rep:displayname Delete Sales Lead Lines
543: */
544: PROCEDURE Delete_sales_lead_lines(
545: P_Api_Version_Number IN NUMBER,
546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

543: */
544: PROCEDURE Delete_sales_lead_lines(
545: P_Api_Version_Number IN NUMBER,
546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

544: PROCEDURE Delete_sales_lead_lines(
545: P_Api_Version_Number IN NUMBER,
546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

545: P_Api_Version_Number IN NUMBER,
546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
554: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type,

Line 551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
554: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type,
555: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,

Line 552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
554: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type,
555: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
556: X_Return_Status OUT NOCOPY VARCHAR2,

Line 591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

587: * @rep:displayname Create Sales Lead Contacts
588: */
589: PROCEDURE Create_sales_lead_contacts(
590: P_Api_Version_Number IN NUMBER,
591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

588: */
589: PROCEDURE Create_sales_lead_contacts(
590: P_Api_Version_Number IN NUMBER,
591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

589: PROCEDURE Create_sales_lead_contacts(
590: P_Api_Version_Number IN NUMBER,
591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

590: P_Api_Version_Number IN NUMBER,
591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

591: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
599: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type

Line 596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

592: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
599: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type
600: := G_MISS_SALES_LEAD_CONTACT_Tbl,

Line 597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
599: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type
600: := G_MISS_SALES_LEAD_CONTACT_Tbl,
601: p_SALES_LEAD_ID IN NUMBER,

Line 635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

631: * @rep:displayname Update Sales Lead Contacts
632: */
633: PROCEDURE Update_sales_lead_contacts(
634: P_Api_Version_Number IN NUMBER,
635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

632: */
633: PROCEDURE Update_sales_lead_contacts(
634: P_Api_Version_Number IN NUMBER,
635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

633: PROCEDURE Update_sales_lead_contacts(
634: P_Api_Version_Number IN NUMBER,
635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

634: P_Api_Version_Number IN NUMBER,
635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

635: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
643: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,

Line 640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

636: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
643: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
644: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,

Line 641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

637: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
643: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
644: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
645: X_Return_Status OUT NOCOPY VARCHAR2,

Line 677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

673: * @rep:displayname Delete Sales Lead Contacts
674: */
675: PROCEDURE Delete_sales_lead_contacts(
676: P_Api_Version_Number IN NUMBER,
677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

674: */
675: PROCEDURE Delete_sales_lead_contacts(
676: P_Api_Version_Number IN NUMBER,
677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

675: PROCEDURE Delete_sales_lead_contacts(
676: P_Api_Version_Number IN NUMBER,
677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

676: P_Api_Version_Number IN NUMBER,
677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
685: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_type,

Line 682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

678: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
685: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_type,
686: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,

Line 683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
685: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_type,
686: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
687: X_Return_Status OUT NOCOPY VARCHAR2,

Line 701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

697: -- it's moved to package AS_LINK_LEAD_OPP_PUB.
698: /*
699: PROCEDURE Get_Potential_Opportunity(
700: P_Api_Version_Number IN NUMBER,
701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

698: /*
699: PROCEDURE Get_Potential_Opportunity(
700: P_Api_Version_Number IN NUMBER,
701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

699: PROCEDURE Get_Potential_Opportunity(
700: P_Api_Version_Number IN NUMBER,
701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

700: P_Api_Version_Number IN NUMBER,
701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

701: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
709: P_SALES_LEAD_rec IN SALES_LEAD_rec_type,

Line 706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

702: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
709: P_SALES_LEAD_rec IN SALES_LEAD_rec_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,

Line 707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
709: P_SALES_LEAD_rec IN SALES_LEAD_rec_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,
711: X_Msg_Count OUT NOCOPY NUMBER,

Line 724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

720: /* API renamed by Francis on 06/26/2001 from Link_Lead_To_Opportunity to Copy_Lead_To_Opportunity */
721:
722: PROCEDURE Copy_Lead_To_Opportunity(
723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

721:
722: PROCEDURE Copy_Lead_To_Opportunity(
723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

722: PROCEDURE Copy_Lead_To_Opportunity(
723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

723: P_Api_Version_Number IN NUMBER,
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

725: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
733: P_SALES_LEAD_ID IN NUMBER,

Line 730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
733: P_SALES_LEAD_ID IN NUMBER,
734: P_SALES_LEAD_LINE_TBL IN SALES_LEAD_LINE_TBL_TYPE

Line 731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

727: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
733: P_SALES_LEAD_ID IN NUMBER,
734: P_SALES_LEAD_LINE_TBL IN SALES_LEAD_LINE_TBL_TYPE
735: := G_MISS_SALES_LEAD_LINE_TBL,

Line 749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

745: /* API added by Francis on 06/26/2001 */
746:
747: PROCEDURE Link_Lead_To_Opportunity(
748: P_Api_Version_Number IN NUMBER,
749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

746:
747: PROCEDURE Link_Lead_To_Opportunity(
748: P_Api_Version_Number IN NUMBER,
749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

747: PROCEDURE Link_Lead_To_Opportunity(
748: P_Api_Version_Number IN NUMBER,
749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

748: P_Api_Version_Number IN NUMBER,
749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

749: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

750: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
758: P_SALES_LEAD_ID IN NUMBER,

Line 755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

751: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
758: P_SALES_LEAD_ID IN NUMBER,
759: P_OPPORTUNITY_ID IN NUMBER,

Line 756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

752: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
758: P_SALES_LEAD_ID IN NUMBER,
759: P_OPPORTUNITY_ID IN NUMBER,
760: X_Return_Status OUT NOCOPY VARCHAR2,

Line 771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

767: -- API Name: Create_Opportunity_For_Lead
768: --
769: PROCEDURE Create_Opportunity_For_Lead(
770: P_Api_Version_Number IN NUMBER,
771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

768: --
769: PROCEDURE Create_Opportunity_For_Lead(
770: P_Api_Version_Number IN NUMBER,
771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

769: PROCEDURE Create_Opportunity_For_Lead(
770: P_Api_Version_Number IN NUMBER,
771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

770: P_Api_Version_Number IN NUMBER,
771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

772: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

773: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781: P_SALES_LEAD_ID IN NUMBER,

Line 778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

774: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781: P_SALES_LEAD_ID IN NUMBER,
782: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 782: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781: P_SALES_LEAD_ID IN NUMBER,
782: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: X_Return_Status OUT NOCOPY VARCHAR2,
784: X_Msg_Count OUT NOCOPY NUMBER,
785: X_Msg_Data OUT NOCOPY VARCHAR2,
786: X_OPPORTUNITY_ID OUT NOCOPY NUMBER

Line 791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

787: );
788:
789: PROCEDURE Assign_Sales_Lead(
790: P_Api_Version_Number IN NUMBER,
791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

788:
789: PROCEDURE Assign_Sales_Lead(
790: P_Api_Version_Number IN NUMBER,
791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

789: PROCEDURE Assign_Sales_Lead(
790: P_Api_Version_Number IN NUMBER,
791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

790: P_Api_Version_Number IN NUMBER,
791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

791: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
799: P_Sales_Lead_Id IN NUMBER,

Line 796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

792: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
799: P_Sales_Lead_Id IN NUMBER,
800: X_Return_Status OUT NOCOPY VARCHAR2,

Line 797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
799: P_Sales_Lead_Id IN NUMBER,
800: X_Return_Status OUT NOCOPY VARCHAR2,
801: X_Msg_Count OUT NOCOPY NUMBER,

Line 829: -- the profile value is NULL or FND_API.G_MISS_CHAR,

825: -- This function gets profile values from the profile table type
826: -- and return the value for the input profile name.
827: --
828: -- If the profile name is not found in the profile table or
829: -- the profile value is NULL or FND_API.G_MISS_CHAR,
830: -- the function will return NULL
831: --
832: FUNCTION Get_Profile(
833: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

Line 839: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

835: RETURN VARCHAR2;
836:
837: PROCEDURE CALL_WF_TO_ASSIGN (
838: P_Api_Version_Number IN NUMBER,
839: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
840: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
841: P_Sales_Lead_Id IN NUMBER,
842: P_assigned_resource_id IN NUMBER DEFAULT NULL,
843: X_Return_Status OUT NOCOPY VARCHAR2,

Line 840: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

836:
837: PROCEDURE CALL_WF_TO_ASSIGN (
838: P_Api_Version_Number IN NUMBER,
839: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
840: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
841: P_Sales_Lead_Id IN NUMBER,
842: P_assigned_resource_id IN NUMBER DEFAULT NULL,
843: X_Return_Status OUT NOCOPY VARCHAR2,
844: X_Msg_Count OUT NOCOPY NUMBER,

Line 853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

849: -- API Name: Build_Lead_Sales_Team
850: --
851: PROCEDURE Build_Lead_Sales_Team (
852: P_Api_Version_Number IN NUMBER,
853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

850: --
851: PROCEDURE Build_Lead_Sales_Team (
852: P_Api_Version_Number IN NUMBER,
853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

851: PROCEDURE Build_Lead_Sales_Team (
852: P_Api_Version_Number IN NUMBER,
853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
859: P_Sales_Lead_Id IN NUMBER,

Line 856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

852: P_Api_Version_Number IN NUMBER,
853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
859: P_Sales_Lead_Id IN NUMBER,
860: X_Return_Status OUT NOCOPY VARCHAR2,

Line 857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

853: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
859: P_Sales_Lead_Id IN NUMBER,
860: X_Return_Status OUT NOCOPY VARCHAR2,
861: X_Msg_Count OUT NOCOPY NUMBER,

Line 858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

854: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
859: P_Sales_Lead_Id IN NUMBER,
860: X_Return_Status OUT NOCOPY VARCHAR2,
861: X_Msg_Count OUT NOCOPY NUMBER,
862: X_Msg_Data OUT NOCOPY VARCHAR2

Line 870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

866: -- API Name: Rebuild_Lead_Sales_Team
867: --
868: PROCEDURE Rebuild_Lead_Sales_Team (
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

867: --
868: PROCEDURE Rebuild_Lead_Sales_Team (
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

868: PROCEDURE Rebuild_Lead_Sales_Team (
869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
876: P_Sales_Lead_Id IN NUMBER,

Line 873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

869: P_Api_Version_Number IN NUMBER,
870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
876: P_Sales_Lead_Id IN NUMBER,
877: X_Return_Status OUT NOCOPY VARCHAR2,

Line 874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

870: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
876: P_Sales_Lead_Id IN NUMBER,
877: X_Return_Status OUT NOCOPY VARCHAR2,
878: X_Msg_Count OUT NOCOPY NUMBER,

Line 875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

871: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875: P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
876: P_Sales_Lead_Id IN NUMBER,
877: X_Return_Status OUT NOCOPY VARCHAR2,
878: X_Msg_Count OUT NOCOPY NUMBER,
879: X_Msg_Data OUT NOCOPY VARCHAR2

Line 888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

884: -- API Name: Run_Lead_Engines
885: --
886: PROCEDURE Run_Lead_Engines (
887: P_Api_Version_Number IN NUMBER,
888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

885: --
886: PROCEDURE Run_Lead_Engines (
887: P_Api_Version_Number IN NUMBER,
888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

886: PROCEDURE Run_Lead_Engines (
887: P_Api_Version_Number IN NUMBER,
888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
894: P_Sales_Lead_Id IN NUMBER,

Line 891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

887: P_Api_Version_Number IN NUMBER,
888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
894: P_Sales_Lead_Id IN NUMBER,
895: X_Sales_Team_Flag OUT NOCOPY VARCHAR2,

Line 892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

888: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
894: P_Sales_Lead_Id IN NUMBER,
895: X_Sales_Team_Flag OUT NOCOPY VARCHAR2,
896: X_Return_Status OUT NOCOPY VARCHAR2,

Line 893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

889: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
894: P_Sales_Lead_Id IN NUMBER,
895: X_Sales_Team_Flag OUT NOCOPY VARCHAR2,
896: X_Return_Status OUT NOCOPY VARCHAR2,
897: X_Msg_Count OUT NOCOPY NUMBER,

Line 927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

923: * @rep:displayname Run Lead Rules Engine
924: */
925: PROCEDURE Run_Lead_Engines (
926: P_Api_Version_Number IN NUMBER,
927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

924: */
925: PROCEDURE Run_Lead_Engines (
926: P_Api_Version_Number IN NUMBER,
927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

925: PROCEDURE Run_Lead_Engines (
926: P_Api_Version_Number IN NUMBER,
927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
933: P_Sales_Lead_Id IN NUMBER,

Line 930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

926: P_Api_Version_Number IN NUMBER,
927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
933: P_Sales_Lead_Id IN NUMBER,
934: X_Lead_Engines_Out_Rec OUT NOCOPY LEAD_ENGINES_OUT_Rec_Type,

Line 931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

927: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
933: P_Sales_Lead_Id IN NUMBER,
934: X_Lead_Engines_Out_Rec OUT NOCOPY LEAD_ENGINES_OUT_Rec_Type,
935: X_Return_Status OUT NOCOPY VARCHAR2,

Line 932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
933: P_Sales_Lead_Id IN NUMBER,
934: X_Lead_Engines_Out_Rec OUT NOCOPY LEAD_ENGINES_OUT_Rec_Type,
935: X_Return_Status OUT NOCOPY VARCHAR2,
936: X_Msg_Count OUT NOCOPY NUMBER,

Line 945: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

941: -- API Name: Start_Partner_Matching
942: --
943: PROCEDURE Start_Partner_Matching(
944: P_Api_Version_Number IN NUMBER,
945: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
946: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
947: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
948: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
949: P_Identity_Salesforce_Id IN NUMBER,

Line 946: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

942: --
943: PROCEDURE Start_Partner_Matching(
944: P_Api_Version_Number IN NUMBER,
945: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
946: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
947: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
948: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
949: P_Identity_Salesforce_Id IN NUMBER,
950: P_Salesgroup_Id IN NUMBER,

Line 947: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

943: PROCEDURE Start_Partner_Matching(
944: P_Api_Version_Number IN NUMBER,
945: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
946: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
947: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
948: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
949: P_Identity_Salesforce_Id IN NUMBER,
950: P_Salesgroup_Id IN NUMBER,
951: P_Lead_id IN NUMBER,

Line 948: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

944: P_Api_Version_Number IN NUMBER,
945: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
946: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
947: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
948: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
949: P_Identity_Salesforce_Id IN NUMBER,
950: P_Salesgroup_Id IN NUMBER,
951: P_Lead_id IN NUMBER,
952: X_Return_Status OUT NOCOPY VARCHAR2,

Line 962: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

958: -- API Name: Route_Lead_To_Marketing
959: --
960: PROCEDURE Route_Lead_To_Marketing(
961: P_Api_Version_Number IN NUMBER,
962: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
964: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
965: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
966: P_Identity_Salesforce_Id IN NUMBER,

Line 963: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

959: --
960: PROCEDURE Route_Lead_To_Marketing(
961: P_Api_Version_Number IN NUMBER,
962: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
964: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
965: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
966: P_Identity_Salesforce_Id IN NUMBER,
967: P_Sales_Lead_id IN NUMBER,

Line 964: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

960: PROCEDURE Route_Lead_To_Marketing(
961: P_Api_Version_Number IN NUMBER,
962: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
964: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
965: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
966: P_Identity_Salesforce_Id IN NUMBER,
967: P_Sales_Lead_id IN NUMBER,
968: X_Return_Status OUT NOCOPY VARCHAR2,

Line 965: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

961: P_Api_Version_Number IN NUMBER,
962: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
964: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
965: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
966: P_Identity_Salesforce_Id IN NUMBER,
967: P_Sales_Lead_id IN NUMBER,
968: X_Return_Status OUT NOCOPY VARCHAR2,
969: X_Msg_Count OUT NOCOPY NUMBER,

Line 975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

971: );
972:
973: PROCEDURE Lead_Process_After_Create (
974: P_Api_Version_Number IN NUMBER,
975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

972:
973: PROCEDURE Lead_Process_After_Create (
974: P_Api_Version_Number IN NUMBER,
975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

973: PROCEDURE Lead_Process_After_Create (
974: P_Api_Version_Number IN NUMBER,
975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

974: P_Api_Version_Number IN NUMBER,
975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

975: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
983: P_Sales_Lead_Id IN NUMBER,

Line 980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

976: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
983: P_Sales_Lead_Id IN NUMBER,
984: X_Return_Status OUT NOCOPY VARCHAR2,

Line 981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

977: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
983: P_Sales_Lead_Id IN NUMBER,
984: X_Return_Status OUT NOCOPY VARCHAR2,
985: X_Msg_Count OUT NOCOPY NUMBER,

Line 982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

978: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
983: P_Sales_Lead_Id IN NUMBER,
984: X_Return_Status OUT NOCOPY VARCHAR2,
985: X_Msg_Count OUT NOCOPY NUMBER,
986: X_Msg_Data OUT NOCOPY VARCHAR2

Line 991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

987: );
988:
989: PROCEDURE Lead_Process_After_Update (
990: P_Api_Version_Number IN NUMBER,
991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

988:
989: PROCEDURE Lead_Process_After_Update (
990: P_Api_Version_Number IN NUMBER,
991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

989: PROCEDURE Lead_Process_After_Update (
990: P_Api_Version_Number IN NUMBER,
991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

990: P_Api_Version_Number IN NUMBER,
991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

Line 995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
999: P_Sales_Lead_Id IN NUMBER,

Line 996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

992: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
999: P_Sales_Lead_Id IN NUMBER,
1000: X_Return_Status OUT NOCOPY VARCHAR2,

Line 997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

993: p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
999: P_Sales_Lead_Id IN NUMBER,
1000: X_Return_Status OUT NOCOPY VARCHAR2,
1001: X_Msg_Count OUT NOCOPY NUMBER,

Line 998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,

994: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998: P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
999: P_Sales_Lead_Id IN NUMBER,
1000: X_Return_Status OUT NOCOPY VARCHAR2,
1001: X_Msg_Count OUT NOCOPY NUMBER,
1002: X_Msg_Data OUT NOCOPY VARCHAR2