APPS.AS_OSI_LEAD_PUB dependencies on FND_API

Line 47: ( last_update_date Date := FND_API.G_MISS_DATE,

43: -- CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN get standard stuff
44: -- End of Comments
45:
46: TYPE osi_rec_type IS RECORD
47: ( last_update_date Date := FND_API.G_MISS_DATE,
48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,

Line 48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,

44: -- End of Comments
45:
46: TYPE osi_rec_type IS RECORD
47: ( last_update_date Date := FND_API.G_MISS_DATE,
48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,

Line 49: creation_Date Date := FND_API.G_MISS_DATE,

45:
46: TYPE osi_rec_type IS RECORD
47: ( last_update_date Date := FND_API.G_MISS_DATE,
48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,

Line 50: created_by varchar2(30) := FND_API.G_MISS_CHAR,

46: TYPE osi_rec_type IS RECORD
47: ( last_update_date Date := FND_API.G_MISS_DATE,
48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,

47: ( last_update_date Date := FND_API.G_MISS_DATE,
48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: lead_id NUMBER := FND_API.G_MISS_NUM,

48: last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,

49: creation_Date Date := FND_API.G_MISS_DATE,
50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,

50: created_by varchar2(30) := FND_API.G_MISS_CHAR,
51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,

52: lead_id NUMBER := FND_API.G_MISS_NUM,
53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

53: osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

54: CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,

55: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

56: PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

57: CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

58: CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

59: PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

60: SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

61: CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

62: BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

63: LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,

64: HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

65: CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

66: SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

67: INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,

68: CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,

69: FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

70: FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

71: CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,

72: LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

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

73: SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,

74: MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,

75: PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

76: SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

77: TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

78: NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,

79: CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

80: SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,

81: LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
89: );

Line 86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

82: BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
89: );
90:

Line 87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

83: CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
89: );
90:
91: G_MISS_OSI_REC osi_rec_type;

Line 88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

84: CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87: SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88: OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
89: );
90:
91: G_MISS_OSI_REC osi_rec_type;
92:

Line 106: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,

102:
103: G_MISS_OSI_TBL osi_tbl_type;
104:
105: TYPE osi_cvb_rec_type IS RECORD
106: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: VEHICLE VARCHAR2(100) := FND_API.G_MISS_CHAR
108: );
109:
110: G_MISS_OSI_CVB_REC osi_cvb_rec_type;

Line 107: VEHICLE VARCHAR2(100) := FND_API.G_MISS_CHAR

103: G_MISS_OSI_TBL osi_tbl_type;
104:
105: TYPE osi_cvb_rec_type IS RECORD
106: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: VEHICLE VARCHAR2(100) := FND_API.G_MISS_CHAR
108: );
109:
110: G_MISS_OSI_CVB_REC osi_cvb_rec_type;
111:

Line 118: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,

114:
115: G_MISS_OSI_CVB_TBL osi_cvb_tbl_type;
116:
117: TYPE osi_cnb_rec_type IS RECORD
118: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: CONTR_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:

Line 119: CONTR_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,

115: G_MISS_OSI_CVB_TBL osi_cvb_tbl_type;
116:
117: TYPE osi_cnb_rec_type IS RECORD
118: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: CONTR_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:
123: G_MISS_OSI_CNB_REC osi_cnb_rec_type;

Line 120: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR

116:
117: TYPE osi_cnb_rec_type IS RECORD
118: ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: CONTR_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
120: CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:
123: G_MISS_OSI_CNB_REC osi_cnb_rec_type;
124:

Line 131: ( LKP_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,

127:
128: G_MISS_OSI_CNB_TBL osi_cnb_tbl_type;
129:
130: TYPE osi_lkp_rec_type IS RECORD
131: ( LKP_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
132: LKP_CODE VARCHAR2(100) := FND_API.G_MISS_CHAR,
133: LKP_VALUE VARCHAR2(200) := FND_API.G_MISS_CHAR
134: );
135:

Line 132: LKP_CODE VARCHAR2(100) := FND_API.G_MISS_CHAR,

128: G_MISS_OSI_CNB_TBL osi_cnb_tbl_type;
129:
130: TYPE osi_lkp_rec_type IS RECORD
131: ( LKP_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
132: LKP_CODE VARCHAR2(100) := FND_API.G_MISS_CHAR,
133: LKP_VALUE VARCHAR2(200) := FND_API.G_MISS_CHAR
134: );
135:
136: G_MISS_OSI_LKP_REC osi_lkp_rec_type;

Line 133: LKP_VALUE VARCHAR2(200) := FND_API.G_MISS_CHAR

129:
130: TYPE osi_lkp_rec_type IS RECORD
131: ( LKP_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
132: LKP_CODE VARCHAR2(100) := FND_API.G_MISS_CHAR,
133: LKP_VALUE VARCHAR2(200) := FND_API.G_MISS_CHAR
134: );
135:
136: G_MISS_OSI_LKP_REC osi_lkp_rec_type;
137:

Line 144: ( NAM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

140:
141: G_MISS_OSI_LKP_TBL osi_lkp_tbl_type;
142:
143: TYPE osi_nam_rec_type IS RECORD
144: ( NAM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: NAM_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: NAM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
147: );
148:

Line 145: NAM_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,

141: G_MISS_OSI_LKP_TBL osi_lkp_tbl_type;
142:
143: TYPE osi_nam_rec_type IS RECORD
144: ( NAM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: NAM_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: NAM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
147: );
148:
149: G_MISS_OSI_NAM_REC osi_nam_rec_type;

Line 146: NAM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR

142:
143: TYPE osi_nam_rec_type IS RECORD
144: ( NAM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: NAM_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: NAM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
147: );
148:
149: G_MISS_OSI_NAM_REC osi_nam_rec_type;
150:

Line 157: ( CC VARCHAR2(3) := FND_API.G_MISS_CHAR,

153:
154: G_MISS_OSI_NAM_TBL osi_nam_tbl_type;
155:
156: TYPE osi_ccs_rec_type IS RECORD
157: ( CC VARCHAR2(3) := FND_API.G_MISS_CHAR,
158: CENTER_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
159: );
160:
161: G_MISS_OSI_CCS_REC osi_ccs_rec_type;

Line 158: CENTER_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

154: G_MISS_OSI_NAM_TBL osi_nam_tbl_type;
155:
156: TYPE osi_ccs_rec_type IS RECORD
157: ( CC VARCHAR2(3) := FND_API.G_MISS_CHAR,
158: CENTER_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
159: );
160:
161: G_MISS_OSI_CCS_REC osi_ccs_rec_type;
162:

Line 169: ( OVM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

165:
166: G_MISS_OSI_CCS_TBL osi_ccs_tbl_type;
167:
168: TYPE osi_ovm_rec_type IS RECORD
169: ( OVM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
170: OVM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
171: );
172:
173: G_MISS_OSI_OVM_REC osi_ovm_rec_type;

Line 170: OVM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR

166: G_MISS_OSI_CCS_TBL osi_ccs_tbl_type;
167:
168: TYPE osi_ovm_rec_type IS RECORD
169: ( OVM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
170: OVM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
171: );
172:
173: G_MISS_OSI_OVM_REC osi_ovm_rec_type;
174:

Line 181: ( OVD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

177:
178: G_MISS_OSI_OVM_TBL osi_ovm_tbl_type;
179:
180: TYPE osi_ovd_rec_type IS RECORD
181: ( OVD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
182: OVD_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
183: );
184:
185: G_MISS_OSI_OVD_REC osi_ovd_rec_type;

Line 182: OVD_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR

178: G_MISS_OSI_OVM_TBL osi_ovm_tbl_type;
179:
180: TYPE osi_ovd_rec_type IS RECORD
181: ( OVD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
182: OVD_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
183: );
184:
185: G_MISS_OSI_OVD_REC osi_ovd_rec_type;
186:

Line 221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

217: p_osi_ovm_tbl out OSI_OVM_TBL_TYPE
218: );
219: PROCEDURE osi_lead_update
220: ( p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_osi_rec IN OSI_REC_TYPE,
224: p_osi_ovd_tbl IN OSI_OVD_TBL_TYPE,
225: x_return_status OUT VARCHAR2,

Line 222: p_commit IN VARCHAR2 := FND_API.G_FALSE,

218: );
219: PROCEDURE osi_lead_update
220: ( p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_osi_rec IN OSI_REC_TYPE,
224: p_osi_ovd_tbl IN OSI_OVD_TBL_TYPE,
225: x_return_status OUT VARCHAR2,
226: x_msg_count OUT VARCHAR2,